private void SetValues(String sm_ProductPart) { try { M_ProductPartDL objm_ProductPartDL = new M_ProductPartDL(); if (sm_ProductPart != "") { M_ProductParts objm_ProductPart = new M_ProductParts(); objm_ProductPart.IDX = sm_ProductPart.Trim(); objm_ProductPart = new M_ProductPartDL().Selectm_ProductPart(objm_ProductPart); if (objm_ProductPart != null) { txt_IDX.Text = objm_ProductPart.IDX.ToString(); txt_PartNo.Text = objm_ProductPart.PartNo.ToString(); txt_PartName.Text = objm_ProductPart.PartName.ToString(); txt_ModelNO.Text = objm_ProductPart.ModelNO.ToString(); txt_SerialNo.Text = objm_ProductPart.SerialNo.ToString(); txt_SKU.Text = objm_ProductPart.SKU.ToString(); txt_MfctCode.Text = objm_ProductPart.MfctCode.ToString(); txt_UnitOfMeasure.Text = objm_ProductPart.UnitOfMeasure.ToString(); txt_Color.Text = objm_ProductPart.Color.ToString(); txt_UnitPrice.Text = objm_ProductPart.UnitPrice.ToString(); txt_SellingPrice.Text = objm_ProductPart.SellingPrice.ToString(); txt_CostPrice.Text = objm_ProductPart.CostPrice.ToString(); formMode = 3; } } } catch (Exception ex) { throw ex; } }
/// <summary> /// Saves a record to the M_ProductParts table. /// </summary> public Boolean Savem_ProductPartSP(M_ProductParts m_ProductPart, int formMode) { SqlCommand scom; bool retvalue = false; try { scom = new SqlCommand(); scom.CommandType = CommandType.StoredProcedure; scom.CommandText = "M_ProductPartsSave"; scom.Parameters.Add("@IDX", SqlDbType.VarChar, 20).Value = m_ProductPart.IDX; scom.Parameters.Add("@PartNo", SqlDbType.VarChar, 20).Value = m_ProductPart.PartNo; scom.Parameters.Add("@PartName", SqlDbType.VarChar, 100).Value = m_ProductPart.PartName; scom.Parameters.Add("@ModelNO", SqlDbType.VarChar, 20).Value = m_ProductPart.ModelNO; scom.Parameters.Add("@SerialNo", SqlDbType.VarChar, 20).Value = m_ProductPart.SerialNo; scom.Parameters.Add("@SKU", SqlDbType.VarChar, 20).Value = m_ProductPart.SKU; scom.Parameters.Add("@SuppCode", SqlDbType.VarChar, 20).Value = m_ProductPart.SuppCode; scom.Parameters.Add("@MfctCode", SqlDbType.VarChar, 20).Value = m_ProductPart.MfctCode; scom.Parameters.Add("@UnitOfMeasure", SqlDbType.VarChar, 10).Value = m_ProductPart.UnitOfMeasure; scom.Parameters.Add("@Color", SqlDbType.VarChar, 10).Value = m_ProductPart.Color; scom.Parameters.Add("@Brand", SqlDbType.VarChar, 10).Value = m_ProductPart.Brand; scom.Parameters.Add("@Capacity", SqlDbType.VarChar, 10).Value = m_ProductPart.Capacity; scom.Parameters.Add("@UnitPrice", SqlDbType.Decimal, 9).Value = m_ProductPart.UnitPrice; scom.Parameters.Add("@SellingPrice", SqlDbType.Decimal, 9).Value = m_ProductPart.SellingPrice; scom.Parameters.Add("@CostPrice", SqlDbType.Decimal, 9).Value = m_ProductPart.CostPrice; scom.Parameters.Add("@AvgPrice", SqlDbType.Decimal, 9).Value = m_ProductPart.AvgPrice; scom.Parameters.Add("@PackSize", SqlDbType.Decimal, 9).Value = m_ProductPart.PackSize; scom.Parameters.Add("@ReOrderLevel", SqlDbType.Decimal, 9).Value = m_ProductPart.ReOrderLevel; scom.Parameters.Add("@MinQty", SqlDbType.Decimal, 9).Value = m_ProductPart.MinQty; scom.Parameters.Add("@EOQty", SqlDbType.Decimal, 9).Value = m_ProductPart.EOQty; scom.Parameters.Add("@ReOrderQty", SqlDbType.Decimal, 9).Value = m_ProductPart.ReOrderQty; scom.Parameters.Add("@CreateUser", SqlDbType.VarChar, 20).Value = m_ProductPart.CreateUser; scom.Parameters.Add("@CreateDate", SqlDbType.DateTime, 8).Value = m_ProductPart.CreateDate; scom.Parameters.Add("@ModifyUser", SqlDbType.VarChar, 20).Value = m_ProductPart.ModifyUser; scom.Parameters.Add("@ModifyDate", SqlDbType.DateTime, 8).Value = m_ProductPart.ModifyDate; 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); } }
public List <M_ProductParts> SelectM_ProductPartMulti(M_ProductParts objm_ProductPart2) { List <M_ProductParts> retval = new List <M_ProductParts>(); try { strquery = @"select * from m_ProductPart where purchaseReqNo = '" + objm_ProductPart2.Capacity + "'"; DataTable dtm_ProductPart = u_DBConnection.ReturnDataTable(strquery, CommandType.Text); foreach (DataRow drType in dtm_ProductPart.Rows) { if (drType != null) { M_ProductParts objm_ProductPart = new M_ProductParts(); objm_ProductPart.IDX = drType["IDX"].ToString(); objm_ProductPart.PartNo = drType["PartNo"].ToString(); objm_ProductPart.PartName = drType["PartName"].ToString(); objm_ProductPart.ModelNO = drType["ModelNO"].ToString(); objm_ProductPart.SerialNo = drType["SerialNo"].ToString(); objm_ProductPart.SKU = drType["SKU"].ToString(); objm_ProductPart.SuppCode = drType["SuppCode"].ToString(); objm_ProductPart.MfctCode = drType["MfctCode"].ToString(); objm_ProductPart.UnitOfMeasure = drType["UnitOfMeasure"].ToString(); objm_ProductPart.Color = drType["Color"].ToString(); objm_ProductPart.Brand = drType["Brand"].ToString(); objm_ProductPart.Capacity = drType["Capacity"].ToString(); objm_ProductPart.UnitPrice = decimal.Parse(drType["UnitPrice"].ToString()); objm_ProductPart.SellingPrice = decimal.Parse(drType["SellingPrice"].ToString()); objm_ProductPart.CostPrice = decimal.Parse(drType["CostPrice"].ToString()); objm_ProductPart.AvgPrice = decimal.Parse(drType["AvgPrice"].ToString()); objm_ProductPart.PackSize = decimal.Parse(drType["PackSize"].ToString()); objm_ProductPart.ReOrderLevel = decimal.Parse(drType["ReOrderLevel"].ToString()); objm_ProductPart.MinQty = decimal.Parse(drType["MinQty"].ToString()); objm_ProductPart.EOQty = decimal.Parse(drType["EOQty"].ToString()); objm_ProductPart.ReOrderQty = decimal.Parse(drType["ReOrderQty"].ToString()); objm_ProductPart.CreateUser = drType["CreateUser"].ToString(); objm_ProductPart.CreateDate = DateTime.Parse(drType["CreateDate"].ToString()); objm_ProductPart.ModifyUser = drType["ModifyUser"].ToString(); objm_ProductPart.ModifyDate = DateTime.Parse(drType["ModifyDate"].ToString()); retval.Add(objm_ProductPart); } } return(retval); } catch (Exception ex) { throw ex; } }
public static string FindExisitingParts(string suppcode) { string str = ""; if (M_ProductPartDL.ExistingM_ProductPart(suppcode.Trim())) { M_ProductParts cat = new M_ProductParts(); cat.IDX = suppcode.Trim(); cat = new M_ProductPartDL().Selectm_ProductPart(cat); str = cat.PartName.Trim(); } else { str = "<Error!!!>"; } return(str); }
public M_ProductParts Selectm_ProductPart(M_ProductParts objm_ProductPart) { try { strquery = @"select * from m_ProductParts where IDX = '" + objm_ProductPart.IDX + "'"; DataRow drType = u_DBConnection.ReturnDataRow(strquery); if (drType != null) { objm_ProductPart.IDX = drType["IDX"].ToString(); objm_ProductPart.PartNo = drType["PartNo"].ToString(); objm_ProductPart.PartName = drType["PartName"].ToString(); objm_ProductPart.ModelNO = drType["ModelNO"].ToString(); objm_ProductPart.SerialNo = drType["SerialNo"].ToString(); objm_ProductPart.SKU = drType["SKU"].ToString(); objm_ProductPart.SuppCode = drType["SuppCode"].ToString(); objm_ProductPart.MfctCode = drType["MfctCode"].ToString(); objm_ProductPart.UnitOfMeasure = drType["UnitOfMeasure"].ToString(); objm_ProductPart.Color = drType["Color"].ToString(); objm_ProductPart.Brand = drType["Brand"].ToString(); objm_ProductPart.Capacity = drType["Capacity"].ToString(); objm_ProductPart.UnitPrice = decimal.Parse(drType["UnitPrice"].ToString()); objm_ProductPart.SellingPrice = decimal.Parse(drType["SellingPrice"].ToString()); objm_ProductPart.CostPrice = decimal.Parse(drType["CostPrice"].ToString()); objm_ProductPart.AvgPrice = decimal.Parse(drType["AvgPrice"].ToString()); objm_ProductPart.PackSize = decimal.Parse(drType["PackSize"].ToString()); objm_ProductPart.ReOrderLevel = decimal.Parse(drType["ReOrderLevel"].ToString()); objm_ProductPart.MinQty = decimal.Parse(drType["MinQty"].ToString()); objm_ProductPart.EOQty = decimal.Parse(drType["EOQty"].ToString()); objm_ProductPart.ReOrderQty = decimal.Parse(drType["ReOrderQty"].ToString()); objm_ProductPart.CreateUser = drType["CreateUser"].ToString(); objm_ProductPart.CreateDate = DateTime.Parse(drType["CreateDate"].ToString()); objm_ProductPart.ModifyUser = drType["ModifyUser"].ToString(); objm_ProductPart.ModifyDate = DateTime.Parse(drType["ModifyDate"].ToString()); return(objm_ProductPart); } return(null); } catch (Exception ex) { throw ex; } }
private void performButtons(xEnums.PerformanceType xenum) { switch (xenum) { case xEnums.PerformanceType.View: break; case xEnums.PerformanceType.New: FunctionButtonStatus(xEnums.PerformanceType.New); //txt_IDX.Text = commonFunctions.GetSerial("A0009"); formMode = 1; //txt_subcat_name.Text = ""; //txt_subcat.Text = ""; //txt_suppliername.Text = ""; //txt_categoryName.Text = ""; txt_UnitPrice.Text = "0.00"; txt_CostPrice.Text = "0.00"; txt_SKU.Text = ""; txt_MfctCode.Text = ""; txt_ModelNO.Text = ""; txt_SerialNo.Text = ""; txt_SellingPrice.Text = "0.00"; txt_IDX.Text = ""; txt_PartName.Text = ""; txt_IDX.Focus(); errorProvider1.Clear(); break; case xEnums.PerformanceType.Edit: FunctionButtonStatus(xEnums.PerformanceType.Edit); formMode = 3; txt_IDX.Enabled = false; txt_PartName.Focus(); errorProvider1.Clear(); break; case xEnums.PerformanceType.Save: if (txt_IDX.Text.Trim() == "") { errorProvider1.SetError(txt_IDX, "Please enter a product code !"); return; } if (txt_PartName.Text.Trim() == "") { errorProvider1.SetError(txt_PartName, "Please enter a part name !"); return; } if (formMode == 1) { if (M_ProductPartDL.ExistingM_ProductPart(txt_IDX.Text.Trim())) { errorProvider1.SetError(txt_IDX, "The part code you have entered already exists!"); return; } if (UserDefineMessages.ShowMsg("", UserDefineMessages.Msg_PerfmBtn_Save, commonFunctions.Softwarename.Trim()) == System.Windows.Forms.DialogResult.Yes) { using (var scope = new System.Transactions.TransactionScope()) { //adding the product M_ProductParts objm_ProductPart = new M_ProductParts(); objm_ProductPart.IDX = txt_IDX.Text.Trim(); objm_ProductPart.PartNo = txt_PartNo.Text.Trim(); objm_ProductPart.PartName = txt_PartName.Text.Trim(); objm_ProductPart.ModelNO = txt_ModelNO.Text.Trim(); objm_ProductPart.SerialNo = txt_SerialNo.Text.Trim(); objm_ProductPart.SKU = txt_SKU.Text.Trim(); objm_ProductPart.SuppCode = "";// txt_SuppCode.Text.Trim(); objm_ProductPart.MfctCode = txt_MfctCode.Text.Trim(); objm_ProductPart.UnitOfMeasure = txt_UnitOfMeasure.Text.Trim(); objm_ProductPart.Color = txt_Color.Text.Trim(); objm_ProductPart.Brand = txt_SKU.Text.Trim(); objm_ProductPart.Capacity = ""; objm_ProductPart.UnitPrice = Convert.ToDecimal(txt_UnitPrice.Text.Trim()); objm_ProductPart.SellingPrice = Convert.ToDecimal(txt_SellingPrice.Text.Trim()); objm_ProductPart.CostPrice = Convert.ToDecimal(txt_CostPrice.Text.Trim()); objm_ProductPart.AvgPrice = Convert.ToDecimal(txt_CostPrice.Text.Trim()); objm_ProductPart.PackSize = 0; objm_ProductPart.ReOrderLevel = 0; objm_ProductPart.MinQty = 10; objm_ProductPart.EOQty = 60; objm_ProductPart.ReOrderQty = 50; objm_ProductPart.CreateUser = commonFunctions.Loginuser; objm_ProductPart.CreateDate = DateTime.Now; objm_ProductPart.ModifyUser = commonFunctions.Loginuser; objm_ProductPart.ModifyDate = DateTime.Now; new M_ProductPartDL().Savem_ProductPartSP(objm_ProductPart, 1); //commonFunctions.IncrementSerial("A0009"); scope.Complete(); } GetData(); txt_IDX.Enabled = true; FunctionButtonStatus(xEnums.PerformanceType.Save); commonFunctions.SetMDIStatusMessage(UserDefineMessages.Msg_Save_Sucess_string, 2); } } else if (formMode == 3) { if (UserDefineMessages.ShowMsg("", UserDefineMessages.Msg_PerfmBtn_Update, commonFunctions.Softwarename.Trim()) == System.Windows.Forms.DialogResult.Yes) { using (var scope = new System.Transactions.TransactionScope()) { M_ProductParts objm_ProductPart = new M_ProductParts(); objm_ProductPart.IDX = txt_IDX.Text.Trim(); objm_ProductPart.PartNo = txt_PartNo.Text.Trim(); objm_ProductPart = new M_ProductPartDL().Selectm_ProductPart(objm_ProductPart); objm_ProductPart.PartName = txt_PartName.Text.Trim(); objm_ProductPart.ModelNO = txt_ModelNO.Text.Trim(); objm_ProductPart.SerialNo = txt_SerialNo.Text.Trim(); objm_ProductPart.SKU = txt_SKU.Text.Trim(); objm_ProductPart.SuppCode = "";// txt_SuppCode.Text.Trim(); objm_ProductPart.MfctCode = txt_MfctCode.Text.Trim(); objm_ProductPart.UnitOfMeasure = txt_UnitOfMeasure.Text.Trim(); objm_ProductPart.Color = txt_Color.Text.Trim(); objm_ProductPart.Brand = txt_SKU.Text.Trim(); objm_ProductPart.Capacity = ""; objm_ProductPart.UnitPrice = Convert.ToDecimal(txt_UnitPrice.Text.Trim()); objm_ProductPart.SellingPrice = Convert.ToDecimal(txt_SellingPrice.Text.Trim()); objm_ProductPart.CostPrice = Convert.ToDecimal(txt_CostPrice.Text.Trim()); objm_ProductPart.AvgPrice = Convert.ToDecimal(txt_CostPrice.Text.Trim()); objm_ProductPart.PackSize = 0; objm_ProductPart.ReOrderLevel = 0; objm_ProductPart.MinQty = 10; objm_ProductPart.EOQty = 60; objm_ProductPart.ReOrderQty = 50; objm_ProductPart.ModifyUser = commonFunctions.Loginuser; objm_ProductPart.ModifyDate = DateTime.Now; new M_ProductPartDL().Savem_ProductPartSP(objm_ProductPart, 1); scope.Complete(); } } GetData(); txt_IDX.Enabled = true; FunctionButtonStatus(xEnums.PerformanceType.Save); commonFunctions.SetMDIStatusMessage(UserDefineMessages.Msg_Update_Sucess_string, 2); } break; case xEnums.PerformanceType.Cancel: txt_IDX.Enabled = true; FunctionButtonStatus(xEnums.PerformanceType.Default); errorProvider1.Clear(); break; } }