public void InsertRecord(Objects.DailyAttendance obj) { try { SqlCommand cmd = new SqlCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "SP_DailyAttendanceInsert"; cmd.Parameters.AddWithValue("@EmployeeID", obj.EmployeeID); cmd.Parameters.AddWithValue("@EntryDate", obj.EntryDate); cmd.Parameters.AddWithValue("@AttendaceDateTime", obj.AttendaceDateTime); cmd.Parameters.AddWithValue("@Remarks", obj.Remarks); cmd.Parameters.AddWithValue("@UserID", obj.UserID); new Database(connectionstring).ExecuteNonQueryOnly(cmd); } catch (Exception exc) { throw exc; } }
private void btnSave_Click(object sender, EventArgs e) { try { if (txtEmployeeName.Text.Trim() == string.Empty) { Message.ShowMessage(MyMessages.MessageType.MissingInfo, "Please Select an Employee first."); txtEmployeeID.Focus(); return; } DataTable dt = new DataTable(); if (!vOpenMode) { dt = objDAL.getRecord(string.Format(" AND (convert(datetime,Convert(varchar,DailyAttendance.AttendaceDateTime,1)) = Convert(Datetime,(convert(varchar,convert(Datetime,'{0} 00:00:00',102),1)))) and Employees.EmployeeID={1}", dtDateTime.Value.ToShortDateString(), txtEmployeeID.Text)); if (dt.Rows.Count > 0) { Message.ShowMessage(MyMessages.MessageType.General, "Attendance Already Entered."); return; } } else { dt = objDAL.getRecord(string.Format(" AND (convert(datetime,Convert(varchar,DailyAttendance.AttendaceDateTime,1)) = Convert(Datetime,(convert(varchar,convert(Datetime,'{0} 00:00:00',102),1)))) AND Employees.EmployeeID={1} AND DailyAttendance.AttendanceID<>{2}", dtDateTime.Value.ToShortDateString(), txtEmployeeID.Text, txtID.Text)); if (dt.Rows.Count > 0) { Message.ShowMessage(MyMessages.MessageType.General, "Attendance Already Entered."); return; } } Objects.DailyAttendance obj = new Objects.DailyAttendance(); obj.AttendanceID = Int64.Parse(txtID.Text); obj.EmployeeID = Int64.Parse(txtEmployeeID.Text); obj.EntryDate = DateTime.Now; obj.AttendaceDateTime = dtDateTime.Value; obj.Remarks = txtRemarks.Text.Trim(); obj.UserID = vUserID; if (!vOpenMode) { //Insert objDAL.InsertRecord(obj); } else { // UPdate objDAL.UpdateRecord(obj); } Message.ShowMessage(MyMessages.MessageType.SaveRecord); LoadGrid(); btnClear_Click(sender, e); } catch (Exception exc) { Message.ShowMessage(MyMessages.MessageType.Error, exc.Message); } }