public MaterialBean getMaterialByID(int materialID) { MaterialBean matrBean = new MaterialBean(); try { string sql = " select * from pos.tmaterial where ID = @material_id "; Dictionary <string, string> parameters = new Dictionary <string, string>(); parameters.Add("@material_id", materialID + ""); DataTable currencyResult = dbConn.select(sql, parameters); for (int i = 0; i < currencyResult.Rows.Count; i++) { matrBean.ID = int.Parse(currencyResult.Rows[i]["ID"].ToString()); matrBean.NAME = currencyResult.Rows[i]["NAME"].ToString(); matrBean.LONG_NAME = currencyResult.Rows[i]["LONG_NAME"].ToString(); matrBean.MEASURE = int.Parse(currencyResult.Rows[i]["MEASURE"].ToString()); matrBean.MRP_LOW = int.Parse(currencyResult.Rows[i]["MRP_LOW"].ToString()); matrBean.MRP_HIGH = int.Parse(currencyResult.Rows[i]["MRP_HIGH"].ToString()); matrBean.GRP_ID = int.Parse(currencyResult.Rows[i]["GRP_ID"].ToString()); matrBean.ddl_gui_text = matrBean.NAME + ""; matrBean.ddl_gui_value = matrBean.ID + ""; } } catch (Exception ex) { myLog.Error(ex); } return(matrBean); }
public List <MaterialBean> getAllMaterial(int grp_id) { List <MaterialBean> materialDataSource = new List <MaterialBean>(); try { string sql = "SELECT * FROM pos.tmaterial where GRP_ID=@grp_id "; Dictionary <string, string> parameters = new Dictionary <string, string>(); parameters.Add("@grp_id", grp_id + ""); DataTable currencyResult = dbConn.select(sql, parameters); for (int i = 0; i < currencyResult.Rows.Count; i++) { MaterialBean matrBean = new MaterialBean(); matrBean.ID = int.Parse(currencyResult.Rows[i]["ID"].ToString()); matrBean.NAME = currencyResult.Rows[i]["NAME"].ToString(); matrBean.LONG_NAME = currencyResult.Rows[i]["LONG_NAME"].ToString(); matrBean.MEASURE = int.Parse(currencyResult.Rows[i]["MEASURE"].ToString()); matrBean.MRP_LOW = int.Parse(currencyResult.Rows[i]["MRP_LOW"].ToString()); matrBean.MRP_HIGH = int.Parse(currencyResult.Rows[i]["MRP_HIGH"].ToString()); matrBean.GRP_ID = int.Parse(currencyResult.Rows[i]["GRP_ID"].ToString()); matrBean.ddl_gui_text = matrBean.NAME + ""; matrBean.ddl_gui_value = matrBean.ID + ""; materialDataSource.Add(matrBean); } } catch (Exception ex) { myLog.Error(ex); } return(materialDataSource); }
private TransactionResult createMaterial() { TransactionResult result = new TransactionResult(); try { MaterialBean newMaterial = new MaterialBean(); newMaterial.COMP_ID = int.Parse(lst_company.SelectedValue); newMaterial.GRP_ID = int.Parse(lst_matr_grp.SelectedValue); newMaterial.LONG_NAME = txt_material_longname.Text; newMaterial.MEASURE = int.Parse(lst_measure.SelectedValue); newMaterial.MRP_HIGH = int.Parse(txt_mrp_high.Text); newMaterial.MRP_LOW = int.Parse(txt_mrp_low.Text); newMaterial.NAME = txt_materialname.Text; using (Material_Svc svc = new Material_Svc()) { result = svc.createItem(newMaterial); } } catch (Exception ex) { myLog.Error(ex); } return(result); }
protected void btn_AddItem_to_shoppingcart_Click(object sender, EventArgs e) { try { try { if (lst_MATERIAL.SelectedItem == null) { // alertr message to choose Material new AlertScript().displayAlert(this, "برجاء اختر اولا الصنف المراد اضافته"); } if (txt_qnty.Text.Trim().Length == 0 || float.Parse(txt_qnty.Text.Trim()) < 0) { // alertr message to choose Qanty new AlertScript().displayAlert(this, "برجاء اختر الكمية المطلوبة"); } else { int materialID = int.Parse(lst_MATERIAL.SelectedItem.Value.ToString()); float amountRequired = float.Parse(txt_qnty.Text); ShoppingCart shoopingCart = (ShoppingCart)Session[SessionKeys.shoppingCart]; // first check if material already added to shooping cart or not bool addedBefore = shoopingCart.items.Exists(x => x.Material_id == materialID); if (addedBefore) { new AlertScript().displayAlert(this, "لا يمكن تكرار الصنف فى نفس الفاتورة"); return; } // first check aviable amount in stock bool stockHaveEnough = checkAvaiableStockForMateril(amountRequired); if (!stockHaveEnough) { new AlertScript().displayAlert(this, "لايوجد مخزون متاح من الصنف"); return; } ShoppingLineItemBean lineItem = new ShoppingLineItemBean(); lineItem.Material_id = materialID; lineItem.Material_name = lst_MATERIAL.SelectedItem.Text; MaterialBean matrBean = new MaterialBean().getMaterialByID(lineItem.Material_id); MaterialPriceBean matrPriceBean = new MaterialPriceBean().getCurrentMaterialPrices(lineItem.Material_id); lineItem.qnty = amountRequired; lineItem.unit_price = matrPriceBean.PRICE; lineItem.deduction = txt_deduction.Text.Trim().Length == 0 ? 0 : float.Parse(txt_deduction.Text.Trim()); lineItem.totla_after_deduction = (lineItem.qnty * lineItem.unit_price) - lineItem.deduction; lineItem.totla_before_deduction = (lineItem.qnty * lineItem.unit_price); shoopingCart.items.Add(lineItem); grid_ShoppingLineItems.DataSource = shoopingCart.items; grid_ShoppingLineItems.DataBind(); } } catch (Exception ex) { MyLog.Error(ex); } } catch (Exception ex) { } }
public TransactionResult createItem(MaterialBean newMaterial) { TransactionResult result = new TransactionResult(); try { materialGroupBean matrGrp = getMaterialGroupByID(newMaterial.GRP_ID); int nextNumber = -1; using (NumberRange_Svc svc1 = new NumberRange_Svc()) { nextNumber = svc1.getNextNumberInRange(matrGrp.RANGE_ID); } if (nextNumber > 0) { string sql = " INSERT INTO pos.tmaterial(ID,COMP_ID,NAME,LONG_NAME,GRP_ID,MEASURE,MRP_LOW,MRP_HIGH,active)" + " values (@ID,@COMP_ID,@NAME,@LONG_NAME,@GRP_ID,@MEASURE,@MRP_LOW,@MRP_HIGH,@active)"; Dictionary <string, string> parameters = new Dictionary <string, string>(); parameters.Add("@ID", nextNumber + ""); parameters.Add("@COMP_ID", newMaterial.COMP_ID + ""); parameters.Add("@NAME", newMaterial.NAME); parameters.Add("@LONG_NAME", newMaterial.LONG_NAME); parameters.Add("@GRP_ID", newMaterial.GRP_ID + ""); parameters.Add("@MEASURE", newMaterial.MEASURE + ""); parameters.Add("@MRP_LOW", newMaterial.MRP_LOW + ""); parameters.Add("@MRP_HIGH", newMaterial.MRP_HIGH + ""); parameters.Add("@active", "1"); int dbStatus = dbConn.insertDeleteUpdate(sql, parameters); if (dbStatus > 0) { result.status = true; result.val = nextNumber + ""; result.msg = "تم انشاء الصنف " + nextNumber + " بنجاح"; } else { string msg = " فشلت عمليه انشاء صنف جديد السبب : " + dbConn.msg; throw new POS_Business_Exception(msg); } } else { myLog.Error("حدث خطا فى تسلسل الارقام للاصناف فى المخزن "); } } catch (Exception ex) { result.status = false; result.val = ""; result.msg = ex.Message; myLog.Error(ex); } return(result); }
private void fillMaterial() { try { string selectedGrpVal = lst_MATERIAL_GRP.SelectedItem.Value; string sql = " select * from pos.tmaterial where grp_id = @grp_id "; Dictionary <string, string> parameters = new Dictionary <string, string>(); parameters.Add("@grp_id", selectedGrpVal); List <MaterialBean> materialDataSource = new MaterialBean().getAllMaterial(sql, parameters); lst_material.DataSource = materialDataSource; lst_material.DataTextField = "name"; lst_material.DataValueField = "ID"; lst_material.DataBind(); } catch (Exception ex) { } }
private bool createMaterial() { bool created = false; try { MaterialBean newMaterial = new MaterialBean(); newMaterial.COMP_ID = int.Parse(lst_company.SelectedValue); newMaterial.GRP_ID = int.Parse(lst_matr_grp.SelectedValue); newMaterial.LONG_NAME = txt_material_longname.Text; newMaterial.MEASURE = int.Parse(lst_measure.SelectedValue); newMaterial.MRP_HIGH = int.Parse(txt_mrp_high.Text); newMaterial.MRP_LOW = int.Parse(txt_mrp_low.Text); newMaterial.NAME = txt_materialname.Text; created = new MaterialBean().createItem(newMaterial); } catch (Exception ex) { mylog.Error(ex); } return(created); }