/// <summary>
/// To Insert details of Employeeattendance in tbl_EmployeeAttendance_M table
/// Created By : Nafisa, 01-06-2015
/// Modified By :
/// </summary>
/// <param name="objEmployeeattendanceBO"></param>
/// <returns></returns>
public ApplicationResult Employeeattendance_Insert_ForBioMatric(EmployeeattendanceBo objEmployeeattendanceBO, string strAttendanceList, string strFilename)
{
try
{
pSqlParameter = new SqlParameter[7];
pSqlParameter[0] = new SqlParameter("@TrustMID", SqlDbType.Int);
pSqlParameter[0].Direction = ParameterDirection.Input;
pSqlParameter[0].Value = objEmployeeattendanceBO.TrustMID;
pSqlParameter[1] = new SqlParameter("@SchoolMID", SqlDbType.Int);
pSqlParameter[1].Direction = ParameterDirection.Input;
pSqlParameter[1].Value = objEmployeeattendanceBO.SchoolMID;
pSqlParameter[2] = new SqlParameter("@IsManual", SqlDbType.Int);
pSqlParameter[2].Direction = ParameterDirection.Input;
pSqlParameter[2].Value = objEmployeeattendanceBO.IsManual;
pSqlParameter[3] = new SqlParameter("@CreateModifiedUserID", SqlDbType.Int);
pSqlParameter[3].Direction = ParameterDirection.Input;
pSqlParameter[3].Value = objEmployeeattendanceBO.CreateModifiedUserID;
pSqlParameter[4] = new SqlParameter("@CreatedModifiedDate", SqlDbType.VarChar);
pSqlParameter[4].Direction = ParameterDirection.Input;
pSqlParameter[4].Value = objEmployeeattendanceBO.CreatedModifiedDate;
pSqlParameter[5] = new SqlParameter("@AttendanceList", SqlDbType.VarChar);
pSqlParameter[5].Direction = ParameterDirection.Input;
pSqlParameter[5].Value = strAttendanceList;
pSqlParameter[6] = new SqlParameter("@Filename", SqlDbType.VarChar);
pSqlParameter[6].Direction = ParameterDirection.Input;
pSqlParameter[6].Value = strFilename;
sSql = "usp_tbl_EmployeeAttendance_M_Insert_ForBiomatric";
int iResult = Database.ExecuteNonQuery(CommandType.StoredProcedure, sSql, pSqlParameter);
if (iResult > 0)
{
ApplicationResult objResults = new ApplicationResult();
objResults.status = ApplicationResult.CommonStatusType.SUCCESS;
return(objResults);
}
else
{
ApplicationResult objResults = new ApplicationResult();
objResults.status = ApplicationResult.CommonStatusType.FAILURE;
return(objResults);
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
objEmployeeattendanceBO = null;
}
}
protected void btnUpload_OnClick(object sender, EventArgs e)
{
try
{
if (FileUpload1.HasFile)
{
EmployeeattendanceBl objEmployeeAttendenceBL = new EmployeeattendanceBl();
EmployeeattendanceBo objEmployeeAttendenceBO = new EmployeeattendanceBo();
ApplicationResult objResults = new ApplicationResult();
ApplicationResult objBiomatric = new ApplicationResult();
string filename = Path.GetFileName(FileUpload1.FileName);
FileUpload1.SaveAs(Server.MapPath("../Attendance/") + filename);
StreamReader objInput = new StreamReader(Server.MapPath("../Attendance/" + filename),
System.Text.Encoding.Default);
string contents = objInput.ReadToEnd().Trim();
string[] split = System.Text.RegularExpressions.Regex.Split(contents, "\\s+", RegexOptions.None);
var Attendance = string.Empty;
foreach (string row in split)
{
if (Attendance == "")
{
Attendance = row.Replace("X", "");
}
else
{
Attendance = Attendance + "," + row.Replace("X", "");
}
}
if (Attendance != "")
{
objEmployeeAttendenceBO.TrustMID =
Convert.ToInt32(Session[ApplicationSession.TRUSTID].ToString());
objEmployeeAttendenceBO.SchoolMID =
Convert.ToInt32(Session[ApplicationSession.SCHOOLID].ToString());
objEmployeeAttendenceBO.IsManual = 0; // 0 for Biomatric and 1 for Manual attendance.
objEmployeeAttendenceBO.CreateModifiedUserID =
Convert.ToInt32(Session[ApplicationSession.USERID]);
objEmployeeAttendenceBO.CreatedModifiedDate = DateTime.UtcNow.AddHours(5.5).ToString();
//objBiomatric = objEmployeeAttendenceBL.Employeeattendance_Select_ForBiomatric(Attendance,
// filename);
//if (objBiomatric != null)
//{
// if (objBiomatric.resultDT.Rows.Count > 0)
// {
// ScriptManager.RegisterStartupScript(this, this.GetType(), "CallConfirmBox", "CallConfirmBox();", true);
// }
//}
//else
//{
//}
objResults = objEmployeeAttendenceBL.Employeeattendance_Insert_ForBioMatric(
objEmployeeAttendenceBO, Attendance, filename);
}
objInput.Close();
System.IO.File.Delete(Server.MapPath("../Attendance/" + filename));
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Employee Attendance Updated Successfully.');</script>");
}
else
{
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Select the File.');</script>");
}
}
catch (Exception ex)
{
logger.Error("Error", ex);
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Oops! There is some technical issue. Please Contact to your administrator.');</script>");
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
EmployeeattendanceBl objEmployeeAttendenceBL = new EmployeeattendanceBl();
EmployeeattendanceBo objEmployeeAttendenceBO = new EmployeeattendanceBo();
ApplicationResult objResults = new ApplicationResult();
try
{
int intCount = 0;
int k = 0;
DatabaseTransaction.OpenConnectionTransation();
foreach (GridViewRow row in gvEmployee.Rows)
{
ViewState["EmployeeMID"] = Convert.ToInt32(row.Cells[0].Text);
objEmployeeAttendenceBO.EmployeeMID = Convert.ToInt32(row.Cells[0].Text);
objEmployeeAttendenceBO.TrustMID = Convert.ToInt32(Session[ApplicationSession.TRUSTID]);
objEmployeeAttendenceBO.SchoolMID = Convert.ToInt32(Session[ApplicationSession.SCHOOLID]);
objEmployeeAttendenceBO.Date = txtdate.Text;
objEmployeeAttendenceBO.InTime =
(((TextBox)row.FindControl("txtIntime")).Text);
objEmployeeAttendenceBO.OutTime =
(((TextBox)row.FindControl("txtOuttime")).Text);
objEmployeeAttendenceBO.Time = (((Label)row.FindControl("lblTime")).Text);
objEmployeeAttendenceBO.TotalTime = (((TextBox)row.FindControl("txtTotalTime")).Text);
if (((CheckBox)row.FindControl("chkChild")).Checked)
{
intCount += 1;
if (objEmployeeAttendenceBO.InTime == "0" || objEmployeeAttendenceBO.OutTime == "0" || objEmployeeAttendenceBO.InTime == "" || objEmployeeAttendenceBO.OutTime == "")
{
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp",
"<script language='javascript'>alert('Please Fill Time " + row.Cells[0].Text +
".');</script>");
break;
}
DateTime dtIntime = Convert.ToDateTime((((TextBox)row.FindControl("txtIntime")).Text));
DateTime dtOutTime = Convert.ToDateTime((((TextBox)row.FindControl("txtOuttime")).Text));
if (dtIntime >= dtOutTime)
{
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp",
"<script language='javascript'>alert('Time Format Should be 24Hours Or OutTime Must be greater then InTime.');</script>");
break;
}
else
{
ApplicationResult objResultsInsert = new ApplicationResult();
if (ViewState["Mode"].ToString() == "Save")
{
objEmployeeAttendenceBO.CreatedModifiedDate = DateTime.UtcNow.AddHours(5.5).ToString();
objEmployeeAttendenceBO.CreateModifiedUserID = Convert.ToInt32(Session[ApplicationSession.USERID]);
objResultsInsert =
objEmployeeAttendenceBL.Employeeattendance_Insert(objEmployeeAttendenceBO);
divGrid.Visible = false;
btnSave.Enabled = false;
k += 1;
}
else
{
objEmployeeAttendenceBO.LastModifiedDate = DateTime.UtcNow.AddHours(5.5).ToString();
objEmployeeAttendenceBO.LastModifiedUserID = Convert.ToInt32(Session[ApplicationSession.USERID]);
objEmployeeAttendenceBO.EmployeeMID = Convert.ToInt32(ViewState["EmployeeMID"].ToString());
objResults = objEmployeeAttendenceBL.Employeeattendance_Update(objEmployeeAttendenceBO);
if (objResults.status == ApplicationResult.CommonStatusType.SUCCESS)
{
k += 1;
divGrid.Visible = false;
btnSave.Enabled = false;
}
}
}
}
}
if (k == intCount)
{
DatabaseTransaction.CommitTransation();
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script language='javascript'>alert('Employee Attendence saved Successfully.');</script>");
divNote.Visible = false;
}
else
{
DatabaseTransaction.RollbackTransation();
}
}
catch (Exception ex)
{
DatabaseTransaction.RollbackTransation();
DatabaseTransaction.connection.Close();
logger.Error("Error", ex);
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Oops! There is some technical issue. Please Contact to your administrator.');</script>");
}
}
/// <summary>
/// To Update details of Employeeattendance in tbl_EmployeeAttendance_M table
/// Created By : Nafisa, 01-06-2015
/// Modified By :
/// </summary>
/// <param name="objEmployeeattendanceBO"></param>
/// <returns></returns>
public ApplicationResult Employeeattendance_Update(EmployeeattendanceBo objEmployeeattendanceBO)
{
try
{
pSqlParameter = new SqlParameter[10];
pSqlParameter[0] = new SqlParameter("@EmployeeMID", SqlDbType.Int);
pSqlParameter[0].Direction = ParameterDirection.Input;
pSqlParameter[0].Value = objEmployeeattendanceBO.EmployeeMID;
pSqlParameter[1] = new SqlParameter("@TrustMID", SqlDbType.Int);
pSqlParameter[1].Direction = ParameterDirection.Input;
pSqlParameter[1].Value = objEmployeeattendanceBO.TrustMID;
pSqlParameter[2] = new SqlParameter("@SchoolMID", SqlDbType.Int);
pSqlParameter[2].Direction = ParameterDirection.Input;
pSqlParameter[2].Value = objEmployeeattendanceBO.SchoolMID;
pSqlParameter[3] = new SqlParameter("@InTime", SqlDbType.VarChar);
pSqlParameter[3].Direction = ParameterDirection.Input;
pSqlParameter[3].Value = objEmployeeattendanceBO.InTime;
pSqlParameter[4] = new SqlParameter("@OutTime", SqlDbType.VarChar);
pSqlParameter[4].Direction = ParameterDirection.Input;
pSqlParameter[4].Value = objEmployeeattendanceBO.OutTime;
pSqlParameter[5] = new SqlParameter("@Date", SqlDbType.VarChar);
pSqlParameter[5].Direction = ParameterDirection.Input;
pSqlParameter[5].Value = objEmployeeattendanceBO.Date;
pSqlParameter[6] = new SqlParameter("@LastModifiedUserID", SqlDbType.Int);
pSqlParameter[6].Direction = ParameterDirection.Input;
pSqlParameter[6].Value = objEmployeeattendanceBO.LastModifiedUserID;
pSqlParameter[7] = new SqlParameter("@LastModifiedDate", SqlDbType.VarChar);
pSqlParameter[7].Direction = ParameterDirection.Input;
pSqlParameter[7].Value = objEmployeeattendanceBO.LastModifiedDate;
pSqlParameter[8] = new SqlParameter("@Time", SqlDbType.VarChar);
pSqlParameter[8].Direction = ParameterDirection.Input;
pSqlParameter[8].Value = objEmployeeattendanceBO.Time;
pSqlParameter[9] = new SqlParameter("@TotalTime", SqlDbType.VarChar);
pSqlParameter[9].Direction = ParameterDirection.Input;
pSqlParameter[9].Value = objEmployeeattendanceBO.TotalTime;
sSql = "usp_tbl_EmployeeAttendance_M_Update";
int iResult = Database.ExecuteNonQuery(CommandType.StoredProcedure, sSql, pSqlParameter);
if (iResult > 0)
{
ApplicationResult objResults = new ApplicationResult();
objResults.status = ApplicationResult.CommonStatusType.SUCCESS;
return(objResults);
}
else
{
ApplicationResult objResults = new ApplicationResult();
objResults.status = ApplicationResult.CommonStatusType.FAILURE;
return(objResults);
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
objEmployeeattendanceBO = null;
}
}
