private void btnSave_Click(object sender, EventArgs e)
{
Cursor = Cursors.WaitCursor;
try
{
if (validate() == true)
{
ShiftBAL _objBAL = new ShiftBAL();
ShiftModel _objModel = new ShiftModel();
_objModel._ShiftID = selectedRecordId;
_objModel._StartTime = Convert.ToDateTime(dtpStartTime.Text);
_objModel._EndTime = Convert.ToDateTime(dtpEndTime.Text);
_objModel._ShiftName = tbxShiftName.Text;
_objModel._ModifiedDate = DateTime.Now;
if (selectedRecordId == 0)
{
_objBAL.SaveShift(_objModel);
}
else
{
_objBAL.UpdateShift(_objModel);
}
MakeEmpty();
MessageBox.Show("Record Saved Successfully!");
FillGrid();
}
}
catch
{ }
finally
{
Cursor = Cursors.Default;
}
}
private void btnDelete_Click(object sender, EventArgs e)
{
if (selectedRecordId != 0)
{
try
{
Cursor = Cursors.WaitCursor;
ShiftBAL _objBAL = new ShiftBAL();
_objBAL.DeleteShift(selectedRecordId);
MessageBox.Show("Record has been deleted successfully!");
FillGrid();
}
catch (System.Data.SqlClient.SqlException sqlEx)
{
if (sqlEx.Number == 547)
{
MessageBox.Show("You cannot delete this record. Its refference exists in other documents.");
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
finally
{
Cursor = Cursors.Default;
}
MakeEmpty();
}
}
private void FillShiftList()
{
ShiftBAL _objBAL = new ShiftBAL();
List <ShiftModel> ShiftList = new List <ShiftModel>();
ShiftList = _objBAL.GetShiftList();
cmbShift.DataSource = ShiftList;
cmbShift.DisplayMember = "_ShiftName";
cmbShift.ValueMember = "_ShiftID";
cmbShift.SelectedIndex = -1;
cmbShift.Text = "Select Shift";
}
private void FillForm(Int32 _ShiftId)
{
try
{
ShiftBAL _objBAL = new ShiftBAL();
ShiftModel _objModel = _objBAL.SearchShift(_ShiftId);
dtpStartTime.Text = _objModel._StartTime.ToString();
tbxShiftName.Text = _objModel._ShiftName;
dtpEndTime.Text = _objModel._EndTime.ToString();
tbxModifiedDate.Text = _objModel._ModifiedDate.ToString();
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
private void FillGrid()
{
ShiftBAL _objBAL = new ShiftBAL();
List <ShiftModel> ShiftList = new List <ShiftModel>();
grdShifts.DataSource = null;
grdShifts.Rows.Clear();
ShiftList = _objBAL.GetShiftList();
grdShifts.AutoGenerateColumns = false;
int count = 0;
foreach (var item in ShiftList)
{
count++;
grdShifts.Rows.Add(item._ShiftID, item._ShiftName, item._StartTime.TimeOfDay, item._EndTime.TimeOfDay, item._ModifiedDate);
}
tbxCount.Text = count.ToString();
}
