protected void BindFloarList(long Building) { CustomProfile profile = CustomProfile.GetProfile(); iWarehouseClient Warehouseclient = new iWarehouseClient(); grdWareFloar.DataSource = Warehouseclient.GetWarehouseFloar(Building, profile.DBConnection._constr); grdWareFloar.DataBind(); }
protected void BindSectionList(long PassageID) { CustomProfile profile = CustomProfile.GetProfile(); iWarehouseClient Warehouseclient = new iWarehouseClient(); grdsection.DataSource = Warehouseclient.GetWarehouseSection(PassageID, profile.DBConnection._constr); grdsection.DataBind(); }
protected void BindPassageList(long FloarID) { CustomProfile profile = CustomProfile.GetProfile(); iWarehouseClient Warehouseclient = new iWarehouseClient(); grdpassage.DataSource = Warehouseclient.GetWarehousePassage(FloarID, profile.DBConnection._constr); grdpassage.DataBind(); }
protected void BindBuildingList(long WarehouseID) { CustomProfile profile = CustomProfile.GetProfile(); iWarehouseClient Warehouseclient = new iWarehouseClient(); gvBuilding.DataSource = Warehouseclient.GetWarehouseBuilding(WarehouseID, profile.DBConnection._constr); gvBuilding.DataBind(); }
protected void BindShelfList(long SectionID) { CustomProfile profile = CustomProfile.GetProfile(); iWarehouseClient Warehouseclient = new iWarehouseClient(); grdshelf.DataSource = Warehouseclient.GetWarehouseShelf(SectionID, profile.DBConnection._constr); grdshelf.DataBind(); }
public void GetWarehouseDetailByID() { CustomProfile profile = CustomProfile.GetProfile(); iWarehouseClient Warehouseclient = new iWarehouseClient(); V_WMS_GetWarehouseDetails Wdetail = new V_WMS_GetWarehouseDetails(); Wdetail = Warehouseclient.GetWarehouseDetailByID(long.Parse(hdnwarehouseID.Value), profile.DBConnection._constr); FillCompany(); if (Wdetail.CompanyID != null) { ddlcompany.SelectedIndex = ddlcompany.Items.IndexOf(ddlcompany.Items.FindByValue(Wdetail.CompanyID.ToString())); } GetCustomerddl(long.Parse(Wdetail.CompanyID.ToString())); if (Wdetail.CustomerID != null) { ddlcustomer.SelectedIndex = ddlcustomer.Items.IndexOf(ddlcustomer.Items.FindByValue(Wdetail.CustomerID.ToString())); } if (Wdetail.Code != null) { txtcode.Text = Wdetail.Code.ToString(); } if (Wdetail.WarehouseName != null) { txtwarehousename.Text = Wdetail.WarehouseName.ToString(); } if (Wdetail.Type != null) { ddltype.SelectedIndex = ddltype.Items.IndexOf(ddltype.Items.FindByText(Wdetail.Type.ToString())); } if (Wdetail.Description != null) { txtdescription.Text = Wdetail.Description.ToString(); } if (Wdetail.Remark != null) { txtremark.Text = Wdetail.Remark.ToString(); } hdnNewCustomerID.Value = Wdetail.CustomerID.ToString(); hdncompanyid.Value = Wdetail.CompanyID.ToString(); Session.Add("CompanyID", Wdetail.CompanyID.ToString()); hdnWarehouseName.Value = Wdetail.WarehouseName.ToString(); Session["WarehouseName"] = Wdetail.WarehouseName.ToString(); Page.ClientScript.RegisterStartupScript(GetType(), "fillCountry" + sessionID, "setCountry('" + Wdetail.County + "','" + Wdetail.State + "');", true); string RActive = Wdetail.Active.ToString(); if (RActive == "Yes") { rbtYes.Checked = true; } else { rbtNo.Checked = true; } hdncompanyid.Value = Wdetail.CompanyID.ToString(); hdncustomerid.Value = Wdetail.CustomerID.ToString(); // UCAddress1.FillAddressByObjectNameReferenceID("Warehouse", long.Parse(hdnwarehouseID.Value), "Warehouse"); // UCContactPerson1.FillContactPersonByObjectNameReferenceID("Warehouse", long.Parse(hdnwarehouseID.Value), "Warehouse"); }
public static string PMSaveWLocation(object WLocationInfo, string LocationID) { string result = ""; CustomProfile profile = CustomProfile.GetProfile(); iWarehouseClient Warehouseclient = new iWarehouseClient(); mLocation loc = new mLocation(); tSKUTransaction skutrans = new tSKUTransaction(); try { Dictionary <string, object> dictionary = new Dictionary <string, object>(); dictionary = (Dictionary <string, object>)WLocationInfo; loc.ShelfID = long.Parse(dictionary["ShelfID"].ToString()); loc.Code = dictionary["LocationCode"].ToString(); loc.AliasCode = dictionary["AliasCode"].ToString(); loc.SortCode = long.Parse(dictionary["SortCode"].ToString()); loc.LocationType = dictionary["LocationType"].ToString(); loc.CapacityIn = long.Parse(dictionary["CapacityIn"].ToString()); loc.Capacity = decimal.Parse(dictionary["Capacity"].ToString()); loc.VelocityType = dictionary["VelocityType"].ToString(); loc.CompanyID = long.Parse(dictionary["CompanyID"].ToString()); loc.CustomerID = long.Parse(dictionary["CustomerID"].ToString()); loc.Active = dictionary["Active"].ToString().Trim(); loc.WarehouseID = long.Parse(dictionary["WarehouseID"].ToString()); skutrans.ClosingBalance = 0; skutrans.InQty = 0; skutrans.OutQty = 0; skutrans.CreatedBy = profile.Personal.UserID; skutrans.CreationDate = DateTime.Now; skutrans.CompanyID = long.Parse(dictionary["CompanyID"].ToString()); skutrans.CustomerID = long.Parse(dictionary["CustomerID"].ToString()); if (LocationID != "0") { loc.ID = long.Parse(LocationID); loc.CreatedBy = profile.Personal.UserID; loc.CreationDate = DateTime.Now; long LocID = Warehouseclient.SaveWarehouseLocation(loc, profile.DBConnection._constr); } else { loc.AvailableBalance = 0; loc.CreatedBy = profile.Personal.UserID; loc.CreationDate = DateTime.Now; long LocID = Warehouseclient.SaveWarehouseLocation(loc, profile.DBConnection._constr); skutrans.LocationID = LocID; Warehouseclient.AddRecordInSkuTransaction(skutrans, profile.DBConnection._constr); } result = "Location saved successfully"; } catch { result = "Some error occurred"; } finally { Warehouseclient.Close(); } return(result); }
public void FillLocationGrid(long WarehouseID) { CustomProfile profile = CustomProfile.GetProfile(); iWarehouseClient Warehouseclient = new iWarehouseClient(); DataSet ds = new DataSet(); ds = Warehouseclient.GetWarehouseLocationByID(WarehouseID, profile.DBConnection._constr); GVLocation.DataSource = ds; // GVLocation.DataSource = Warehouseclient.GetWarehouseLocation(WarehouseID, profile.DBConnection._constr); GVLocation.DataBind(); }
public static string ChkDuplicateSortCode(string SortCode, string WarehouseID) { string result = ""; iWarehouseClient Warehouseclient = new iWarehouseClient(); CustomProfile profile = CustomProfile.GetProfile(); long count = Warehouseclient.CheckDuplicateSortCode(long.Parse(SortCode), long.Parse(WarehouseID), profile.DBConnection._constr); if (count >= 1) { result = "Duplicate Found"; } return(result); }
protected void GetCapacityIn() { ddlcapacityin.Items.Clear(); iWarehouseClient Warehouseclient = new iWarehouseClient(); CustomProfile profile = CustomProfile.GetProfile(); ddlcapacityin.DataSource = Warehouseclient.GetCapacityIn(profile.DBConnection._constr); ddlcapacityin.DataBind(); ListItem lst = new ListItem { Text = "-Select-", Value = "0" }; ddlcapacityin.Items.Insert(0, lst); }
protected void FillLocationType() { ddllocationtype.Items.Clear(); iWarehouseClient Warehouseclient = new iWarehouseClient(); CustomProfile profile = CustomProfile.GetProfile(); ddllocationtype.DataSource = Warehouseclient.GetLocationType(profile.DBConnection._constr); ddllocationtype.DataBind(); ListItem lst = new ListItem { Text = "-Select-", Value = "0" }; ddllocationtype.Items.Insert(0, lst); }
public void GetWarehouseAddress() { CustomProfile profile = CustomProfile.GetProfile(); iWarehouseClient Warehouseclient = new iWarehouseClient(); tAddress getaddr = new tAddress(); getaddr = Warehouseclient.GetWarehouseAddress(long.Parse(hdnwarehouseID.Value), profile.DBConnection._constr); txtCAddress1.Text = getaddr.AddressLine1; txtAddress2.Text = getaddr.AddressLine2; txtZipCode.Text = getaddr.Zipcode; hdnCountry.Value = getaddr.County; hdncountryState.Value = getaddr.State; txtCity.Text = getaddr.City; //Page.ClientScript.RegisterStartupScript(GetType(), "fillCountry" + sessionID, "setCountry('" + getaddr.County + "','" + getaddr.State + "');", true); }
protected void FillWarehouse() { ddlWarehouse.Items.Clear(); iWarehouseClient Warehouse = new iWarehouseClient(); CustomProfile profile = CustomProfile.GetProfile(); long UserID = profile.Personal.UserID; ddlWarehouse.DataSource = Warehouse.GetWarehousebyUserID(UserID, profile.DBConnection._constr); ddlWarehouse.DataBind(); ListItem lst = new ListItem { Text = "-Select-", Value = "0" }; ddlWarehouse.Items.Insert(0, lst); Warehouse.Close(); }
protected void GetBuildingByID() { CustomProfile profile = CustomProfile.GetProfile(); iWarehouseClient Warehouseclient = new iWarehouseClient(); try { mWarehouseBuilding warebuilding = new mWarehouseBuilding(); warebuilding = Warehouseclient.GetWareBuildingByID(long.Parse(hdnbuilding.Value), profile.DBConnection._constr); if (warebuilding.Name != null) { txtbuildname.Text = warebuilding.Name.ToString(); } if (warebuilding.SortCode != null) { txtsortcode.Text = warebuilding.SortCode.ToString(); } if (warebuilding.Capacity != null) { txtcapacity.Text = warebuilding.Capacity.ToString(); } if (warebuilding.Description != null) { txtdescription.Text = warebuilding.Description.ToString(); } if (warebuilding.CustomerID != null) { hdncustomerID.Value = warebuilding.CustomerID.ToString(); } hdnCompanyID.Value = warebuilding.CompanyID.ToString(); } catch (System.Exception ex) { Login.Profile.ErrorHandling(ex, this, "AddEditSearchContact", "GetContactDetailByContactID"); } finally { Warehouseclient.Close(); } }
protected void GetFloarByID() { CustomProfile profile = CustomProfile.GetProfile(); iWarehouseClient Warehouseclient = new iWarehouseClient(); try { mFloar Floar = new mFloar(); Floar = Warehouseclient.GetWarehouseFloarbyID(long.Parse(hdnfloarID.Value), profile.DBConnection._constr); if (Floar.Name != null) { txtfloarname.Text = Floar.Name.ToString(); } if (Floar.SortCode != null) { txtsortcode.Text = Floar.SortCode.ToString(); } if (Floar.Capacity != null) { txtcapacity.Text = Floar.Capacity.ToString(); } if (Floar.Description != null) { txtdescription.Text = Floar.Description.ToString(); } if (Floar.CustomerID != null) { hdncustomerID.Value = Floar.CustomerID.ToString(); } hdnCompanyID.Value = Floar.CompanyID.ToString(); } catch (System.Exception ex) { Login.Profile.ErrorHandling(ex, this, "WarehouseFloar", "GetFloarByID"); } finally { Warehouseclient.Close(); } }
public static string WMSaveRequestHead(object objCon, string State) { string result = ""; CustomProfile profile = CustomProfile.GetProfile(); iWarehouseClient Warehouseclient = new iWarehouseClient(); mFloar floar = new mFloar(); try { Dictionary <string, object> dictionary = new Dictionary <string, object>(); dictionary = (Dictionary <string, object>)objCon; floar.Name = dictionary["Name"].ToString(); floar.SortCode = long.Parse(dictionary["SortCode"].ToString()); floar.Capacity = decimal.Parse(dictionary["Capacity"].ToString()); floar.Description = dictionary["description"].ToString(); floar.CompanyID = long.Parse(dictionary["CompanyId"].ToString()); floar.CustomerID = long.Parse(dictionary["CustomerID"].ToString()); floar.BuildingID = long.Parse(dictionary["BuildingID"].ToString()); if (State == "Edit") { floar.ID = Convert.ToInt64(HttpContext.Current.Session["FloarID"].ToString()); floar.CreatedBy = profile.Personal.UserID; floar.CreationDate = DateTime.Now; long FloarID = Warehouseclient.SaveWarehouseFloar(floar, profile.DBConnection._constr); } else { floar.CreatedBy = profile.Personal.UserID; floar.CreationDate = DateTime.Now; long FloarID = Warehouseclient.SaveWarehouseFloar(floar, profile.DBConnection._constr); } result = "Floar saved successfully"; } catch { result = "Some error occurred"; } finally { Warehouseclient.Close(); } return(result); }
public static string WMSaveRequestHead(object objCon, string State) { string result = ""; CustomProfile profile = CustomProfile.GetProfile(); iWarehouseClient Warehouseclient = new iWarehouseClient(); mPathway path = new mPathway(); try { Dictionary <string, object> dictionary = new Dictionary <string, object>(); dictionary = (Dictionary <string, object>)objCon; path.Name = dictionary["Name"].ToString(); path.SortCode = long.Parse(dictionary["SortCode"].ToString()); path.Description = dictionary["description"].ToString(); path.CompanyID = long.Parse(dictionary["CompanyId"].ToString()); path.CustomerID = long.Parse(dictionary["CustomerID"].ToString()); path.FloarID = long.Parse(dictionary["hdnfloarID"].ToString()); if (State == "Edit") { path.ID = Convert.ToInt64(HttpContext.Current.Session["PassageID"].ToString()); path.CreatedBy = profile.Personal.UserID; path.CreationDate = DateTime.Now; long FloarID = Warehouseclient.SaveWarehousePassage(path, profile.DBConnection._constr); } else { path.CreatedBy = profile.Personal.UserID; path.CreationDate = DateTime.Now; long FloarID = Warehouseclient.SaveWarehousePassage(path, profile.DBConnection._constr); } result = "Passage saved successfully"; } catch { result = "Some error occurred"; } finally { Warehouseclient.Close(); } return(result); }
protected void WarehouseGridBind() { iWarehouseClient WarehouseClient = new iWarehouseClient(); try { CustomProfile profile = CustomProfile.GetProfile(); long CompanyID = profile.Personal.CompanyID; List <V_WMS_GetWarehouseDetails> warehouselst = new List <V_WMS_GetWarehouseDetails>(); warehouselst = WarehouseClient.GetWarehouseList(CompanyID, profile.DBConnection._constr).ToList(); warehouselst = warehouselst.Where(w => w.CompanyID == CompanyID).ToList(); grdWarehouseList.DataSource = warehouselst; grdWarehouseList.DataBind(); } catch (System.Exception ex) { Login.Profile.ErrorHandling(ex, this, "Warehouse Master", "MainCustomerGridBind"); } finally { WarehouseClient.Close(); } }
protected void GetPassageID() { CustomProfile profile = CustomProfile.GetProfile(); iWarehouseClient Warehouseclient = new iWarehouseClient(); try { mPathway path = new mPathway(); path = Warehouseclient.GetWarehousePassageByID(long.Parse(hdnpassageID.Value), profile.DBConnection._constr); if (path.Name != null) { txtpassage.Text = path.Name.ToString(); } if (path.SortCode != null) { txtsortcode.Text = path.SortCode.ToString(); } if (path.Description != null) { txtdescription.Text = path.Description.ToString(); } if (path.CustomerID != null) { hdncustomerID.Value = path.CustomerID.ToString(); } hdnCompanyID.Value = path.CompanyID.ToString(); } catch (System.Exception ex) { Login.Profile.ErrorHandling(ex, this, "WarehousePassage", "GetPassageID"); } finally { Warehouseclient.Close(); } }
public void GetLocationDetailByID(long LocationID, long WarehouseID) { CustomProfile profile = CustomProfile.GetProfile(); iWarehouseClient Warehouseclient = new iWarehouseClient(); V_WMS_GetWareLocationByLocID Location = new V_WMS_GetWareLocationByLocID(); Location = Warehouseclient.GetWarehouseLocByID(LocationID, WarehouseID, profile.DBConnection._constr); if (Location.Code != null) { txtlocationCode.Text = Location.Code.ToString(); } if (Location.AliasCode != null) { txtaliascode.Text = Location.AliasCode.ToString(); } if (Location.SortCode != null) { txtsortCode.Text = Location.SortCode.ToString(); } if (Location.Capacity != null) { txtcapacity.Text = Location.Capacity.ToString(); } if (Location.LocationType != null) { ddllocationtype.SelectedIndex = ddllocationtype.Items.IndexOf(ddllocationtype.Items.FindByValue(Location.LocationType.ToString())); } if (Location.CapacityIn != null) { ddlcapacityin.SelectedIndex = ddlcapacityin.Items.IndexOf(ddlcapacityin.Items.FindByValue(Location.CapacityIn.ToString())); } if (Location.VelocityType != null) { ddlvelocityType.SelectedIndex = ddlvelocityType.Items.IndexOf(ddlvelocityType.Items.FindByValue(Location.VelocityType.ToString())); } if (Location.shelfID != null) { hdnShelfID.Value = Location.shelfID.ToString(); } if (Location.Building != null) { txtbuilding.Text = Location.Building.ToString(); } if (Location.Floar != null) { txtfloar.Text = Location.Floar.ToString(); } if (Location.Passage != null) { txtpathway.Text = Location.Passage.ToString(); } if (Location.Section != null) { txtsection.Text = Location.Section.ToString(); } if (Location.Shelf != null) { txtshelf.Text = Location.Shelf.ToString(); } if (Location.Active.Trim() == "Yes") { radiochannelY.Checked = true; } else { radiochannelN.Checked = true; } }
protected void pageSave(Object sender, BrilliantWMS.ToolbarService.iUCToolbarClient e) { CustomProfile profile = CustomProfile.GetProfile(); iWarehouseClient Warehouseclient = new iWarehouseClient(); mWarehouseMaster WHDetail = new mWarehouseMaster(); tAddress address = new tAddress(); if (hdnstate.Value == "Edit") { WHDetail = Warehouseclient.GetWarehouseMasterByID(long.Parse(hdnwarehouseID.Value), profile.DBConnection._constr); address = Warehouseclient.GetWarehouseAddress(long.Parse(hdnwarehouseID.Value), profile.DBConnection._constr); } WHDetail.Code = txtcode.Text.ToString(); WHDetail.WarehouseName = txtwarehousename.Text.ToString(); WHDetail.Type = ddltype.SelectedItem.Text; WHDetail.Description = txtdescription.Text.ToString(); WHDetail.Remark = txtremark.Text.ToString(); WHDetail.Active = "No"; if (rbtYes.Checked == true) { WHDetail.Active = "Yes"; } WHDetail.CompanyID = long.Parse(hdncompanyid.Value); if (hdncustomerid.Value != "") { WHDetail.CustomerID = long.Parse(hdncustomerid.Value); } else { WHDetail.CustomerID = long.Parse(hdnNewCustomerID.Value); } WHDetail.CreatedBy = profile.Personal.UserID; WHDetail.CreationDate = DateTime.Now; address.AddressLine1 = txtCAddress1.Text.ToString(); address.AddressLine2 = txtAddress2.Text.ToString(); address.Zipcode = txtZipCode.Text.ToString(); address.County = hdnCountry.Value; address.State = hdncountryState.Value; address.City = txtCity.Text.ToString(); address.ObjectName = "Warehouse"; address.Active = "Y"; address.CreatedBy = profile.Personal.UserID.ToString(); address.CreationDate = DateTime.Now; address.CompanyID = long.Parse(hdncompanyid.Value); address.AddressType = "Warehouse"; if (hdnstate.Value == "Edit") { WHDetail.ModifiedBy = profile.Personal.UserID; WHDetail.ModifiedDate = DateTime.Now; address.LastModifiedBy = profile.Personal.UserID.ToString(); address.LastModifiedDate = DateTime.Now; long WarehouseID = Warehouseclient.SaveWarehouseMaster(WHDetail, profile.DBConnection._constr); address.ReferenceID = WarehouseID; long AddressID = Warehouseclient.SaveWarehouseAddress(address, profile.DBConnection._constr); UCContactPerson1.FinalSaveContactPerson("Warehouse", long.Parse(hdnwarehouseID.Value)); UCContactPerson1.ClearContactPerson("Warehouse"); WebMsgBox.MsgBox.Show("Record Updated successfully"); } else { long WarehouseID = Warehouseclient.SaveWarehouseMaster(WHDetail, profile.DBConnection._constr); address.ReferenceID = WarehouseID; hdnwarehouseID.Value = WarehouseID.ToString(); long AddressID = Warehouseclient.SaveWarehouseAddress(address, profile.DBConnection._constr); UCContactPerson1.FinalSaveContactPerson("Warehouse", long.Parse(hdnwarehouseID.Value)); UCContactPerson1.ClearContactPerson("Warehouse"); WebMsgBox.MsgBox.Show("Record saved successfully"); } clear(); Response.Redirect("WarehouseMaster.aspx"); }
protected void btncustomernext_Click(object sender, System.EventArgs e) { CustomProfile profile = CustomProfile.GetProfile(); iWarehouseClient WarehouseClient = new iWarehouseClient(); try { mWarehouseMaster WHDetail = new mWarehouseMaster(); tAddress address = new tAddress(); WHDetail.Code = txtcode.Text.ToString(); WHDetail.WarehouseName = txtwarehousename.Text.ToString(); WHDetail.Type = ddltype.SelectedItem.Text; WHDetail.Description = txtdescription.Text.ToString(); WHDetail.Remark = txtremark.Text.ToString(); WHDetail.Active = "No"; if (rbtYes.Checked == true) { WHDetail.Active = "Yes"; } WHDetail.CompanyID = long.Parse(hdncompanyid.Value); WHDetail.CustomerID = long.Parse(hdncustomerid.Value); WHDetail.CreatedBy = profile.Personal.UserID; WHDetail.CreationDate = DateTime.Now; address.AddressLine1 = txtCAddress1.Text.ToString(); address.AddressLine2 = txtAddress2.Text.ToString(); address.Zipcode = txtZipCode.Text.ToString(); address.County = hdnCountry.Value; address.State = hdncountryState.Value; address.City = txtCity.Text.ToString(); address.ObjectName = "Warehouse"; address.Active = "Y"; address.CreatedBy = profile.Personal.UserID.ToString(); address.CreationDate = DateTime.Now; address.CompanyID = long.Parse(hdncompanyid.Value); address.AddressType = "Warehouse"; hdnWarehouseName.Value = txtwarehousename.Text.ToString(); Session["WarehouseName"] = txtwarehousename.Text.ToString(); long WarehouseID = 0; WarehouseID = WarehouseClient.SaveWarehouseMaster(WHDetail, profile.DBConnection._constr); address.ReferenceID = WarehouseID; long AddressID = WarehouseClient.SaveWarehouseAddress(address, profile.DBConnection._constr); hdnwarehouseID.Value = WarehouseID.ToString(); Session.Add("CompanyID", hdncompanyid.Value); if (hdnwarehouseID.Value != "0") { ActiveTab("Next"); btncustomernext.Visible = false; } else { WebMsgBox.MsgBox.Show("Error Occured"); } } catch (Exception ex) { Login.Profile.ErrorHandling(ex, this, "Warehouse Master", "Buttonnextsave"); } finally { } }