public static void Save_dispinfo(int dispid, string pid, string cmpno, string sdt, string edt, string comments, string isdisp, string crtby, string crtdt)
{
using (License_ConnectionDataContext ldb = new License_ConnectionDataContext())
{
tbl_DisciplineInfo obj = new tbl_DisciplineInfo();
if (dispid != 0)
{
obj = ldb.tbl_DisciplineInfos.Where(c => c.Disp_Info_ID == dispid).SingleOrDefault();
}
obj.Complaint_Number = cmpno;
obj.Person_ID = pid;
if (sdt != "")
{
obj.Start_Date = Convert.ToDateTime(sdt);
}
if (edt != "")
{
obj.End_Date = Convert.ToDateTime(edt);
}
obj.Comments = comments;
obj.IS_Discipline = isdisp;
if (dispid == 0)
{
obj.CreatedBy = crtby;
obj.CreatedDate = Convert.ToDateTime(crtdt);
ldb.tbl_DisciplineInfos.InsertOnSubmit(obj);
}
else
{
obj.ModifiedBy = crtby;
obj.ModifiedDate = Convert.ToDateTime(crtdt);
}
ldb.SubmitChanges();
}
}
public static void Delete_dispinfo(int dispid)
{
using (License_ConnectionDataContext ldb = new License_ConnectionDataContext())
{
tbl_DisciplineInfo obj = ldb.tbl_DisciplineInfos.Where(c => c.Disp_Info_ID == dispid).SingleOrDefault();
ldb.tbl_DisciplineInfos.DeleteOnSubmit(obj);
ldb.SubmitChanges();
}
}
