public List <MaterialCardBean> getMaterialsCard(string sql, Dictionary <string, string> parameters) { List <MaterialCardBean> material_card_dataSource = new List <MaterialCardBean>(); try { string material_sql = " select * from pos.tmaterial where comp_id = @cmp_id "; Dictionary <string, string> material_parameters = new Dictionary <string, string>(); material_parameters.Add("@cmp_id", parameters["@cmp_id"]); List <MaterialBean> materialsResult = new MaterialBean().getAllMaterial(material_sql, material_parameters); DataTable materialCardResult = new ConnectionManager().select(sql, parameters); for (int i = 0; i < materialCardResult.Rows.Count; i++) { MaterialCardBean matr_card_Bean = new MaterialCardBean(); matr_card_Bean.ID = int.Parse(materialCardResult.Rows[i]["ID"].ToString()); matr_card_Bean.FISCAL_YEAR = int.Parse(materialCardResult.Rows[i]["FISCAL_YEAR"].ToString()); matr_card_Bean.COMP_ID = int.Parse(materialCardResult.Rows[i]["COMP_ID"].ToString()); matr_card_Bean.inventory_id = int.Parse(materialCardResult.Rows[i]["inventory_id"].ToString()); matr_card_Bean.MATERIAL_ID = int.Parse(materialCardResult.Rows[i]["MATERIAL_ID"].ToString()); matr_card_Bean.INITIAL_QNTY = int.Parse(materialCardResult.Rows[i]["INITIAL_QNTY"].ToString()); matr_card_Bean.CURRENT_QNTY = int.Parse(materialCardResult.Rows[i]["CURRENT_QNTY"].ToString()); matr_card_Bean.MATERIAL_name = materialsResult.Single(x => x.ID == matr_card_Bean.MATERIAL_ID).NAME; matr_card_Bean.MRP_LOW = materialsResult.Single(x => x.ID == matr_card_Bean.MATERIAL_ID).MRP_LOW; matr_card_Bean.MRP_HIGH = materialsResult.Single(x => x.ID == matr_card_Bean.MATERIAL_ID).MRP_HIGH; matr_card_Bean.CREATE_DATE = DateTime.Parse(materialCardResult.Rows[i]["CREATE_DATE"].ToString()); matr_card_Bean.lastupdate = DateTime.Parse(materialCardResult.Rows[i]["lastupdate"].ToString()); material_card_dataSource.Add(matr_card_Bean); } } catch (Exception ex) { myLog.Error(ex); } return(material_card_dataSource); }
public List <MaterialBean> getAllMaterial(string sql, Dictionary <string, string> parameters) { List <MaterialBean> materialDataSource = new List <MaterialBean>(); try { DataTable currencyResult = new ConnectionManager().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()); materialDataSource.Add(matrBean); } } catch (Exception ex) { myLog.Error(ex); } return(materialDataSource); }
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 + ""); List <MaterialBean> materialDataSource = getAllMaterial(sql, parameters); matrBean = materialDataSource[0]; } catch (Exception ex) { myLog.Error(ex); } return(matrBean); }
public bool createItem(MaterialBean newMaterial) { bool result = false; try { materialGroupBean matrGrp = new materialGroupBean().getMaterialGroupByID(newMaterial.GRP_ID); int nextNumber = new NumberRangeBeans().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 = new ConnectionManager().insertDeleteUpdate(sql, parameters); if (dbStatus == 1) { result = true; } } else { myLog.Error("حدث خطا فى تسلسل الارقام للاصناف فى المخزن "); } } catch (Exception ex) { myLog.Error(ex); } return(result); }