/// <summary> /// Function to Daily Attendance Details Add Using MasterId /// </summary> /// <param name="dailyattendancedetailsinfo"></param> public void DailyAttendanceDetailsAddUsingMasterId(DailyAttendanceDetailsInfo dailyattendancedetailsinfo) { try { if (sqlcon.State == ConnectionState.Closed) { sqlcon.Open(); } SqlCommand sccmd = new SqlCommand("DailyAttendanceDetailsAddUsingMasterId", sqlcon); sccmd.CommandType = CommandType.StoredProcedure; SqlParameter sprmparam = new SqlParameter(); sprmparam.Value = dailyattendancedetailsinfo.DailyAttendanceDetailsId; sprmparam = sccmd.Parameters.Add("@dailyAttendanceMasterId", SqlDbType.Decimal); sprmparam.Value = dailyattendancedetailsinfo.DailyAttendanceMasterId; sprmparam = sccmd.Parameters.Add("@employeeId", SqlDbType.Decimal); sprmparam.Value = dailyattendancedetailsinfo.EmployeeId; sprmparam = sccmd.Parameters.Add("@status", SqlDbType.VarChar); sprmparam.Value = dailyattendancedetailsinfo.Status; sprmparam = sccmd.Parameters.Add("@narration", SqlDbType.VarChar); sprmparam.Value = dailyattendancedetailsinfo.Narration; sprmparam = sccmd.Parameters.Add("@extra1", SqlDbType.VarChar); sprmparam.Value = dailyattendancedetailsinfo.Extra1; sprmparam = sccmd.Parameters.Add("@extra2", SqlDbType.VarChar); sprmparam.Value = dailyattendancedetailsinfo.Extra2; int ineffectedrow = sccmd.ExecuteNonQuery(); } catch (Exception ex) { MessageBox.Show(ex.ToString()); } finally { sqlcon.Close(); } }
public void DailyAttendanceDetailsEditUsingMasterId(DailyAttendanceDetailsInfo dailyattendancedetailsinfo) { try { SpDailyAttendanceDetails.DailyAttendanceDetailsEditUsingMasterId(dailyattendancedetailsinfo); } catch (Exception ex) { MessageBox.Show("A3" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
/// <summary> /// Function to get particular values from DailyAttendanceDetails Table based on the parameter /// </summary> /// <param name="dailyAttendanceDetailsId"></param> /// <returns></returns> public DailyAttendanceDetailsInfo DailyAttendanceDetailsView(decimal dailyAttendanceDetailsId) { DailyAttendanceDetailsInfo dailyattendancedetailsinfo = new DailyAttendanceDetailsInfo(); SqlDataReader sdrreader = null; try { if (sqlcon.State == ConnectionState.Closed) { sqlcon.Open(); } SqlCommand sccmd = new SqlCommand("DailyAttendanceDetailsView", sqlcon); sccmd.CommandType = CommandType.StoredProcedure; SqlParameter sprmparam = new SqlParameter(); sprmparam = sccmd.Parameters.Add("@dailyAttendanceDetailsId", SqlDbType.Decimal); sprmparam.Value = dailyAttendanceDetailsId; sdrreader = sccmd.ExecuteReader(); while (sdrreader.Read()) { dailyattendancedetailsinfo.DailyAttendanceDetailsId = decimal.Parse(sdrreader[0].ToString()); dailyattendancedetailsinfo.DailyAttendanceMasterId = decimal.Parse(sdrreader[1].ToString()); dailyattendancedetailsinfo.EmployeeId = decimal.Parse(sdrreader[2].ToString()); dailyattendancedetailsinfo.Status = sdrreader[3].ToString(); dailyattendancedetailsinfo.Narration = sdrreader[4].ToString(); dailyattendancedetailsinfo.ExtraDate = DateTime.Parse(sdrreader[5].ToString()); dailyattendancedetailsinfo.Extra1 = sdrreader[6].ToString(); dailyattendancedetailsinfo.Extra2 = sdrreader[7].ToString(); } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } finally { sdrreader.Close(); sqlcon.Close(); } return dailyattendancedetailsinfo; }