public T_StockDamage Selectt_StockRet(T_StockDamage objt_StockRet) { try { strquery = @"select * from M_Company where CompCode = '"; DataRow drType = u_DBConnection.ReturnDataRow(strquery); if (drType != null) { objt_StockRet.StockCode = drType["StockCode"].ToString(); objt_StockRet.Compcode = drType["Compcode"].ToString(); objt_StockRet.Locacode = drType["Locacode"].ToString(); objt_StockRet.Suppid = drType["Suppid"].ToString(); objt_StockRet.ProductId = drType["ProductId"].ToString(); //objt_StockRet.Type = drType["Type"].ToString(); //objt_StockRet.Qty = decimal.Parse(drType["Qty"].ToString()); objt_StockRet.SellingPrice = decimal.Parse(drType["SellingPrice"].ToString()); objt_StockRet.CostPrice = decimal.Parse(drType["CostPrice"].ToString()); objt_StockRet.AvgCost = decimal.Parse(drType["AvgCost"].ToString()); objt_StockRet.OpnStock = decimal.Parse(drType["OpnStock"].ToString()); objt_StockRet.InitialCost = decimal.Parse(drType["InitialCost"].ToString()); objt_StockRet.InitialStock = decimal.Parse(drType["InitialStock"].ToString()); objt_StockRet.Descr = drType["Descr"].ToString(); objt_StockRet.Usercode = drType["Usercode"].ToString(); //objt_StockRet.Datex = DateTime.Parse(drType["Datex"].ToString()); return(objt_StockRet); } return(null); } catch (Exception ex) { throw ex; } }
public Boolean Savet_StockDamageSP(T_StockDamage t_StockDamage, int formMode) { SqlCommand scom; bool retvalue = false; try { scom = new SqlCommand(); scom.CommandType = CommandType.StoredProcedure; scom.CommandText = "T_StockDamageSave"; scom.Parameters.Add("@StockCode", SqlDbType.VarChar, 20).Value = t_StockDamage.StockCode; scom.Parameters.Add("@Compcode", SqlDbType.VarChar, 20).Value = t_StockDamage.Compcode; scom.Parameters.Add("@Locacode", SqlDbType.VarChar, 20).Value = t_StockDamage.Locacode; scom.Parameters.Add("@Suppid", SqlDbType.VarChar, 20).Value = t_StockDamage.Suppid; scom.Parameters.Add("@ProductId", SqlDbType.VarChar, 20).Value = t_StockDamage.ProductId; scom.Parameters.Add("@Stock", SqlDbType.Decimal, 9).Value = t_StockDamage.Stock; scom.Parameters.Add("@OpnStock", SqlDbType.Decimal, 9).Value = t_StockDamage.OpnStock; scom.Parameters.Add("@InitialStock", SqlDbType.Decimal, 9).Value = t_StockDamage.InitialStock; scom.Parameters.Add("@ReservedStock", SqlDbType.Decimal, 9).Value = t_StockDamage.ReservedStock; scom.Parameters.Add("@CostPrice", SqlDbType.Decimal, 9).Value = t_StockDamage.CostPrice; scom.Parameters.Add("@SellingPrice", SqlDbType.Decimal, 9).Value = t_StockDamage.SellingPrice; scom.Parameters.Add("@WholeSalePrice", SqlDbType.Decimal, 9).Value = t_StockDamage.WholeSalePrice; scom.Parameters.Add("@MrpPrice", SqlDbType.Decimal, 9).Value = t_StockDamage.MrpPrice; scom.Parameters.Add("@CompanyPrice", SqlDbType.Decimal, 9).Value = t_StockDamage.CompanyPrice; scom.Parameters.Add("@AvgCost", SqlDbType.Decimal, 9).Value = t_StockDamage.AvgCost; scom.Parameters.Add("@InitialCost", SqlDbType.Decimal, 9).Value = t_StockDamage.InitialCost; scom.Parameters.Add("@Descr", SqlDbType.VarChar, 150).Value = t_StockDamage.Descr; scom.Parameters.Add("@FixedGP", SqlDbType.Decimal, 9).Value = t_StockDamage.FixedGP; scom.Parameters.Add("@SIH", SqlDbType.Decimal, 9).Value = t_StockDamage.SIH; scom.Parameters.Add("@EXPDate", SqlDbType.DateTime, 8).Value = t_StockDamage.EXPDate; scom.Parameters.Add("@Usercode", SqlDbType.VarChar, 20).Value = t_StockDamage.Usercode; scom.Parameters.Add("@DateCr", SqlDbType.DateTime, 8).Value = t_StockDamage.DateCr; 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); } }
/// <summary> /// Saves a record to the T_StockRet table. /// </summary> public Boolean SaveT_StockRetSP(T_StockDamage t_StockRet, int formMode) { SqlCommand scom; bool retvalue = false; try { scom = new SqlCommand(); scom.CommandType = CommandType.StoredProcedure; scom.CommandText = "T_StockRetSave"; scom.Parameters.Add("@StockCode", SqlDbType.VarChar, 20).Value = t_StockRet.StockCode; scom.Parameters.Add("@Compcode", SqlDbType.VarChar, 20).Value = t_StockRet.Compcode; scom.Parameters.Add("@Locacode", SqlDbType.VarChar, 20).Value = t_StockRet.Locacode; scom.Parameters.Add("@Suppid", SqlDbType.VarChar, 20).Value = t_StockRet.Suppid; scom.Parameters.Add("@ProductId", SqlDbType.VarChar, 20).Value = t_StockRet.ProductId; //scom.Parameters.Add("@Type", SqlDbType.VarChar, 20).Value = t_StockRet.Type; //scom.Parameters.Add("@Qty", SqlDbType.Decimal, 9).Value = t_StockRet.Qty; scom.Parameters.Add("@SellingPrice", SqlDbType.Decimal, 9).Value = t_StockRet.SellingPrice; scom.Parameters.Add("@CostPrice", SqlDbType.Decimal, 9).Value = t_StockRet.CostPrice; scom.Parameters.Add("@AvgCost", SqlDbType.Decimal, 9).Value = t_StockRet.AvgCost; scom.Parameters.Add("@OpnStock", SqlDbType.Decimal, 9).Value = t_StockRet.OpnStock; scom.Parameters.Add("@InitialCost", SqlDbType.Decimal, 9).Value = t_StockRet.InitialCost; scom.Parameters.Add("@InitialStock", SqlDbType.Decimal, 9).Value = t_StockRet.InitialStock; scom.Parameters.Add("@Descr", SqlDbType.VarChar, 150).Value = t_StockRet.Descr; scom.Parameters.Add("@Usercode", SqlDbType.VarChar, 20).Value = t_StockRet.Usercode; //scom.Parameters.Add("@Datex", SqlDbType.DateTime, 8).Value = t_StockRet.Datex; 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 T_StockDamage Selectt_Stock_new(T_StockDamage objt_Stock) { try { string xstrquery = @"select * from T_StockDamage where StockCode = '" + objt_Stock.StockCode + "' and Compcode = '" + objt_Stock.Compcode.Trim() + "' and Locacode = '" + objt_Stock.Locacode.Trim() + "'"; DataRow drType = u_DBConnection.ReturnDataRow(xstrquery); if (drType != null) { objt_Stock.StockCode = drType["StockCode"].ToString(); objt_Stock.Compcode = drType["Compcode"].ToString(); objt_Stock.Locacode = drType["Locacode"].ToString(); objt_Stock.Suppid = drType["Suppid"].ToString(); objt_Stock.ProductId = drType["ProductId"].ToString(); objt_Stock.Stock = decimal.Parse(drType["Stock"].ToString()); objt_Stock.OpnStock = decimal.Parse(drType["OpnStock"].ToString()); objt_Stock.InitialStock = decimal.Parse(drType["InitialStock"].ToString()); objt_Stock.ReservedStock = decimal.Parse(drType["ReservedStock"].ToString()); objt_Stock.CostPrice = decimal.Parse(drType["CostPrice"].ToString()); objt_Stock.SellingPrice = decimal.Parse(drType["SellingPrice"].ToString()); objt_Stock.WholeSalePrice = decimal.Parse(drType["WholeSalePrice"].ToString()); objt_Stock.MrpPrice = decimal.Parse(drType["MrpPrice"].ToString()); objt_Stock.CompanyPrice = decimal.Parse(drType["CompanyPrice"].ToString()); objt_Stock.AvgCost = decimal.Parse(drType["AvgCost"].ToString()); objt_Stock.InitialCost = decimal.Parse(drType["InitialCost"].ToString()); objt_Stock.Descr = drType["Descr"].ToString(); objt_Stock.FixedGP = decimal.Parse(drType["FixedGP"].ToString()); objt_Stock.SIH = decimal.Parse(drType["SIH"].ToString()); objt_Stock.EXPDate = DateTime.Parse(drType["EXPDate"].ToString()); objt_Stock.Usercode = drType["Usercode"].ToString(); objt_Stock.DateCr = DateTime.Parse(drType["DateCr"].ToString()); return(objt_Stock); } return(null); } catch (Exception ex) { throw ex; } }