public M_Products Selectm_Product(M_Products objm_Product) { try { strquery = @"select * from M_Products where IDX = '" + objm_Product.IDX + "'"; DataRow drType = u_DBConnection.ReturnDataRow(strquery); if (drType != null) { objm_Product.IDX = drType["IDX"].ToString(); objm_Product.Compcode = drType["Compcode"].ToString(); objm_Product.Locacode = drType["Locacode"].ToString(); objm_Product.Namex = drType["Namex"].ToString(); objm_Product.PrintName = drType["PrintName"].ToString(); objm_Product.Category = drType["Category"].ToString(); objm_Product.Make = drType["Make"].ToString(); objm_Product.Model = drType["Model"].ToString(); objm_Product.Brand = drType["Brand"].ToString(); objm_Product.Color = drType["Color"].ToString(); objm_Product.Unitx = drType["Unitx"].ToString(); objm_Product.Suplier = drType["Suplier"].ToString(); objm_Product.UnitPrice = decimal.Parse(drType["UnitPrice"].ToString()); objm_Product.SellingPrice = decimal.Parse(drType["SellingPrice"].ToString()); objm_Product.CostPrice = decimal.Parse(drType["CostPrice"].ToString()); objm_Product.ReorderQTY = decimal.Parse(drType["ReorderQTY"].ToString()); objm_Product.ReorderLevel = decimal.Parse(drType["ReorderLevel"].ToString()); objm_Product.MaxDisc = decimal.Parse(drType["MaxDisc"].ToString()); objm_Product.MinDisc = decimal.Parse(drType["MinDisc"].ToString()); objm_Product.ApplyingDisc = decimal.Parse(drType["ApplyingDisc"].ToString()); objm_Product.LockItem = bool.Parse(drType["LockItem"].ToString()); objm_Product.IsActive = bool.Parse(drType["IsActive"].ToString()); objm_Product.FrezzItem = bool.Parse(drType["FrezzItem"].ToString()); objm_Product.DiscountAllowed = bool.Parse(drType["DiscountAllowed"].ToString()); objm_Product.SalesCommAllowed = bool.Parse(drType["SalesCommAllowed"].ToString()); objm_Product.NegativeQTY = bool.Parse(drType["NegativeQTY"].ToString()); objm_Product.VatApplicable = bool.Parse(drType["VatApplicable"].ToString()); objm_Product.Norefundable = bool.Parse(drType["Norefundable"].ToString()); objm_Product.OpenPrice = bool.Parse(drType["OpenPrice"].ToString()); objm_Product.StockLot = bool.Parse(drType["StockLot"].ToString()); objm_Product.isOpenPrice = bool.Parse(drType["isOpenPrice"].ToString()); objm_Product.IsMaintainStockLot = bool.Parse(drType["IsMaintainStockLot"].ToString()); objm_Product.WholesalePrice = decimal.Parse(drType["WholesalePrice"].ToString()); objm_Product.SupplierWarrenty = decimal.Parse(drType["SupplierWarrenty"].ToString()); objm_Product.CustomerWarrenty = decimal.Parse(drType["CustomerWarrenty"].ToString()); objm_Product.CommissionAmount = decimal.Parse(drType["CommissionAmount"].ToString()); objm_Product.CommissionPer = decimal.Parse(drType["CommissionPer"].ToString()); objm_Product.CreateUser = drType["CreateUser"].ToString(); objm_Product.CreateDate = DateTime.Parse(drType["CreateDate"].ToString()); objm_Product.ModifyUser = drType["ModifyUser"].ToString(); objm_Product.ModifyDate = DateTime.Parse(drType["ModifyDate"].ToString()); objm_Product.SubCategory = drType["SubCategory"].ToString(); objm_Product.AutoIndex = int.Parse(drType["AutoIndex"].ToString()); return(objm_Product); } return(null); } catch (Exception ex) { throw ex; } }
public static decimal GetSellingPrice(string code) { decimal dec = decimal.Zero; if (M_ProductDL.ExistingM_Product(code)) { M_Products pro = new M_Products(); pro.IDX = code; pro = new M_ProductDL().Selectm_Product(pro); dec = decimal.Round(pro.SellingPrice.Value, 2); } return(dec); }
public static decimal GetProductSellingPrice(string ProductID) { decimal stock = decimal.Zero; try { M_Products stk = new M_Products(); stk.IDX = ProductID; stk = new M_ProductDL().Selectm_Product(stk); stock = stk.SellingPrice.Value; } catch (Exception ex) { } return(stock); }
public static string FindExisitingProduct(string locacode) { string str = ""; if (M_ProductDL.ExistingM_Product(locacode.Trim())) { M_Products cat = new M_Products(); cat.IDX = locacode.Trim(); M_ProductDL dl = new M_ProductDL(); cat = dl.Selectm_Product(cat); str = cat.Namex; } else { str = "<Error!!!>"; } return(str); }
private void txt_code_KeyDown(object sender, KeyEventArgs e) { if (e.KeyCode == Keys.F2) { if (ActiveControl.Name.Trim() == txt_code.Name.Trim()) { int length = Convert.ToInt32(ConfigurationManager.AppSettings["ProductFieldLength"]); string[] strSearchField = new string[length]; string strSQL = ConfigurationManager.AppSettings["ProductSQL"].ToString(); for (int i = 0; i < length; i++) { string m; m = i.ToString(); strSearchField[i] = ConfigurationManager.AppSettings["ProductField" + m + ""].ToString(); } frmU_Search find = new frmU_Search(strSQL, strSearchField, this); find.ShowDialog(this); } //FindExisitingSupplier(); errorProvider1.Clear(); } if (e.KeyCode == Keys.Enter) { try { //txt_code.Text = commonFunctions.GetProcutCode(txt_code.Text.Trim()); if (T_StockDL.ExistingT_Stock_Product(txt_code.Text, commonFunctions.GlobalCompany, commonFunctions.GlobalLocation)) { if (!commonFunctions.IsExistINV(dataGridView1, txt_code.Text)) { M_Products stk = new M_Products(); stk.Locacode = commonFunctions.GlobalLocation; stk.Compcode = commonFunctions.GlobalCompany; stk.IDX = txt_code.Text; stk = new M_ProductDL().Selectm_Product(stk); txt_cost.Text = stk.CostPrice.ToString(); txt_selling.Text = stk.SellingPrice.ToString(); lbl_name.Text = stk.Namex; txt_qty.Text = "0"; txt_qty.Focus(); errorProvider1.Clear(); already = false; } else { already = true; //errorProvider1.SetError(txt_code, "Already exists"); M_Products stk = new M_Products(); stk.Locacode = commonFunctions.GlobalLocation; stk.Compcode = commonFunctions.GlobalCompany; stk.IDX = txt_code.Text; stk = new M_ProductDL().Selectm_Product(stk); txt_cost.Text = stk.CostPrice.ToString(); txt_selling.Text = stk.SellingPrice.ToString(); lbl_name.Text = stk.Namex; DataGridViewRow drowx = new DataGridViewRow(); drowx = commonFunctions.GetRow(dataGridView1, txt_code.Text.Trim()); txt_qty.Text = drowx.Cells["Quntity"].Value.ToString(); txt_qty.Focus(); } } else { errorProvider1.SetError(txt_code, "Product you have entered not exist in the product master file"); commonFunctions.SetMDIStatusMessage("Product you have entered not exist in the product master file", 1); } } catch (Exception ex) { LogFile.WriteErrorLog(System.Reflection.MethodBase.GetCurrentMethod().Name, this.Name, ex.Message.ToString(), "Exception"); commonFunctions.SetMDIStatusMessage("Genaral Error", 2); } } }
/// <summary> /// Saves a record to the M_Products table. /// </summary> public Boolean SaveM_ProductSP(M_Products m_Product, int formMode) { SqlCommand scom; bool retvalue = false; try { scom = new SqlCommand(); scom.CommandType = CommandType.StoredProcedure; scom.CommandText = "M_ProductsSave"; scom.Parameters.Add("@IDX", SqlDbType.VarChar, 20).Value = m_Product.IDX; scom.Parameters.Add("@Compcode", SqlDbType.VarChar, 20).Value = m_Product.Compcode; scom.Parameters.Add("@Locacode", SqlDbType.VarChar, 20).Value = m_Product.Locacode; scom.Parameters.Add("@Namex", SqlDbType.VarChar, 150).Value = m_Product.Namex; scom.Parameters.Add("@PrintName", SqlDbType.VarChar, 150).Value = m_Product.PrintName; scom.Parameters.Add("@Category", SqlDbType.VarChar, 30).Value = m_Product.Category; scom.Parameters.Add("@Make", SqlDbType.VarChar, 30).Value = m_Product.Make; scom.Parameters.Add("@Model", SqlDbType.VarChar, 30).Value = m_Product.Model; scom.Parameters.Add("@Brand", SqlDbType.VarChar, 30).Value = m_Product.Brand; scom.Parameters.Add("@Color", SqlDbType.VarChar, 30).Value = m_Product.Color; scom.Parameters.Add("@Unitx", SqlDbType.VarChar, 30).Value = m_Product.Unitx; scom.Parameters.Add("@Suplier", SqlDbType.VarChar, 30).Value = m_Product.Suplier; scom.Parameters.Add("@UnitPrice", SqlDbType.Decimal, 9).Value = m_Product.UnitPrice; scom.Parameters.Add("@SellingPrice", SqlDbType.Decimal, 9).Value = m_Product.SellingPrice; scom.Parameters.Add("@CostPrice", SqlDbType.Decimal, 9).Value = m_Product.CostPrice; scom.Parameters.Add("@ReorderQTY", SqlDbType.Decimal, 9).Value = m_Product.ReorderQTY; scom.Parameters.Add("@ReorderLevel", SqlDbType.Decimal, 9).Value = m_Product.ReorderLevel; scom.Parameters.Add("@MaxDisc", SqlDbType.Decimal, 9).Value = m_Product.MaxDisc; scom.Parameters.Add("@MinDisc", SqlDbType.Decimal, 9).Value = m_Product.MinDisc; scom.Parameters.Add("@ApplyingDisc", SqlDbType.Decimal, 9).Value = m_Product.ApplyingDisc; scom.Parameters.Add("@LockItem", SqlDbType.Bit, 1).Value = m_Product.LockItem; scom.Parameters.Add("@IsActive", SqlDbType.Bit, 1).Value = m_Product.IsActive; scom.Parameters.Add("@FrezzItem", SqlDbType.Bit, 1).Value = m_Product.FrezzItem; scom.Parameters.Add("@DiscountAllowed", SqlDbType.Bit, 1).Value = m_Product.DiscountAllowed; scom.Parameters.Add("@SalesCommAllowed", SqlDbType.Bit, 1).Value = m_Product.SalesCommAllowed; scom.Parameters.Add("@NegativeQTY", SqlDbType.Bit, 1).Value = m_Product.NegativeQTY; scom.Parameters.Add("@VatApplicable", SqlDbType.Bit, 1).Value = m_Product.VatApplicable; scom.Parameters.Add("@Norefundable", SqlDbType.Bit, 1).Value = m_Product.Norefundable; scom.Parameters.Add("@OpenPrice", SqlDbType.Bit, 1).Value = m_Product.OpenPrice; scom.Parameters.Add("@StockLot", SqlDbType.Bit, 1).Value = m_Product.StockLot; scom.Parameters.Add("@isOpenPrice", SqlDbType.Bit, 1).Value = m_Product.isOpenPrice; scom.Parameters.Add("@IsMaintainStockLot", SqlDbType.Bit, 1).Value = m_Product.IsMaintainStockLot; scom.Parameters.Add("@WholesalePrice", SqlDbType.Decimal, 9).Value = m_Product.WholesalePrice; scom.Parameters.Add("@SupplierWarrenty", SqlDbType.Decimal, 9).Value = m_Product.SupplierWarrenty; scom.Parameters.Add("@CustomerWarrenty", SqlDbType.Decimal, 9).Value = m_Product.CustomerWarrenty; scom.Parameters.Add("@CommissionAmount", SqlDbType.Decimal, 9).Value = m_Product.CommissionAmount; scom.Parameters.Add("@CommissionPer", SqlDbType.Decimal, 9).Value = m_Product.CommissionPer; scom.Parameters.Add("@CreateUser", SqlDbType.VarChar, 20).Value = m_Product.CreateUser; scom.Parameters.Add("@CreateDate", SqlDbType.DateTime, 8).Value = m_Product.CreateDate; scom.Parameters.Add("@ModifyUser", SqlDbType.VarChar, 20).Value = m_Product.ModifyUser; scom.Parameters.Add("@ModifyDate", SqlDbType.DateTime, 8).Value = m_Product.ModifyDate; scom.Parameters.Add("@SubCategory", SqlDbType.VarChar, 20).Value = m_Product.SubCategory; scom.Parameters.Add("@AutoIndex", SqlDbType.Int, 4).Value = m_Product.AutoIndex; scom.Parameters.Add("@InsMode", SqlDbType.Int).Value = formMode; // For insert scom.Parameters.Add("@RtnValue", SqlDbType.Int).Value = 0; u_DBConnection dbcon = new u_DBConnection(); retvalue = dbcon.RunQuery(scom); return(retvalue); } catch (Exception ex) { throw (ex); } }