public void bindDeptgrid(long ID) { DataTable dt = new DataTable(); DataSet ds = new DataSet(); CustomProfile profile = CustomProfile.GetProfile(); BrilliantWMS.CompanySetupService.iCompanySetupClient company = new BrilliantWMS.CompanySetupService.iCompanySetupClient(); try { // ds = company.GetDepartmentListforgrid(ID, profile.DBConnection._constr); ds = company.GetDeptListWithSLA(ID, profile.DBConnection._constr); dt = ds.Tables[0]; if (dt.Rows.Count > 0) { Grid1.DataSource = ds.Tables[0]; Grid1.DataBind(); } else { Grid1.DataSource = null; Grid1.DataBind(); } } catch { } finally { company.Close(); } }
protected void BindContactList(long CompanyID) { DataTable dt = new DataTable(); DataSet ds = new DataSet(); CustomProfile profile = CustomProfile.GetProfile(); BrilliantWMS.CompanySetupService.iCompanySetupClient CompanyClient = new BrilliantWMS.CompanySetupService.iCompanySetupClient(); ds = CompanyClient.GetContactPersonLocList(CompanyID, profile.DBConnection._constr); dt = ds.Tables[0]; if (dt.Rows.Count > 0) { gvContactPerson.DataSource = ds.Tables[0]; gvContactPerson.DataBind(); } else { gvContactPerson.DataSource = null; gvContactPerson.DataBind(); } //CustomProfile profile = CustomProfile.GetProfile(); //List<tContactPersonDetail> ConPerLst = new List<tContactPersonDetail>(); //iUCCommonFilterClient UCCommonFilter = new iUCCommonFilterClient(); //ConPerLst = UCCommonFilter.GetContactPersonListDeptWise(CompanyID, profile.DBConnection._constr).ToList(); //gvContactPerson.DataSource = ConPerLst; //gvContactPerson.DataBind(); }
public void locationDetails(long locationID) { ddlCountry.SelectedIndex = -1; DataTable dt = new DataTable(); DataSet ds = new DataSet(); CustomProfile profile = CustomProfile.GetProfile(); BrilliantWMS.CompanySetupService.iCompanySetupClient CompanyClient = new BrilliantWMS.CompanySetupService.iCompanySetupClient(); try { ds = CompanyClient.GetLocationList(locationID, profile.DBConnection._constr); dt = ds.Tables[0]; if (dt.Rows.Count > 0) { ddlcompany.SelectedValue = dt.Rows[0]["CompanyID"].ToString(); hdnSelectedCompany.Value = dt.Rows[0]["CompanyID"].ToString(); //getDepartment(long.Parse(dt.Rows[0]["CompanyID"].ToString())); // ddldept.SelectedValue = dt.Rows[0]["deptid"].ToString(); txtlocationName.Text = dt.Rows[0]["LocationName"].ToString(); // hdnSelectedDepartment.Value = dt.Rows[0]["deptid"].ToString(); txtlocation.Text = dt.Rows[0]["LocationCode"].ToString(); txtCAddress1.Text = dt.Rows[0]["AddressLine1"].ToString(); txtAddress2.Text = dt.Rows[0]["AddressLine2"].ToString(); txtZipCode.Text = dt.Rows[0]["zipcode"].ToString(); txtCity.Text = dt.Rows[0]["City"].ToString(); txtLandMark.Text = dt.Rows[0]["landmark"].ToString(); txtFax.Text = dt.Rows[0]["FaxNo"].ToString(); txtname.Text = dt.Rows[0]["ContactName"].ToString(); txtemailid.Text = dt.Rows[0]["ContactEmail"].ToString(); txtphoneno.Text = dt.Rows[0]["MobileNo"].ToString(); string country = dt.Rows[0]["County"].ToString(); string State = dt.Rows[0]["State"].ToString(); hdnSearchContactName1.Value = dt.Rows[0]["ContactName"].ToString(); hdnSearchContactID1.Value = dt.Rows[0]["ShippingID"].ToString(); hdnSearchConEmail.Value = dt.Rows[0]["ContactEmail"].ToString(); hdnSearchConMobNo.Value = dt.Rows[0]["MobileNo"].ToString(); if (dt.Rows[0]["Active"].ToString() == "N") { rbtnActiveNo.Checked = true; rbtnActiveYes.Checked = false; } hdnCountry.Value = country; hdnState.Value = State; Page.ClientScript.RegisterStartupScript(GetType(), "fillCountry" + sessionID, "setCountry('" + country + "','" + State + "');", true); } } catch (System.Exception ex) { Login.Profile.ErrorHandling(ex, this, "Location Master", "locationDetails"); } finally { CompanyClient.Close(); } }
public void getLocationList() { DataTable dt = new DataTable(); DataSet ds = new DataSet(); CustomProfile profile = CustomProfile.GetProfile(); BrilliantWMS.CompanySetupService.iCompanySetupClient CompanyClient = new BrilliantWMS.CompanySetupService.iCompanySetupClient(); long LocID = 0; ds = CompanyClient.GetLocationList(LocID, profile.DBConnection._constr); dt = ds.Tables[0]; if (dt.Rows.Count > 0) { Gvlocation.DataSource = ds.Tables[0]; Gvlocation.DataBind(); } else { Gvlocation.DataSource = null; Gvlocation.DataBind(); } }
protected void pageSave(Object sender, BrilliantWMS.ToolbarService.iUCToolbarClient e) { CustomProfile profile = CustomProfile.GetProfile(); BrilliantWMS.CompanySetupService.iCompanySetupClient CompanyClient = new BrilliantWMS.CompanySetupService.iCompanySetupClient(); try { long locationid = 0; long companyid = long.Parse(hdnSelectedCompany.Value); long deptid = 0; locationid = long.Parse(hdnselectedLocation.Value); string hdnstate = hdnmodestate.Value; string locationCode = txtlocation.Text; string address1 = txtCAddress1.Text; string address2 = txtAddress2.Text; string city = txtCity.Text; string zipcode = txtZipCode.Text; string landmark = txtLandMark.Text; string faxno = txtFax.Text; //string contactName = txtname.Text; string contactName = hdnSearchContactName1.Value; // string email = txtemailid.Text; string email = hdnSearchConEmail.Value; string Locationname = txtlocationName.Text; long ContactID = long.Parse(hdnSearchContactID1.Value); long MobileNo = 0; if (hdnSearchConMobNo.Value != "") { MobileNo = long.Parse(hdnSearchConMobNo.Value); } string Mobilecont = txtphoneno.Text; string Country = hdnCountry.Value; string State = hdnState.Value; string userid = profile.Personal.UserID.ToString(); string active = "N"; if (rbtnActiveYes.Checked == true) { active = "Y"; } if (hdnstate == "AddNew") { //long ContactID = CompanyClient.SaveLocContactInContact("Contact", companyid, 0, 1, contactName, email, Mobilecont, 4, "Y", userid, DateTime.Now, companyid, profile.DBConnection._constr); CompanyClient.SaveEditLocation(locationid, companyid, deptid, locationCode, address1, address2, Country, State, city, zipcode, landmark, faxno, active, contactName, email, Locationname, MobileNo, userid, DateTime.Now, hdnstate, ContactID, profile.DBConnection._constr); WebMsgBox.MsgBox.Show("Record Saved successfully"); } else { long contactIdUpdate = CompanyClient.GetContactIdasShippingId(locationid, profile.DBConnection._constr); if (active == "N") { int totaluser = CompanyClient.CheckLocationIDForAssignedUser(locationid, profile.DBConnection._constr); if (totaluser == 1) { WebMsgBox.MsgBox.Show("Location is assigned for user Please remove the location for that user"); // rbtnActiveNo.Text = ""; rbtnActiveNo.Checked = false; rbtnActiveYes.Checked = true; } else { // CompanyClient.UpdateContacttableDetail(contactName, email, Mobilecont, contactIdUpdate, profile.DBConnection._constr); CompanyClient.UpdateLocationDetails(locationid, companyid, deptid, locationCode, address1, address2, Country, State, city, zipcode, landmark, faxno, active, contactName, email, MobileNo, userid, DateTime.Now, hdnstate, Locationname, ContactID, profile.DBConnection._constr); WebMsgBox.MsgBox.Show("Record Updated successfully"); } } else { // CompanyClient.UpdateContacttableDetail(contactName, email, Mobilecont, contactIdUpdate, profile.DBConnection._constr); CompanyClient.UpdateLocationDetails(locationid, companyid, deptid, locationCode, address1, address2, Country, State, city, zipcode, landmark, faxno, active, contactName, email, MobileNo, userid, DateTime.Now, hdnstate, Locationname, ContactID, profile.DBConnection._constr); WebMsgBox.MsgBox.Show("Record Updated successfully"); } } clr(); getLocationList(); ActiveTab("Load"); } catch (System.Exception ex) { Login.Profile.ErrorHandling(ex, this, "Location Master", "pageSave"); } finally { CompanyClient.Close(); } }