示例#1
0
        //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;
     }
 }
示例#3
0
        //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;
            }
        }