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