public static void DeleteFormalHearingdoc(int hearingid)
{
using (ComplaintsDataContext cdc = new ComplaintsDataContext())
{
tbl_Complaints_Hearing_Document obj = cdc.tbl_Complaints_Hearing_Documents.Where(c => c.Hearing_Document_ID == hearingid).SingleOrDefault();
cdc.tbl_Complaints_Hearing_Documents.DeleteOnSubmit(obj);
cdc.SubmitChanges();
}
}
public static int Insert_HearingDocument(int hearingid, int cmpid, int personid, string duedate, string receiveddoc, string createdby, string doctype)
{
using (ComplaintsDataContext cdc = new ComplaintsDataContext())
{
tbl_Complaints_Hearing_Document hearing;
if (hearingid == 0)
{
hearing = new tbl_Complaints_Hearing_Document();
}
else
{
hearing = cdc.tbl_Complaints_Hearing_Documents.Where(c => c.Hearing_Document_ID == hearingid).SingleOrDefault();
}
hearing.Hearing_Document_ID = hearingid;
hearing.Cmp_ID = cmpid;
hearing.Person_ID = personid;
if (duedate != "")
{
hearing.Document_Due_Date = Convert.ToDateTime(duedate);
}
hearing.Document_Received = receiveddoc;
hearing.Document_Type = doctype;
if (hearingid == 0)
{
hearing.Created_By = createdby;
hearing.Created_Date = Convert.ToDateTime(DateTime.Now.ToShortDateString());
}
else
{
hearing.Modified_By = createdby;
hearing.Modified_Date = Convert.ToDateTime(DateTime.Now.ToShortDateString());
}
if (hearingid == 0)
{
cdc.tbl_Complaints_Hearing_Documents.InsertOnSubmit(hearing);
}
cdc.SubmitChanges();
return(hearing.Hearing_Document_ID);
}
}
