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);
}
}
}
