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);
}
