strNewLeave = "insert into [Leave]([ID],[EmployeeNo],[AgentID],[LeaveType],[StartDate],[EndDate],[Hours],[LeaveReason],[ReportTime],[ReportID],[ImageName],[ImageData]) ";
strNewLeave += "values(@LeaveNo,@EmpNo,@AgentName,@LeaType,@StartDate,@EndDate,@Hours,@Reason,getdate(),@Admin,@ImageName,@Image) ";
sqlPara = new SqlParameter[] {
new SqlParameter("@LeaveNo",strLeaNo),
new SqlParameter("@EmpNo",strEmpNo),
new SqlParameter("@AgentName",strAgentID),
new SqlParameter("@LeaType",strLeaType),
new SqlParameter("@StartDate",strDateSt),
new SqlParameter("@EndDate",strDateEnd),
new SqlParameter("@Hours",strHours),
new SqlParameter("@Reason",strReason),
new SqlParameter("@Admin",strAdmin),
new SqlParameter("@ImageName",strImageName),
new SqlParameter("@Image",FileByteArray)
};
StreamObject.Close();
}
</div>
context.Response.OutputStream.Write(MyData, 0, ArraySize);
}
</div>