protected void btnhfd_delparid_click(object sender, EventArgs e) { using (ComplaintsLink.ComplaintsDataContext cdb = new ComplaintsLink.ComplaintsDataContext()) { ComplaintsLink.TbL_Complaints_Participant obj = cdb.TbL_Complaints_Participants.Where(c => c.Cmp_Paticipant_ID == Convert.ToInt32(hfd_delparid.Value)).SingleOrDefault(); cdb.TbL_Complaints_Participants.DeleteOnSubmit(obj); cdb.SubmitChanges(); } Page.RegisterStartupScript("js", "<script>altbox('Record deleted successfully.');parent.sa5.process()</script>"); }
public void Bind_Facts() { using (ComplaintsLink.ComplaintsDataContext db = new ComplaintsLink.ComplaintsDataContext()) { //var obj = db.USP_Complaint_GetFindingOfFacts(comid); System.Data.Linq.ISingleResult <ComplaintsLink.USP_Complaint_GetFindingOfFactsResult> result = db.USP_Complaint_GetFindingOfFacts(comid); foreach (ComplaintsLink.USP_Complaint_GetFindingOfFactsResult li in result) { lblfactid.Text = li.Cmp_FindfactsId.ToString(); txtfindingoffacts.Text = li.FindingOfFact.ToString(); } } }
private void Bindconlaw() { using (ComplaintsLink.ComplaintsDataContext db = new ComplaintsLink.ComplaintsDataContext()) { var obj = db.TbL_Complaints_ConclusionOfLaws.Where(i => i.Cmp_Id == comid.ToString()).SingleOrDefault(); //var obj = db.USP_Complaint_GetFindingOfFacts(comid); System.Data.Linq.ISingleResult <ComplaintsLink.USP_Complaint_GetFindingOfFactsResult> result = db.USP_Complaint_GetFindingOfFacts(comid); chk_administarativecode.ClearSelection(); foreach (ListItem lin in chk_administarativecode.Items) { lin.Attributes.Add("onclick", "javascript:addtextarea(this)"); } if (obj != null) { hfdconlaw.Value = obj.ConclusionLaw_Id.ToString(); string[] temp = obj.ConclusionLawcode.Split(','); txtsummaryconclusionoflaw.Text = obj.ConclusionText; //for (int i = 0; i < temp.Length; i++) // { //chk_administarativecode.Items.FindByValue(temp[i].ToString()).Selected = true; // chk_administarativecode.Items.FindByValue(temp[i].ToString()).Attributes.Add("onclick", "javascript:addtextarea(this)"); // chk_administarativecode.Items[Convert.ToInt16(temp[i].ToString())].Selected = true; // } } } }
public void BindDrpDownLists() { using (ComplaintsLink.ComplaintsDataContext db = new ComplaintsLink.ComplaintsDataContext()) { //ddlrequester.DataSource = db.tbl_lkp_Complaints_requestors.ToList();//id=51 //ddlrequester.DataValueField = "reques_id"; //ddlrequester.DataTextField = "Description"; //ddlrequester.DataBind(); //ddlrequester.Items.Insert(0, new ListItem("--Select--", "-1")); utilities.BindDropdown(ddlrequester, 51); //ddlparticipantRole.DataSource = db.tbl_lkp_participant_roles.ToList();//id=46 //ddlparticipantRole.DataValueField = "Role_ID"; //ddlparticipantRole.DataTextField = "Description"; //ddlparticipantRole.DataBind(); //ddlparticipantRole.Items.Insert(0, new ListItem("--Select--", "-1")); //ddlservicecountry.DataSource = db.tbl_LKP_Counties.ToList();//id=6 //ddlservicecountry.DataValueField = "County"; //ddlservicecountry.DataTextField = "County"; //ddlservicecountry.DataBind(); //ddlservicecountry.Items.Insert(0, new ListItem("Select County", "-1")); utilities.BindDropdown(ddlservicecountry, 6); //ddlJournalType.DataSource = db.tbl_Lkp_Complaints_JournalTypes.OrderBy(c => c.Description).ToList();//id=3 //ddlJournalType.DataValueField = "Journal_Type_Id"; //ddlJournalType.DataTextField = "Description"; //ddlJournalType.DataBind(); //ddlJournalType.Items.Insert(0, new ListItem("Select Journal", "-1")); utilities.BindDropdown(ddlJournalType, 6); //ddlserdocument.DataSource = db.tbl_LKP_ServiceDocumentTypes.OrderBy(c => c.ServiceDocumentType).ToList();//id 47 //ddlserdocument.DataValueField = "ServDocTypeId"; //ddlserdocument.DataTextField = "ServiceDocumentType"; //ddlserdocument.DataBind(); //ddlserdocument.Items.Insert(0, new ListItem("--Select--", "-1")); utilities.BindDropdown(ddlserdocument, 47); //ddlserdocument.DataSource = db.tbl_LKP_Complaints_ServiceReasons.OrderBy(c => c.ser).ToList(); //ddlservicetype.DataSource = db.tbl_LKP_Complaints_ServiceTypes.ToList();//id 48 //ddlservicetype.DataValueField = "CmpServiceType"; //ddlservicetype.DataTextField = "ServiceType"; //ddlservicetype.DataBind(); //ddlservicetype.Items.Insert(0, new ListItem("Select Service Type", "-1")); utilities.BindDropdown(ddlservicetype, 48); //ddlservicereason.DataSource = db.tbl_LKP_Complaints_ServiceReasons.ToList();//id =49 //ddlservicereason.DataValueField = "ServiceReasonId"; //ddlservicereason.DataTextField = "ServiceReason"; //ddlservicereason.DataBind(); //ddlservicereason.Items.Insert(0, new ListItem("Select Service Reason", "-1")); utilities.BindDropdown(ddlservicereason, 49); //ddleventtype.DataSource = db.tbl_LKPEventTypes.ToList();//id=50 //ddleventtype.DataValueField = "EventType_ID"; //ddleventtype.DataTextField = "EventType"; //ddleventtype.DataBind(); //ddleventtype.Items.Insert(0, new ListItem("Select EventType", "-1")); utilities.BindDropdown(ddleventtype, 50); ddleventresponseperson.DataSource = db.Tbl_Logins.ToList(); ddleventresponseperson.DataTextField = "FirstName"; ddleventresponseperson.DataValueField = "LastName"; ddleventresponseperson.DataBind(); string[] Name = new string[ddleventresponseperson.Items.Count]; for (int i = 0; i <= ddleventresponseperson.Items.Count - 1; i++) { Name[i] = ddleventresponseperson.Items[i].Text + " " + ddleventresponseperson.Items[i].Value; // Name[i].Insert(i, ddleventresponseperson.Items[i].Text + " " + ddleventresponseperson.Items[i].Value); } for (int i = 0; i <= ddleventresponseperson.Items.Count - 1; i++) { ddleventresponseperson.Items[i].Text = Name[i].ToString(); } ddleventresponseperson.Items.Clear(); ddleventresponseperson.DataSource = db.Tbl_Logins.ToList(); ddleventresponseperson.DataTextField = "FirstName"; ddleventresponseperson.DataValueField = "loginID"; ddleventresponseperson.DataBind(); for (int i = 0; i <= ddleventresponseperson.Items.Count - 1; i++) { ddleventresponseperson.Items[i].Text = Name[i].ToString(); } ddleventresponseperson.Items.Insert(0, new ListItem("Select Responsible Person", "-1")); } }
public void bind_resolution() { using (ComplaintsLink.ComplaintsDataContext db = new ComplaintsLink.ComplaintsDataContext()) { var obj = db.TbL_Complaints_Resolutions.Where(i => i.Cmp_ID == comid && i.Person_ID == Request.QueryString["pid"].ToString()).FirstOrDefault(); //var obj = db.USP_Complaint_GetFindingOfFacts(comid); var k = db.TbL_Complaints_Resolutions.Where(i => i.Cmp_ID == comid && i.Person_ID == Request.QueryString["pid"].ToString()).ToList(); if (k.Count > 0) { if (obj.Resoutions.ToString() == "-1") { lbl_GetResolution.Text = ""; } else { lbl_GetResolution.Text = ddlresoultion.Items.FindByValue(obj.Resoutions.ToString()).Text;// obj.Resoutions.ToString(); } string boardofaction = obj.BoardAction.ToString(); if (boardofaction != "-1") { lbl_getboardaction.Text = ddlboardaction.Items.FindByValue(obj.BoardAction.ToString()).Text; } else { lbl_getboardaction.Text = ""; } if (Convert.ToDateTime(obj.DateofResolution).ToString("MM/dd/yyyy") == Convert.ToDateTime("01/01/1900").ToString("MM/dd/yyyy")) { lbl_Getresolutiondate.Text = ""; } else { lbl_Getresolutiondate.Text = filter_date(Convert.ToString(obj.DateofResolution)); } string dateofaction = obj.DateofAction.ToString(); if (dateofaction != "01/01/1900 12:00:00" && dateofaction != "01/01/0001 12:00:00" && dateofaction != "" && dateofaction != null && dateofaction != "01/01/1900" && dateofaction != "01/01/0001") { lbl_getboardactionDate.Text = filter_date(dateofaction); } else { lbl_getboardactionDate.Text = ""; } hfd_resolution.Value = obj.Resolution_ID.ToString(); ddlresoultion.ClearSelection(); ddlboardaction.ClearSelection(); ddlresoultion.SelectedValue = obj.Resoutions.ToString(); ddlboardaction.SelectedValue = obj.BoardAction.ToString(); if (Convert.ToDateTime(obj.DateofResolution).ToString("MM/dd/yyyy") == Convert.ToDateTime("01/01/1900").ToString("MM/dd/yyyy")) { txtdateresolution.Text = ""; } else { txtdateresolution.Text = filter_date(Convert.ToString(obj.DateofResolution)); } string dateaction = obj.DateofAction.ToString(); if (dateofaction != "01/01/1900 12:00:00" && dateofaction != "01/01/0001 12:00:00" && dateofaction != "" && dateofaction != null && dateofaction != "01/01/1900" && dateofaction != "01/01/0001") { txtdateaction.Text = filter_date(dateofaction); } else { txtdateaction.Text = ""; } // txtdateaction.Text = filter_date(Convert.ToString(obj.DateofAction)); btnresolutionsubmit.Visible = false; btnresolutionupdate.Visible = true; } else { btnresolutionsubmit.Visible = true; btnresolutionupdate.Visible = false; } } }
protected void btnresolutionupdate_Click(object sender, EventArgs e) { using (ComplaintsLink.ComplaintsDataContext cdc = new ComplaintsLink.ComplaintsDataContext()) { ComplaintsLink.TbL_Complaints_Resolution obj = new ComplaintsLink.TbL_Complaints_Resolution(); try { obj.Resolution_ID = Convert.ToInt16(hfd_resolution.Value.ToString()); obj.Cmp_ID = comid; obj.Person_ID = hfd_pid.Value; obj = cdc.TbL_Complaints_Resolutions.Where(c => c.Resolution_ID == Convert.ToInt32(hfd_resolution.Value)).SingleOrDefault(); if (obj.Resoutions != Convert.ToInt32(ddlresoultion.SelectedValue) || obj.DateofResolution != Convert.ToDateTime(txtdateresolution.Text)) { ComplaintsLink.tbl_Complaints_Resolution_History cmpreshistory = new ComplaintsLink.tbl_Complaints_Resolution_History(); cmpreshistory.Resolution_ID = Convert.ToInt32(hfd_resolution.Value); cmpreshistory.Cmp_ID = comid; cmpreshistory.Person_ID = hfd_pid.Value; cmpreshistory.Old_Resolutions = ddlresoultion.SelectedValue; if (txtdateresolution.Text == "") { cmpreshistory.Old_Date_Of_Resolution = null; } else { cmpreshistory.Old_Date_Of_Resolution = Convert.ToDateTime(txtdateresolution.Text); } cmpreshistory.Old_BoardAction = ddlboardaction.SelectedValue; if (txtdateaction.Text != "") { cmpreshistory.Old_BoardAction_Date = Convert.ToDateTime(txtdateaction.Text); } cmpreshistory.Created_By = Session["UID"].ToString(); cmpreshistory.Created_Date = Convert.ToDateTime(DateTime.Now.ToShortDateString()); cdc.tbl_Complaints_Resolution_Histories.InsertOnSubmit(cmpreshistory); cdc.SubmitChanges(); } obj.Resoutions = Convert.ToInt16(ddlresoultion.SelectedValue); if (txtdateresolution.Text == "") { obj.DateofResolution = Convert.ToDateTime("01/01/1900"); } else { obj.DateofResolution = Convert.ToDateTime(txtdateresolution.Text); } obj.BoardAction = Convert.ToInt16(ddlboardaction.SelectedValue); if (txtdateaction.Text != "") { obj.DateofAction = Convert.ToDateTime(txtdateaction.Text); } obj.ModifiedBy = Convert.ToInt32(Session["UID"].ToString()); obj.ModifiedDate = DateTime.Now;//.ToString("MM/dd/yyyy"); int k = ComplaintsLink.Complaints.Complaint_Resolution_InsertValues(obj, 102); string js = " altbox('Record updated successfully.');"; ScriptManager.RegisterStartupScript(Page, GetType(), "scr", js, true); ddlresoultion.SelectedIndex = 0; txtdateresolution.Text = ""; ddlboardaction.SelectedIndex = 0; txtdateaction.Text = ""; } catch { } } bind_resolution(); }
public void BindDrpDownLists() { using (ComplaintsLink.ComplaintsDataContext db = new ComplaintsLink.ComplaintsDataContext()) { ddladmcodes.Items.Clear(); ddladmcodes.DataSource = db.tbl_LKP_Complaints_AdministrativeCodes.ToList(); ddladmcodes.DataValueField = "Administrative_Code_ID"; ddladmcodes.DataTextField = "AdministrativeCode"; ddladmcodes.DataBind(); //ddladmcodes.Items.Insert(0, new ListItem("--Select--", "-1")); for (int i = 0; i < ddladmcodes.Items.Count; i++) { ListItem li = new ListItem(ddladmcodes.Items[i].Text, ddladmcodes.Items[i].Value); li.Attributes.Add("onclick", "javascript:addtextarea(this)"); chk_administarativecode.Items.Add(li); } ddladmcodes.Items.Clear(); ddladmcodes.DataSource = db.tbl_LKP_Complaints_AdministrativeCodes.ToList(); ddladmcodes.DataValueField = "Administrative_Code_ID"; ddladmcodes.DataTextField = "TextArea"; ddladmcodes.DataBind(); //ddladmcodes.Items.Insert(0, new ListItem("--Select--", "-1")); //------------------------ utilities objutilities = new utilities(); // ddlNewHearingloc.Items.Insert(0, new ListItem("--Select--", "-1")); utilities.BindDropdown(ddlboardaction, 33); // ddlboardaction.Items.Insert(0, new ListItem("--Select--", "-1")); utilities.BindDropdown(ddlchooseoffer, 43); // ddlchooseoffer.Items.Insert(0, new ListItem("--Select--", "-1")); utilities.BindDropdown(ddlresoultion, 32); // ddlresoultion.Items.Insert(0, new ListItem("--Select--", "-1")); utilities.BindDropdown(ddlviolations, 44); for (int i = 0; i < ddlviolations.Items.Count; i++) { ListItem li = new ListItem(ddlviolations.Items[i].Text, ddlviolations.Items[i].Value); //li.Attributes.Add("onclick", "javascript:addtextarea(this)"); chbvilation.Items.Add(li); } DropDownList drp = new DropDownList(); utilities.BindDropdown(drp, 45); chbcourse.Items.Clear(); for (int i = 0; i < drp.Items.Count; i++) { ListItem li = new ListItem(drp.Items[i].Text, drp.Items[i].Value); chbcourse.Items.Add(li); } } }