public materialGroupBean getMaterialGroupByID(int id)
{
materialGroupBean Materialgroup = new materialGroupBean();
try
{
string sql = " select * from pos.tmatr_grp where ID=@ID";
Dictionary <string, string> parameter = new Dictionary <string, string>();
parameter.Add("@ID", id + "");
List <materialGroupBean> result = getAllMaterialGroups(sql, parameter);
Materialgroup = result[0];
}
catch (Exception ex)
{
myLog.Error(ex);
}
return(Materialgroup);
}
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);
}
public List <materialGroupBean> getAllMaterialGroups(string sql, Dictionary <string, string> parameters)
{
List <materialGroupBean> mat_grp_dataSource = new List <materialGroupBean>();
try
{
DataTable currencyResult = new ConnectionManager().select(sql, parameters);
for (int i = 0; i < currencyResult.Rows.Count; i++)
{
materialGroupBean matr_grp_Bean = new materialGroupBean();
matr_grp_Bean.ID = int.Parse(currencyResult.Rows[i]["id"].ToString());
matr_grp_Bean.NAME = currencyResult.Rows[i]["name"].ToString();
matr_grp_Bean.LONG_NAME = currencyResult.Rows[i]["long_name"].ToString();
matr_grp_Bean.RANGE_ID = int.Parse(currencyResult.Rows[i]["RANGE_ID"].ToString());
mat_grp_dataSource.Add(matr_grp_Bean);
}
}
catch (Exception ex)
{
myLog.Error(ex);
}
return(mat_grp_dataSource);
}
