public static List <CommodityGradeBLL> GetAllCommodityDetail() { List <CommodityGradeBLL> list = new List <CommodityGradeBLL>(); ECXLookUp.ECXLookup objEcxLookUp = new WarehouseApplication.ECXLookUp.ECXLookup(); // Get All Commodities ECXLookUp.CCommodity[] objCommodity = objEcxLookUp.GetAllCommodities(Utility.GetWorkinglanguage()); foreach (ECXLookUp.CCommodity i in objCommodity) { ECXLookUp.CCommodityClass[] objCommodityClass = objEcxLookUp.GetAllCommodityClasses(Utility.GetWorkinglanguage(), i.UniqueIdentifier); foreach (ECXLookUp.CCommodityClass o in objCommodityClass) { ECXLookUp.CCommodityGrade[] objGrade = objEcxLookUp.GetAllCommodityGrades(Utility.GetWorkinglanguage(), o.UniqueIdentifier); foreach (ECXLookUp.CCommodityGrade c in objGrade) { CommodityGradeBLL objCG = new CommodityGradeBLL(); objCG.CommodityId = i.UniqueIdentifier; objCG.Commodity = i.Name; objCG.CommodityClassId = o.UniqueIdentifier; objCG.ClassName = o.Name; objCG.CommodityGradeId = c.UniqueIdentifier; objCG.GradeName = c.Name; objCG.Symbol = c.Symbol; list.Add(objCG); } } } string cgs = string.Empty; list.ForEach(cg => cgs += string.Format("id - {0}, name - {1}{2}", cg.CommodityGradeId, cg.GradeName, Environment.NewLine)); Utility.LogException(new Exception(cgs)); return(list); }
protected void Page_Load(object sender, EventArgs e) { if (IsPostBack != true) { Page.DataBind(); try { this.cboCommodity.Items.Add(new ListItem("Please Select Commodity", "")); this.cboCommodity.AppendDataBoundItems = true; ECXLookUp.ECXLookup objEcxLookUp = new WarehouseApplication.ECXLookUp.ECXLookup(); ECXLookUp.CCommodity[] objCommodity = objEcxLookUp.GetActiveCommodities(Utility.GetWorkinglanguage()); this.cboCommodity.DataSource = objCommodity; this.cboCommodity.DataTextField = "Name"; this.cboCommodity.DataValueField = "UniqueIdentifier"; this.cboCommodity.DataBind(); } catch (Exception ex) { throw ex; } try { // get the type of the current warehoouse. this.cboWarehouse.Items.Add(new ListItem("Please Select Warehouse", "")); this.cboWarehouse.AppendDataBoundItems = true; List <WarehouseBLL> listWarehouse = WarehouseBLL.GetAllActiveWarehouse(); foreach (WarehouseBLL owarehouse in listWarehouse) { this.cboWarehouse.Items.Add(new ListItem(owarehouse.WarehouseName, owarehouse.WarehouseId.ToString())); } this.cboWarehouse.SelectedValue = UserBLL.GetCurrentWarehouse().ToString(); } catch (Exception ex) { throw ex; } int currYear; currYear = int.Parse(ConfigurationSettings.AppSettings["CurrentEthiopianYear"]); this.cboProductionYear.Items.Add(new ListItem("Please Select Production Year.", "")); this.cboProductionYear.AppendDataBoundItems = true; for (int i = currYear - 2; i <= currYear; i++) { this.cboProductionYear.Items.Add(new ListItem(i.ToString(), i.ToString())); } } else { } }
public CascadingDropDownNameValue[] GetRegions(string knownCategoryValues, string category) { List <CascadingDropDownNameValue> l = new List <CascadingDropDownNameValue>(); ECXLookUp.ECXLookup objEcxLookUp = new WarehouseApplication.ECXLookUp.ECXLookup(); ECXLookUp.CRegion[] objRegion = objEcxLookUp.GetActiveRegions(WarehouseApplication.BLL.Utility.GetWorkinglanguage()); foreach (ECXLookUp.CRegion region in objRegion) { l.Add(new CascadingDropDownNameValue(region.Name.ToString(), region.UniqueIdentifier.ToString())); } return(l.ToArray()); }
public static Nullable <float> GetLotSize(Guid CommodityGradeId, Guid Lang) { Nullable <float> LotSize; ECXLookUp.ECXLookup objEcxLookUp = new WarehouseApplication.ECXLookUp.ECXLookup(); ECXLookUp.CCommodityGrade objCommodity = objEcxLookUp.GetCommodityGrade(Lang, CommodityGradeId); if (objCommodity != null) { LotSize = objCommodity.LotSize; return(objCommodity.LotSize); } else { return(null); } }
public static CommodityGradeBLL GetCommodityGrade(Guid Id) { try { CommodityGradeBLL comGrade = commodityGradeCache.GetAllItems().SelectMany(gs => (from g in gs where g.CommodityGradeId == Id select g)).SingleOrDefault(); if (comGrade == null) { ECXLookUp.ECXLookup objEcxLookUp = new WarehouseApplication.ECXLookUp.ECXLookup(); ECXLookUp.CCommodityGrade oGrade = objEcxLookUp.GetCommodityGrade(Utility.GetWorkinglanguage(), Id); comGrade = (from grade in commodityGradeCache.GetItem(oGrade.CommodityClassUniqueIdentifier.ToString()) where grade.CommodityGradeId == Id select grade).SingleOrDefault(); } return(comGrade); } catch (Exception ex) { throw ex; } }
public static List <commodityType> GetAllCoffeeTypes() { List <commodityType> list = null; ECXLookUp.ECXLookup objEcxLookUp = new WarehouseApplication.ECXLookUp.ECXLookup(); ECXLookUp.CCommodityType[] objCommodity = objEcxLookUp.GetActiveCommodityTypes(Utility.GetWorkinglanguage()); if (objCommodity != null && objCommodity.Length > 0) { list = new List <commodityType>(); foreach (ECXLookUp.CCommodityType i in objCommodity) { commodityType o = new commodityType(); o.Id = i.UniqueIdentifier; o.Name = i.Name; list.Add(o); } } return(list); }
public CascadingDropDownNameValue[] GetWoredas(string knownCategoryValues, string category) { string ZoneID = ""; StringDictionary kv; kv = CascadingDropDown.ParseKnownCategoryValuesString(knownCategoryValues); if (!kv.ContainsKey("Zone") || kv["Zone"].ToString() == "") { throw new ArgumentException("Couldn't find selected Zone."); } ZoneID = kv["Zone"]; List <CascadingDropDownNameValue> l = new List <CascadingDropDownNameValue>(); ECXLookUp.ECXLookup objEcxLookUp = new WarehouseApplication.ECXLookUp.ECXLookup(); ECXLookUp.CWoreda[] objWoreda = objEcxLookUp.GetActiveWoredas(WarehouseApplication.BLL.Utility.GetWorkinglanguage(), new Guid(ZoneID.ToString())); foreach (ECXLookUp.CWoreda woreda in objWoreda) { l.Add(new CascadingDropDownNameValue(woreda.Name.ToString(), woreda.UniqueIdentifier.ToString())); } return(l.ToArray()); }
public static List <GRNTypeBLL> GetActiveGRNTypes() { List <GRNTypeBLL> list; try { ECXLookUp.ECXLookup objEcxLookUp = new WarehouseApplication.ECXLookUp.ECXLookup(); ECXLookUp.CGRNType[] obj = objEcxLookUp.GetActiveGRNTypes(Utility.GetWorkinglanguage()); if (obj != null) { if (obj.Count() > 0) { list = new List <GRNTypeBLL>(); foreach (ECXLookUp.CGRNType i in obj) { GRNTypeBLL o = new GRNTypeBLL(); o.Id = i.UniqueIdentifier; o.Name = i.Name; list.Add(o); } return(list); } else { return(null); } } else { return(null); } } catch (Exception ex) { throw new Exception("Unable to Get GRN Types.", ex); } }
public static string GetCommodityGradeNameById(Guid Id) { try { ECXLookUp.ECXLookup objEcxLookUp = new WarehouseApplication.ECXLookUp.ECXLookup(); ECXLookUp.CCommodityGrade objCommodity = objEcxLookUp.GetCommodityGrade(Utility.GetWorkinglanguage(), Id); if (objCommodity != null) { CommodityGradeBLL obj = new CommodityGradeBLL(); obj.GradeName = objCommodity.Name; obj.CommodityClassId = objCommodity.CommodityClassUniqueIdentifier; return(obj.GradeName); } else { return(""); } } catch (Exception ex) { throw ex; } }
public List <WarehouseServicesBLL> GetServices() { List <WarehouseServicesBLL> list = null; ECXLookUp.ECXLookup objEcxLookUp = new WarehouseApplication.ECXLookUp.ECXLookup(); ECXLookUp.CService[] objServices = objEcxLookUp.GetActiveServices(Utility.GetWorkinglanguage()); if (objServices != null) { if (objServices.Count() > 0) { list = new List <WarehouseServicesBLL>(); foreach (ECXLookUp.CService s in objServices) { WarehouseServicesBLL obj = new WarehouseServicesBLL(); obj.Id = s.UniqueIdentifier; obj.Name = s.Name; obj.Status = s.Status; list.Add(obj); } } } return(list); }
public WoredaBLL GetWoredabyId(Guid WoredaId) { try { WoredaBLL obj = new WoredaBLL(); ECXLookUp.ECXLookup objEcxLookUp = new WarehouseApplication.ECXLookUp.ECXLookup(); ECXLookUp.CWoreda objWoreda = objEcxLookUp.GetWoreda(Utility.GetWorkinglanguage(), WoredaId); if (objWoreda != null) { obj.WoredaId = objWoreda.UniqueIdentifier; obj.WoredaName = objWoreda.Name; obj.ZoneId = objWoreda.ZoneUniqueIdentifier; return(obj); } else { return(null); } } catch { throw new Exception("can not get woreda Name."); } }
private void LoadData(Guid Id) { //get The Id from the qs //Get the Commodity deposite Request form. CommodityDepositeRequestBLL objEdit = new CommodityDepositeRequestBLL(); CommodityDepositRequest objCommDepReq = new CommodityDepositRequest(); DataSet dsResult = new DataSet(); objEdit.Id = Id; dsResult = objCommDepReq.getCommodityDepositRequestById(Id); Guid ClientGuid = new Guid(dsResult.Tables[0].Rows[0]["ClientId"].ToString()); objEdit.ClientId = ClientGuid; this.hfClientId.Value = ClientGuid.ToString(); this.txtNumberOfBags.Text = dsResult.Tables[0].Rows[0]["NumberofBags"].ToString(); objEdit.NumberofBags = int.Parse((dsResult.Tables[0].Rows[0]["NumberofBags"].ToString())); float weight = float.Parse(dsResult.Tables[0].Rows[0]["Weight"].ToString()); if (weight == 0) { this.txtWeight.Text = ""; } else { this.txtWeight.Text = dsResult.Tables[0].Rows[0]["Weight"].ToString(); } objEdit.Weight = float.Parse(dsResult.Tables[0].Rows[0]["Weight"].ToString()); this.txtRemark.Text = dsResult.Tables[0].Rows[0]["Remark"].ToString(); objEdit.Remark = this.txtRemark.Text; this.dtDateTimeRecived.Text = Convert.ToDateTime(dsResult.Tables[0].Rows[0]["DateTimeRecived"]).ToShortDateString(); this.txtTimeArrival.Text = Convert.ToDateTime(dsResult.Tables[0].Rows[0]["DateTimeRecived"]).ToLongTimeString(); objEdit.DateTimeRecived = Convert.ToDateTime((dsResult.Tables[0].Rows[0]["DateTimeRecived"]).ToString()); this.cboReprsentative.SelectedValue = dsResult.Tables[0].Rows[0]["RepresentativeId"].ToString(); objEdit.RepresentativeId = Guid.Empty; if (dsResult.Tables[0].Rows[0]["WoredaId"] != DBNull.Value) { this.cboWoreda.SelectedValue = dsResult.Tables[0].Rows[0]["WoredaId"].ToString(); objEdit.WoredaId = new Guid(dsResult.Tables[0].Rows[0]["WoredaId"].ToString()); } this.cboStatus.SelectedValue = dsResult.Tables[0].Rows[0]["Status"].ToString(); objEdit.Status = int.Parse(dsResult.Tables[0].Rows[0]["Status"].ToString()); //if (Convert.ToInt32((this.cboStatus.SelectedValue)) == 0 ) //{ // //this.btnEdit.Enabled = false; //} // Display the Client Id from this // Id = dsResult.Tables[0].Rows[0]["ClientId"].ToString(); ECXLookUp.ECXLookup objLookUp = new WarehouseApplication.ECXLookUp.ECXLookup(); //Populate Drop down from server cboCommodity this.cboCommodity.AppendDataBoundItems = true; ECXLookUp.CCommodity[] objCommodity = objLookUp.GetActiveCommodities(WarehouseApplicationConfiguration.GetWorkingLanguage()); this.cboCommodity.DataSource = objCommodity; this.cboCommodity.DataTextField = "Name"; this.cboCommodity.DataValueField = "UniqueIdentifier"; this.cboCommodity.DataBind(); this.cboCommodity.SelectedValue = dsResult.Tables[0].Rows[0]["CommodityId"].ToString(); objEdit.CommodityId = new Guid(dsResult.Tables[0].Rows[0]["CommodityId"].ToString()); //Populate Region //ECXLookUp.CRegion[] objRegion = objLookUp.GetActiveRegions(WarehouseApplicationConfiguration.GetWorkingLanguage()); //this.cboRegion.DataSource = objRegion; //this.cboRegion.DataTextField = "Name"; //this.cboRegion.DataValueField = "UniqueIdentifier"; //this.cboRegion.DataBind(); string SelectedWoreda = ""; SelectedWoreda = dsResult.Tables[0].Rows[0]["WoredaId"].ToString(); if (SelectedWoreda != "") { ECXLookUp.CWoreda objWoreda = objLookUp.GetWoreda(WarehouseApplicationConfiguration.GetWorkingLanguage(), new Guid(SelectedWoreda)); Guid SelectedZone = new Guid(objWoreda.ZoneUniqueIdentifier.ToString()); ECXLookUp.CZone objZoneSelected = objLookUp.GetZone(WarehouseApplicationConfiguration.GetWorkingLanguage(), SelectedZone); Guid SelectedRegion = new Guid(objZoneSelected.RegionUniqueIdentifier.ToString()); this.cboRegion_CascadingDropDown.SelectedValue = SelectedRegion.ToString(); this.cboZone_CascadingDropDown.SelectedValue = SelectedZone.ToString(); this.cboWoreda_CascadingDropDown.SelectedValue = SelectedWoreda; } // Bind Clinet ClientBLL objClient = new ClientBLL(); objClient = ClientBLL.GetClinet(ClientGuid); if (objClient != null) { this.txtClient.Text = objClient.ClientName + " - " + objClient.ClientId; this.txtClient.Enabled = false; } //Populate the Production Year // set because we will not have Production year no latter than 2007 string strSelectedYear = dsResult.Tables[0].Rows[0]["ProductionYear"].ToString(); int currYear = int.Parse(ConfigurationSettings.AppSettings["CurrentEthiopianYear"]); this.cboProductionYear.Items.Add(new ListItem("Please Select Production Year.", "")); this.cboProductionYear.AppendDataBoundItems = true; if (strSelectedYear != "") { if (int.Parse(strSelectedYear) < currYear - 2) { this.cboProductionYear.Items.Add(new ListItem(strSelectedYear, strSelectedYear)); } } for (int i = currYear - 2; i <= currYear; i++) { this.cboProductionYear.Items.Add(new ListItem(i.ToString(), i.ToString())); } this.cboProductionYear.SelectedValue = dsResult.Tables[0].Rows[0]["ProductionYear"].ToString(); if (dsResult.Tables[0].Rows[0]["ProductionYear"] != DBNull.Value) { objEdit.ProductionYear = int.Parse(dsResult.Tables[0].Rows[0]["ProductionYear"].ToString()); } ViewState["CommDepOld"] = objEdit; }
public static string GetServiceNameById(Guid Id) { ECXLookUp.ECXLookup objEcxLookUp = new WarehouseApplication.ECXLookUp.ECXLookup(); ECXLookUp.CService objServices = objEcxLookUp.GetService(Utility.GetWorkinglanguage(), Id); return(objServices.Name); }