//Save Action #region [Save Action] private void SaveAction(string strAction) { try { EWA_EmpStudAttendance objEWA = new EWA_EmpStudAttendance(); BL_EmpStudAttendance objBL = new BL_EmpStudAttendance(); DataSet dsData = new DataSet(); dsData = FetchData(); objEWA.EmpCode = dsData.Tables[0].Rows[0]["EmployeeId"].ToString(); objEWA.AttendanceDate = dsData.Tables[0].Rows[0]["AttendanceDate"].ToString(); objEWA.InTime = dsData.Tables[0].Rows[0]["InTime"].ToString(); objEWA.OutTime = dsData.Tables[0].Rows[0]["OutTime"].ToString(); objEWA.PunchingRecords = dsData.Tables[0].Rows[0]["PunchRecords"].ToString(); //objEWA.Leave = dsData.Tables[0].Rows[0]["Leave"].ToString(); objEWA.Status = dsData.Tables[0].Rows[0]["Status"].ToString(); //Below Values Need to be pass from session objEWA.Action = "SaveEmpAttendance"; objEWA.OrgId = orgId; DataTable dtEmpattendance = new DataTable(); dtEmpattendance = dsData.Tables[0] as DataTable; int flag = objBL.SaveAction_BL(objEWA, dtEmpattendance); } catch (Exception exp) { GeneralErr(exp.Message.ToString()); } }
// Save Student Registration #region [Save EMP Stud Attendance] public int SaveAction_BL(EWA_EmpStudAttendance objEWA, DataTable dtEmpattendance) { try { DL_EmpStudAttendance objDL = new DL_EmpStudAttendance(); int flag = objDL.SaveAction_DL(objEWA, dtEmpattendance); return(flag); } catch (Exception) { throw; } }
//Student Action #region [StudentInsert] public int SaveAction_DL(EWA_EmpStudAttendance objEWA, DataTable dtEmpAttendance) { try { cmd = new SqlCommand("SP_EmployeeStudentAttendance", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Action", objEWA.Action); //Save data in StudentFeesPaid Table SqlParameter tblvaluetype = cmd.Parameters.AddWithValue("@EmployeeAttendance", dtEmpAttendance); //Passing table value parameter tblvaluetype.SqlDbType = SqlDbType.Structured; con.Open(); int flag = cmd.ExecuteNonQuery(); con.Close(); return(flag); } catch (Exception) { throw; } }