protected void Save_Click(object sender, EventArgs e) { var updateClientData = new db_ptcDataContext(); int cid; bool IsIntValue = Int32.TryParse(hfClientid.Value, out cid); if (IsIntValue) { var testquery = (from c in updateClientData.Clients where c.ClientId == cid join con in updateClientData.Contacts on c.ClientContactid equals con.Contactid select new { c, con }).FirstOrDefault(); testquery.c.ClientName = udClientName.Text; testquery.c.ClientContactid = Convert.ToInt32(ClientContactdd1.SelectedValue); testquery.c.ClientAddressLine1 = udClientAddressLine1.Value; testquery.c.ClientAddressLine2 = udClientAddressLine2.Value; testquery.c.ClientAddressCity = udClientAddressCity.Value; testquery.c.ClientAddressState = udClientAddressState.Value; testquery.c.ClientAddressZip = udClientAddressZip.Value; testquery.c.ClientNotes = udClientNotes.Value; updateClientData.SubmitChanges(); } }
public void GetClientInfo() { if (!IsPostBack) { db_ptcDataContext clientdatacontext = new db_ptcDataContext(); int cid; bool IsIntValue = Int32.TryParse(hfClientid.Value, out cid); if (IsIntValue) { var ClientData = ( from c in clientdatacontext.Clients where c.ClientId == cid join con in clientdatacontext.Contacts on c.ClientContactid equals con.Contactid select new { c.ClientId, c.ClientName, c.ClientAddressLine1, c.ClientAddressLine2, c.ClientAddressState, c.ClientAddressCity, c.ClientAddressZip, c.ClientNotes, c.ClientContactid, con.ContactSalutation, con.ContactFirstName, con.ContactLastname, con.ContactBusinessNumber, con.ContactBusinessNumberExtension, con.ContactCellularNumber, con.ContactEmailAddress, con.ContactAltEmailAddress, }).FirstOrDefault(); lbclientname.Text = ClientData.ClientName; lbaddressline1.Text = ClientData.ClientAddressLine1; lbaddressline2.Text = ClientData.ClientAddressLine2; lbstate.Text = ClientData.ClientAddressState; lbcity.Text = ClientData.ClientAddressCity; lbzipcode.Text = ClientData.ClientAddressZip; lbsaluation.Text = ClientData.ContactSalutation; lbfirstname.Text = ClientData.ContactFirstName; lblastname.Text = ClientData.ContactLastname; lbcellphone.Text = Convert.ToInt64(ClientData.ContactCellularNumber).ToString("(###) ###-####"); lbbusphone.Text = Convert.ToInt64(ClientData.ContactBusinessNumber).ToString("(###) ###-####"); udClientName.Text = ClientData.ClientName; udClientAddressLine1.Value = ClientData.ClientAddressLine1; udClientAddressLine2.Value = ClientData.ClientAddressLine2; udClientAddressCity.Value = ClientData.ClientAddressCity; udClientAddressState.Value = ClientData.ClientAddressState; udClientAddressZip.Value = ClientData.ClientAddressZip; udClientNotes.Value = ClientData.ClientNotes; } } }
protected void Button1_Click(object sender, EventArgs e) { db_ptcDataContext ADsearch = new db_ptcDataContext(); // int AD; { var lookup = ( from tb in ADsearch.SearchAppraisalDistrictDatas where tb.prop_id.ToString() == wzParcelPropId.Value select new { tb.geo_id, tb.prop_type_cd, tb.legal_desc, tb.situs_street, tb.py_owner_name, tb.py_addr_line1, tb.py_addr_line2, tb.py_addr_city, tb.py_addr_state, tb.py_addr_zip, tb.py_addr_zip_cass, tb.land_acres, tb.property_name, tb.gross_building_area, tb.net_rentable_area, tb.year_built, tb.prop_use_cd, tb.prop_use_desc, }).FirstOrDefault(); wzParcelGeoId.Value = lookup.geo_id; //wzParcelType.Value = lookup.prop_type_cd; wzParcelLegalDesc.Value = lookup.legal_desc; wzParcelSitusStreet.Value = lookup.situs_street; wzParcelOwnerName.Value = lookup.py_owner_name + ' ' + lookup.py_addr_line1; wzParcelOwnerAddressLine1.Value = lookup.py_addr_line2; wzParcelOwnerAddressCity.Value = lookup.py_addr_city; wzParcelOwnerAddressState.Value = lookup.py_addr_state; wzParcelOwnerAddressZip.Value = lookup.py_addr_zip + '-' + lookup.py_addr_zip_cass; wzParcelDBA.Value = lookup.property_name; wzParcelCharAcre.Value = lookup.land_acres; wzParcelCharGBA1.Value = Convert.ToInt64(lookup.gross_building_area).ToString("###,###"); wzParcelCharNLA1.Value = Convert.ToInt64(lookup.net_rentable_area).ToString("##,##"); wzParcelPropUseCd.Value = lookup.prop_use_cd; wzParcelCharYearBuilt1.Value = lookup.year_built.ToString(); wzParcelPropUseDesc1.Value = lookup.prop_use_desc; } }
protected void ClientContactSelect() { using (var contactTB = new db_ptcDataContext()) { ClientContactdd1.DataSource = from Contact in contactTB.Contacts orderby Contact.ContactLastname select new { Contact.ContactLastname, Contact.ContactFirstName, Contact.Contactid, ContactFullName = string.Format("{0},{1}", Contact.ContactLastname, Contact.ContactFirstName) }; ClientContactdd1.DataTextField = "ContactFullName"; ClientContactdd1.DataValueField = "Contactid"; ClientContactdd1.DataBind(); } }
public void ClientSelect() { using (var clientTB = new db_ptcDataContext()) { ClientDropDownList.DataSource = from Client in clientTB.Clients orderby Client.ClientName select new { Client.ClientName, Client.ClientId }; ClientDropDownList.DataTextField = "ClientName"; ClientDropDownList.DataValueField = "ClientId"; ClientDropDownList.DataBind(); ClientDropDownList.Items.Insert(0, new ListItem("Search Client", "NA")); } }
protected void PropertyContactSelect() { using (var contactTB = new db_ptcDataContext()) { PropertyContactdd1.DataSource = from Contact in contactTB.Contacts orderby Contact.ContactLastname select new { Contact.ContactLastname, Contact.ContactFirstName, Contact.Contactid, ContactFullName = string.Format("{0},{1}", Contact.ContactLastname, Contact.ContactFirstName) }; PropertyContactdd1.DataTextField = "ContactFullName"; PropertyContactdd1.DataValueField = "Contactid"; PropertyContactdd1.DataBind(); PropertyContactdd1.Items.Insert(0, new ListItem("Select Contact", "NA")); } }
protected void Save_Click(object sender, EventArgs e) { var ContactTable = new db_ptcDataContext(); { Contact cont = new Contact(); cont.ContactFirstName = fmContactFirstName.Value; cont.ContactLastname = fmContactLastName.Value; cont.ContactAddressLine1 = fmContactAddressLine1.Value; cont.ContactAddressCity = fmContactAddressCity.Value; cont.ContactAddressState = fmContactAddressState.Value; cont.ContactAddressZip = fmContactAddressZip.Value; ContactTable.Contacts.InsertOnSubmit(cont); ContactTable.SubmitChanges(); Response.Redirect("~/viewcontact.aspx"); } }
private void Populate_contact_table() { using (db_ptcDataContext contact_dc = new db_ptcDataContext()) { var contactdata = from con1 in contact_dc.Contacts orderby con1.ContactLastname, con1.ContactFirstName select new { ContactFirstName = con1.ContactFirstName, ContactLastName = con1.ContactLastname, ContactEmail = con1.ContactEmailAddress, }; Contact_Datagrid.DataSource = contactdata; Contact_Datagrid.DataBind(); } }
protected void addproperty_Click(object sender, EventArgs e) { var InsertProperty = new db_ptcDataContext(); int cid; bool IsIntValue = Int32.TryParse(hfClientid.Value, out cid); if (IsIntValue) { { Property prop = new Property(); prop.PropertyClientId = cid; prop.PropertyName = wzPropertyName.Value; prop.InternalCode = wzInternalCode.Value; prop.PropertyActiviatedDate = Convert.ToDateTime(wzPropertyActiveDate.Value); prop.PropertyAddressLine1 = wzPropertyAddressLine1.Value; prop.PropertyAddressLine2 = wzPropertyAddressLine2.Value; prop.PropertyAddressCity = wzPropertyAddressCity.Value; prop.PropertyAddressState = wzPropertyAddressState.Value; prop.PropertyAddressZip = wzPropertyAddressZip.Value; prop.PropertyCharGBA = Convert.ToInt32(wzPropertyCharGBA.Value); prop.PropertyCharNLA = Convert.ToInt32(wzPropertyCharNLA.Value); prop.PropertyCharUnits = Convert.ToInt32(wzPropertyCharUnits.Value); prop.PropertyCharYearBuilt = wzPropertyCharYearBuilt.Value; prop.PropertyCounty = wzPropertyCounty.Value; prop.PropertyInfoSalesDate = Convert.ToDateTime(wzPropertyInfoSalesDate.Value); prop.PropertyInfoSalesPrice = Convert.ToDecimal(wzPropertyInfoSalesPrice.Value); prop.PropertyPrimaryUse = wzPropertyPrimaryuse.Value; InsertProperty.Properties.InsertOnSubmit(prop); InsertProperty.SubmitChanges(); } } }
protected void getpropdetails() { db_ptcDataContext propdetailcontext = new db_ptcDataContext(); int pid; bool IsIntValue = Int32.TryParse(hfpropid.Value, out pid); if (IsIntValue) { var propertydetails = ( from p in propdetailcontext.Properties join con in propdetailcontext.Contacts on p.PropertyContactid equals con.Contactid into pp from con in pp.DefaultIfEmpty() where p.PropertyId == pid select new { con.ContactFirstName, con.ContactLastname, con.ContactEmailAddress, con.ContactBusinessNumber, con.ContactBusinessNumberExtension, con.ContactCellularNumber, con.ContactFaxNumber, p.PropertyCounty, p.PropertyAddressLine1, p.PropertyAddressLine2, p.PropertyAddressCity, p.PropertyAddressState, p.PropertyAddressZip, p.PropertyCharGBA, p.PropertyCharNLA, p.PropertyCharUnits, p.PropertyCharYearBuilt, p.PropertyName, p.PropertyActiviatedDate, p.PropertyPrimaryUse, p.PropertyAOAExpDate, p.InternalCode }).FirstOrDefault(); ptclientname.Text = propertydetails.PropertyName; ptfirstname.Text = propertydetails.ContactFirstName; ptlastname.Text = propertydetails.ContactLastname; ptemail.Text = propertydetails.ContactEmailAddress; ptbusphone.Text = propertydetails.ContactBusinessNumber; ptcellphone.Text = propertydetails.ContactCellularNumber; ptfaxnumber.Text = propertydetails.ContactFaxNumber; ptcounty.Text = propertydetails.PropertyCounty; ptaddressline1.Text = propertydetails.PropertyAddressLine1; ptaddresline2.Text = propertydetails.PropertyAddressLine2; ptcity.Text = propertydetails.PropertyAddressCity; ptstate.Text = propertydetails.PropertyAddressState; ptzip.Text = propertydetails.PropertyAddressZip; ptyearbuilt.Text = propertydetails.PropertyCharYearBuilt; ptgba.Text = propertydetails.PropertyCharGBA.ToString(); ptnla.Text = propertydetails.PropertyCharNLA.ToString(); ptunits.Text = propertydetails.PropertyCharUnits.ToString(); ptactivedate.Text = propertydetails.PropertyActiviatedDate.ToShortDateString(); ptpropcode.Text = propertydetails.InternalCode; } }
protected void appealformselect() { using (var parcelstb = new db_ptcDataContext()) { } }