void Save()
{
if (SystemProperties.ShowMessage.MessageQuestion(SystemProperties.MessageNotification.YouWantToSave, "Year level") == DialogResult.Yes)
{
if (!string.IsNullOrWhiteSpace(txtYearLevel.Text))
{
using (Maintenance _maintain = new Maintenance())
{
T_YearLevel value = new T_YearLevel();
value.ID = isAdd ? 0 : Convert.ToInt64(dgYearLevel.SelectedRows[0].Cells[0].Value.ToString());
value.YearLevel = txtYearLevel.Text;
value.Active = cbActive.Checked;
value.Count = Convert.ToInt32(txtCount.Value);
_maintain.Save(value, ref MsgReturned);
SystemProperties.ShowMessage.MessageInformation(MsgReturned, "Year level");
SystemProperties.Cleared(this, false, true, true);
}
}
else
{
SystemProperties.ShowMessage.MessageError(SystemProperties.MessageNotification.CheckInput + Environment.NewLine + Environment.NewLine + "Year level", "Year level");
}
}
LoadYearLevel();
}
public void Save(T_YearLevel value, ref string msg)
{
T_YearLevel valueupdate = new T_YearLevel();
using (AttMonSysRFIDDataContext dc = new AttMonSysRFIDDataContext(SystemConnection.ConnectionString))
{
//check data is already exist
if (Compare(value))
{
//is Save New
if (value.ID == 0)
{
dc.T_YearLevels.InsertOnSubmit(value);
msg = string.Format("{0} " + Environment.NewLine + Environment.NewLine + "{1}" + Environment.NewLine + " {2}", SystemProperties.MessageNotification.Saved, value.YearLevel, value.Active);
}
// Is Update
else
{
valueupdate = dc.T_YearLevels.Where(x => x.ID == value.ID).FirstOrDefault();
valueupdate.YearLevel = value.YearLevel;
valueupdate.Active = value.Active;
valueupdate.Count = value.Count;
msg = string.Format("{0} " + Environment.NewLine + Environment.NewLine + "{1}" + Environment.NewLine + " {2}", SystemProperties.MessageNotification.Updated, valueupdate.YearLevel, valueupdate.Active);
}
dc.SubmitChanges();
}
else
{
msg = string.Format("{0} " + Environment.NewLine + Environment.NewLine + "{1}" + Environment.NewLine + " {2}", SystemProperties.MessageNotification.Exist, value.YearLevel, value.Active);
}
}
}
public bool Compare(T_YearLevel value)
{
using (AttMonSysRFIDDataContext dc = new AttMonSysRFIDDataContext(SystemConnection.ConnectionString))
{
return(dc.T_YearLevels.Where(x => x.Count == value.Count && x.Active == value.Active && x.YearLevel.ToLower() == value.YearLevel.ToLower()).FirstOrDefault() == null ? true : false);
}
}
public void Delete(T_YearLevel value, ref string msg)
{
T_YearLevel valuedelete = new T_YearLevel();
using (AttMonSysRFIDDataContext dc = new AttMonSysRFIDDataContext(SystemConnection.ConnectionString))
{
valuedelete = dc.T_YearLevels.Where(x => x.ID == value.ID).FirstOrDefault();
msg = string.Format("{0} " + Environment.NewLine + Environment.NewLine + "{1}" + Environment.NewLine + " {2}", SystemProperties.MessageNotification.Deleted, valuedelete.YearLevel, valuedelete.Active);
dc.T_YearLevels.DeleteOnSubmit(valuedelete);
dc.SubmitChanges();
}
}
void Delete()
{
if (SystemProperties.ShowMessage.MessageQuestion(SystemProperties.MessageNotification.YouWantToDelete, "Year level") == DialogResult.Yes)
{
if (!string.IsNullOrWhiteSpace(txtYearLevel.Text))
{
T_YearLevel value = new T_YearLevel();
value.ID = Convert.ToInt64(dgYearLevel.SelectedRows[0].Cells[0].Value.ToString());
using (Maintenance _maintain = new Maintenance())
{
_maintain.Delete(value, ref MsgReturned);
SystemProperties.ShowMessage.MessageInformation(MsgReturned, "Year level");
}
}
else
{
SystemProperties.ShowMessage.MessageError(SystemProperties.MessageNotification.SelectFirst + " delete", "Year level");
}
}
LoadYearLevel();
}