public int Insert(BO.DMS_AreaStock ObjDMS_AreaStock)
{
try
{
int returnStatus = 0;
SqlConnection con = CreateCon();
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = new SqlCommand();
da.SelectCommand.CommandText = "POS_DMS_SP_INSERT_AreaStock";
da.SelectCommand.CommandType = CommandType.StoredProcedure;
da.SelectCommand.Connection = con;
da.SelectCommand.Parameters.Add("@AreaID", SqlDbType.Int).Value = ObjDMS_AreaStock.AreaID;
da.SelectCommand.Parameters.Add("@ProductID", SqlDbType.Int).Value = ObjDMS_AreaStock.ProductID;
da.SelectCommand.Parameters.Add("@CtnOrPkt", SqlDbType.Int).Value = ObjDMS_AreaStock.CtnOrPkt;
da.SelectCommand.Parameters.Add("@Pcs", SqlDbType.Int).Value = ObjDMS_AreaStock.Pcs;
da.SelectCommand.Parameters.Add("@Qty", SqlDbType.Int).Value = ObjDMS_AreaStock.Qty;
da.SelectCommand.Parameters.Add("@Strip", SqlDbType.Int).Value = ObjDMS_AreaStock.Strip;
da.SelectCommand.Parameters.Add("@PcsPerStrip", SqlDbType.Int).Value = ObjDMS_AreaStock.PcsPerStrip;
//da.SelectCommand.Parameters.Add("@PP", SqlDbType.Decimal,2).Value = ObjDMS_AreaStock.PP;
//da.SelectCommand.Parameters.Add("@MRP", SqlDbType.Decimal,2).Value = ObjDMS_AreaStock.MRP;
//da.SelectCommand.Parameters.Add("@Vat", SqlDbType.Decimal,2).Value = ObjDMS_AreaStock.Vat;
//da.SelectCommand.Parameters.Add("@TP", SqlDbType.Decimal,2).Value = ObjDMS_AreaStock.TP;
//da.SelectCommand.Parameters.Add("@StockDate", SqlDbType.DateTime).Value = ObjDMS_AreaStock.StockDate;
da.SelectCommand.Parameters.Add("@TransactionDate", SqlDbType.Date).Value = ObjDMS_AreaStock.StockTransantionDate;
if (con.State == ConnectionState.Closed)
{
con.Open();
}
if (da.SelectCommand.ExecuteNonQuery() == 1)
{
returnStatus = 1;
}
else
{
returnStatus = 0;
}
if (con.State == ConnectionState.Open)
{
con.Close();
}
return(returnStatus);
}
catch (Exception ex)
{
throw ex;
}
}
public IList <BO.DMS_AreaStock> GetProductWiseStock()
{
try
{
SqlConnection con = CreateCon();
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = new SqlCommand();
da.SelectCommand.CommandText = "[POS_SP_GET_ProductWiseMDS_Area_Stock]";
da.SelectCommand.CommandType = CommandType.StoredProcedure;
da.SelectCommand.Connection = con;
if (con.State == ConnectionState.Closed)
{
con.Open();
}
DataSet ds = new DataSet();
da.Fill(ds);
if (con.State == ConnectionState.Open)
{
con.Close();
}
DataTable dt = ds.Tables[0];
List <POS.BO.DMS_AreaStock> objStockList = new List <POS.BO.DMS_AreaStock>();
POS.BO.DMS_AreaStock obj = null;
int index = 1;
foreach (DataRow row in dt.Rows)
{
obj = new BO.DMS_AreaStock();
obj.Sln = index++;
//obj.AsID = Convert.ToInt32(row["ID"]);
obj.ProductName = row["ProductName"].ToString();
obj.ProductCode = row["ProductCode"].ToString();
obj.PackSize = row["PackSizeName"].ToString();
obj.PP = Convert.ToDecimal(row["PP"]);
obj.CtnOrPkt = Convert.ToInt32(row["CtnOrPktStock"]);
obj.Pcs = Convert.ToInt32(row["PcsStock"]);
obj.Qty = Convert.ToInt32(row["Balance"]);
obj.StockDate = Convert.ToDateTime(row["StockDate"]);
objStockList.Add(obj);
}
return(objStockList);
}
catch (Exception ex)
{
throw;
}
}
public BO.DMS_AreaStock GetCurrentStockByProductID(long ProductID)
{
try
{
SqlConnection con = CreateCon();
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = new SqlCommand();
da.SelectCommand.CommandText = "POS_SP_GetCurrentStockByProductID";
da.SelectCommand.CommandType = CommandType.StoredProcedure;
da.SelectCommand.Connection = con;
da.SelectCommand.Parameters.Add("@AreaID", SqlDbType.Int).Value = 1;
da.SelectCommand.Parameters.Add("@ProductID", System.Data.SqlDbType.BigInt).Value = ProductID;
if (con.State == ConnectionState.Closed)
{
con.Open();
}
DataSet ds = new DataSet();
da.Fill(ds);
if (con.State == ConnectionState.Open)
{
con.Close();
}
DataTable dt = ds.Tables[0];
List <POS.BO.DMS_AreaStock> objProductPackSize = new List <POS.BO.DMS_AreaStock>();
POS.BO.DMS_AreaStock obj = null;
int index = 1;
foreach (DataRow row in dt.Rows)
{
obj = new BO.DMS_AreaStock();
obj.Sln = index++;
obj.CtnOrPkt = Convert.ToInt32(row["CtnOrPktStock"]);
obj.Qty = Convert.ToInt32(row["Balance"]);
obj.Pcs = Convert.ToInt32(row["PcsStock"]);
}
return(obj);
}
catch (Exception)
{
throw;
}
}
public int Delete(BO.DMS_AreaStock ObjDMS_AreaStock)
{
return(0);
}
public int Update(BO.DMS_AreaStock ObjDMS_AreaStock)
{
return(0);
}