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