private bool checkAvaiableStockForMateril(float desiredamount) { bool passTransaction = false; try { float amountInShoppingCart = 0; int materialID = int.Parse(lst_MATERIAL.SelectedItem.Value); int companyID = int.Parse(lst_company.SelectedItem.Value); ShoppingCart shoppingCart = (ShoppingCart)Session[SessionKeys.shoppingCart]; bool foundItem = shoppingCart.items.Exists(x => x.Material_id == materialID); if (foundItem) { ShoppingLineItemBean foundItemInShoppingCart = shoppingCart.items.Single(x => x.Material_id == materialID); amountInShoppingCart = foundItemInShoppingCart.qnty; } MaterialCardBean foundMaterialCardBean = new MaterialCardBean().getMaterialsCardByID(materialID, companyID); float remiaingAmount = foundMaterialCardBean.CURRENT_QNTY - (desiredamount + amountInShoppingCart); if (remiaingAmount > 0) { passTransaction = true; } } catch (Exception ex) { MyLog.Error(ex); } return(passTransaction); }
private bool createMaterialMovement() { bool dbOP = false; try { if (int.Parse(lst_movmenet.SelectedValue) == MaterialMovementTypeKeys.INITIAL_BALANCE) { MaterialCardBean initbalanace = new MaterialCardBean(); initbalanace.COMP_ID = int.Parse(lst_company.SelectedValue); initbalanace.FISCAL_YEAR = new FiscalBean().getIDForYear(DateTime.Now.Year); initbalanace.inventory_id = int.Parse(lst_inventory.SelectedValue); initbalanace.MATERIAL_ID = int.Parse(lst_material.SelectedValue); initbalanace.INITIAL_QNTY = int.Parse(txt_qty.Text); initbalanace.CURRENT_QNTY = int.Parse(txt_qty.Text); initbalanace.INITIAL_QNTY = int.Parse(txt_qty.Text); dbOP = new MaterialCardBean().createMaterialCard(initbalanace); } } catch (Exception ex) { myLog.Error(ex); } return(dbOP); }
protected void btn_checkStock_Click(object sender, EventArgs e) { try { int materialID = int.Parse(lst_MATERIAL.SelectedItem.Value); int companyID = int.Parse(lst_company.SelectedItem.Value); MaterialCardBean foundMaterialCardBean = new MaterialCardBean().getMaterialsCardByID(materialID, companyID); string message = "يوجد من الصنف " + foundMaterialCardBean.MATERIAL_name + " الكمية : " + foundMaterialCardBean.CURRENT_QNTY; new AlertScript().displayAlert(this, message); } catch (Exception ex) { } }
protected void btnsaveBill_clicked(object sender, EventArgs e) { try { UserProfile currentUserProfile = (UserProfile)Session[SessionKeys.userProfile]; string currentTime = DateTime.Now.Year + "-" + DateTime.Now.Month + "-" + DateTime.Now.Day; ShoppingCart shoppingCart = (ShoppingCart)Session[SessionKeys.shoppingCart]; shoppingCart.shoppingGregDate = currentTime; shoppingCart.company = new CompanyBeans().getCompanyByID(int.Parse(lst_company.SelectedValue)); shoppingCart.customer = new CustomerBean().getCustomerByID(int.Parse(lst_customer.SelectedValue)); string sql = " insert into pos.tsoh (COMP_ID,CUSTOMER,FISCAL,F_PERIOD,HEADER_TXT,REFERNCE,CREATED_BY,DLVR_MTHD) values " + " (@COMP_ID,@CUSTOMER,@FISCAL,@F_PERIOD,@HEADER_TXT,@REFERNCE,@CREATED_BY,@DLVR_MTHD)"; string COMP_ID = lst_company.SelectedValue; string CUSTOMER = lst_customer.SelectedValue; int FISCALYearID = new FiscalBean().getIDForYear(DateTime.Now.Year); int F_PERIOD = new FiscalPeriodBean().getIDForCurrentfiscalPeriod(); string HEADER_TXT = txt_header.Text; string REFERNCE = txt_refernce.Text; string CREATED_BY = currentUserProfile.ID; string DLVR_MTHD = lst_delivery_method.SelectedValue; Dictionary <string, string> parameters = new Dictionary <string, string>(); parameters.Add("@COMP_ID", COMP_ID); parameters.Add("@CUSTOMER", CUSTOMER); parameters.Add("@FISCAL", FISCALYearID + ""); parameters.Add("@F_PERIOD", F_PERIOD + ""); parameters.Add("@HEADER_TXT", HEADER_TXT); parameters.Add("@REFERNCE", REFERNCE); parameters.Add("@CREATED_BY", CREATED_BY); parameters.Add("@DLVR_MTHD", DLVR_MTHD); int db_status = new ConnectionManager().insertDeleteUpdate(sql, parameters); if (db_status == 1) { sql = "select max(ID) from pos.tsoh where COMP_ID =@COMP_ID and F_PERIOD = @F_PERIOD and FISCAL=@FISCAL and CREATED_BY=@CREATED_BY"; parameters = new Dictionary <string, string>(); parameters.Add("@COMP_ID", COMP_ID); parameters.Add("@FISCAL", FISCALYearID + ""); parameters.Add("@F_PERIOD", F_PERIOD + ""); parameters.Add("@CREATED_BY", CREATED_BY); DataTable result = new ConnectionManager().select(sql, parameters); int orderID = int.Parse(result.Rows[0][0].ToString()); shoppingCart.orderID = orderID; // start insert line items for order for (int i = 0; i < shoppingCart.items.Count; i++) { ShoppingLineItemBean lineItem = shoppingCart.items[i]; sql = "insert into pos.tdod (SOH_ID,LINE_NO,MATERIAL,QTY,DESCR,DISCOUNT) values " + " (@SOH_ID,@LINE_NO,@MATERIAL,@QTY,@DESCR,@DISCOUNT)"; parameters = new Dictionary <string, string>(); parameters.Add("@SOH_ID", orderID + ""); parameters.Add("@LINE_NO", (i + 1) + ""); parameters.Add("@MATERIAL", lineItem.Material_id + ""); parameters.Add("@QTY", lineItem.qnty + ""); parameters.Add("@DESCR", ""); parameters.Add("@DISCOUNT", lineItem.deduction + ""); db_status = new ConnectionManager().insertDeleteUpdate(sql, parameters); } // start update table of movment for (int i = 0; i < shoppingCart.items.Count; i++) { ShoppingLineItemBean lineItem = shoppingCart.items[i]; sql = " insert into pos.tmatr_mov (comp_id,fisc_priod,mov_typ,material,qnty,descr,createdBy) values " + " (@comp_id,@fisc_priod,@mov_typ,@material,@qnty,@descr,@createdBy)"; parameters = new Dictionary <string, string>(); parameters.Add("@comp_id", COMP_ID); parameters.Add("@fisc_priod", F_PERIOD + ""); parameters.Add("@mov_typ", +MaterialMovementTypeKeys.ORDER + ""); parameters.Add("@qnty", lineItem.qnty + ""); parameters.Add("@material", lineItem.Material_id + ""); parameters.Add("@descr", ""); parameters.Add("@createdBy", CREATED_BY); db_status = new ConnectionManager().insertDeleteUpdate(sql, parameters); } // start update inventory for each material for (int i = 0; i < shoppingCart.items.Count; i++) { parameters = new Dictionary <string, string>(); ShoppingLineItemBean lineItem = shoppingCart.items[i]; MaterialCardBean foundMaterialCard = new MaterialCardBean().getMaterialsCardByID(lineItem.Material_id, int.Parse(COMP_ID)); //if(foundMaterialCard.ID == 0) //{ // // insert record for item //sql = " insert into pos.tmatr_mov (FISCAL_YEAR,COMP_ID,inventory_id,MATERIAL_ID,INITIAL_QNTY,CURRENT_QNTY,lastupdate) values "+ // " (@FISCAL_YEAR,@COMP_ID,@inventory_id,@MATERIAL_ID,@INITIAL_QNTY,@CURRENT_QNTY,@lastupdate)"; // parameters.Add("@FISCAL_YEAR",FISCALYearID+""); // parameters.Add("@COMP_ID",COMP_ID); // parameters.Add("@inventory_id",lst_storage.SelectedValue); // parameters.Add("@MATERIAL_ID",lineItem.Material_id+""); // parameters.Add("@INITIAL_QNTY","0"); // parameters.Add("@CURRENT_QNTY",lineItem.qnty+""); // parameters.Add("@lastupdate",currentTime); //} //else //{ sql = "UPDATE pos.tmaterial_card SET " + " FISCAL_YEAR = @FISCAL_YEAR," + " COMP_ID = @COMP_ID," + " inventory_id = @inventory_id," + " MATERIAL_ID = @MATERIAL_ID," + " CURRENT_QNTY = @CURRENT_QNTY ," + " lastupdate = @lastupdate" + " where id=@id "; parameters.Add("@id", foundMaterialCard.ID + ""); parameters.Add("@COMP_ID", COMP_ID); parameters.Add("@FISCAL_YEAR", FISCALYearID + ""); parameters.Add("@inventory_id", lst_storage.SelectedValue); parameters.Add("@CURRENT_QNTY", (foundMaterialCard.CURRENT_QNTY - lineItem.qnty) + ""); parameters.Add("@MATERIAL_ID", lineItem.Material_id + ""); parameters.Add("@lastupdate", currentTime); // } db_status = new ConnectionManager().insertDeleteUpdate(sql, parameters); } new AlertScript().displayAlert(this, "تم تسجيل الفاتورة بنجاح"); Response.Redirect("~/pgs/invoices/displayInvoice.aspx"); } else { new AlertScript().displayAlert(this, "فشلت العملية"); } } catch (Exception ex) { MyLog.Error(ex); new AlertScript().displayAlert(this, "فشلت العملية"); } }