public static void CompaintsUpdateValues(TbL_Complaint ObjCompUpdate)
{
using (ComplaintsTabDataContext dbUpdate = new ComplaintsTabDataContext())
{
TbL_Complaint obj = ObjCompUpdate;
dbUpdate.SubmitChanges();
}
}
public static void ComplaintInsertValues(TbL_Complaint complaint)
{
using (ComplaintsDataContext dbInsert = new ComplaintsDataContext())
{
string cmpnumber = "";
dbInsert.USP_Licensing_Complaints(101, complaint.Complaint_ID, complaint.Respondent_type, complaint.Respondent_ID, complaint.Complaint_Number,
Convert.ToInt16(complaint.Source_Id), Convert.ToInt16(complaint.Category_Id), complaint.DateReceived.ToString(), complaint.DateDocketed.ToString(), complaint.Address1, complaint.Address2,
complaint.City, complaint.State, complaint.Zip, Convert.ToInt16(complaint.PersonResponcible_ID), complaint.ComplaintType, Convert.ToInt16(complaint.InvestiGator_ID), complaint.SecondInvestigatiorID,
complaint.DateInvestigatorAssigned, complaint.DateInvestigatorReceived, complaint.Consultant, complaint.CompanionCase_ID, complaint.Compainant, complaint.Complaint_Status,
complaint.check_number, complaint.Create_User, complaint.Create_Date, ref cmpnumber);
dbInsert.SubmitChanges();
}
}
protected void btn_submit_click(object sender, EventArgs e)
{
string complaintnumber = "";
DateTime dt = System.DateTime.Now;
string year = dt.Year.ToString();
if (ddl_source.SelectedValue == "1257" || ddl_source.SelectedValue == "1038" || ddl_source.SelectedValue == "1039" || ddl_source.SelectedValue == "1040" || ddl_source.SelectedValue == "1041" || ddl_source.SelectedValue == "1417" || ddl_source.SelectedValue == "1419")
{
complaintnumber = year.Substring(2) + "-L-";
}
else if (ddl_source.SelectedValue == "1259")
{
complaintnumber = year.Substring(2) + "-F-";
}
else
{
complaintnumber = year.Substring(2) + "-";
}
string temp = "";
TbL_Complaint objtblComplaint = new TbL_Complaint();
objtblComplaint.Complaint_ID = 0;
objtblComplaint.Respondent_type = "1";
objtblComplaint.Respondent_ID = Convert.ToInt32(hfdpid.Value);
objtblComplaint.Complaint_Number = complaintnumber;
objtblComplaint.Source_Id = ddl_source.SelectedValue.ToString();
objtblComplaint.Category_Id = ddl_category.SelectedValue.ToString();
if (txt_daterec.Text != "")
{
objtblComplaint.DateReceived = Convert.ToDateTime(txt_daterec.Text.ToString());
}
else
{
objtblComplaint.DateReceived = null;
}
//if(txt_datedocketed.Text!="")
//objtblComplaint.DateDocketed = txt_datedocketed.Text.ToString();
objtblComplaint.Address1 = "";
objtblComplaint.Address2 = "";
objtblComplaint.City = "";
objtblComplaint.State = "";
objtblComplaint.Zip = "";
objtblComplaint.PersonResponcible_ID = ddl_personresp.SelectedValue.ToString();
objtblComplaint.ComplaintType = "1";
objtblComplaint.InvestiGator_ID = ddl_investigater.SelectedValue.ToString();
objtblComplaint.SecondInvestigatiorID = ddl_investigater1.SelectedValue.ToString();
if (txt_dateassigned.Text.Length > 0)
{
objtblComplaint.DateInvestigatorAssigned = Convert.ToDateTime(txt_dateassigned.Text.ToString());
}
if (txt_dateinRec.Text.Length > 0)
{
objtblComplaint.DateInvestigatorReceived = Convert.ToDateTime(txt_dateinRec.Text.ToString());
}
objtblComplaint.Consultant = "0";
objtblComplaint.CompanionCase_ID = "0";
objtblComplaint.Compainant = txtcomplainant.Text; //Convert.ToInt16(ddl_complainant.SelectedValue.ToString());
objtblComplaint.Complaint_Status = "885";
objtblComplaint.check_number = temp;
objtblComplaint.Create_User = Convert.ToInt32(Session["UID"].ToString());
objtblComplaint.Create_Date = Convert.ToDateTime(DateTime.Now.ToShortDateString());
ComplaintsLink.Complaints.ComplaintInsertValues(objtblComplaint);
GetComplaintNumber();
Response.Redirect("../PersonLicensing/PersonDetails.aspx?pid=" + hfdpid.Value + "&iscmp=1");
}
