public List <SerialNumberEnity> GetSilverStock(string Flag)
{
// int i = 0;
SerialNumberEnity serialentity;
List <SerialNumberEnity> serialentityList = new List <SerialNumberEnity>();
using (SqlConnection myConnection = new SqlConnection(cs))
{
using (SqlCommand cmd = new SqlCommand("spGetSilverStock", myConnection))
{
cmd.CommandType = CommandType.StoredProcedure;
myConnection.Open();
SqlParameter flag = cmd.Parameters.AddWithValue("@Flag", Flag);
bool isnull = true;
using (SqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
isnull = false;
serialentity = new SerialNumberEnity();
serialentity.GulfNo = dr["GulfNo"].ToString();
serialentity.BatchNo = dr["BatchNo"].ToString();
serialentity.MakeName = dr["MakeName"].ToString();
serialentity.ModelName = dr["ModelName"].ToString();
serialentity.InhouseSerialNo = dr["InhouseSerialNo"].ToString();
serialentity.OriginalSerialNo = dr["OriginalSerialNo"].ToString();
serialentity.Status = dr["Status"].ToString();
serialentityList.Add(serialentity);
}
if (isnull)
{
return(null);
}
else
{
return(serialentityList);
}
}
}
}
}
public List <SerialNumberEnity> GetCreateNewOrderForOkStock(string Flag)
{
// int i = 0;
SerialNumberEnity serialentity;
List <SerialNumberEnity> serialentityList = new List <SerialNumberEnity>();
using (SqlConnection myConnection = new SqlConnection(cs))
{
using (SqlCommand cmd = new SqlCommand("spCreateNewOrderForOkStock", myConnection))
{
cmd.CommandType = CommandType.StoredProcedure;
myConnection.Open();
SqlParameter flag = cmd.Parameters.AddWithValue("@Flag", Flag);
bool isnull = true;
using (SqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
isnull = false;
serialentity = new SerialNumberEnity();
serialentity.GulfNo = dr["GulfNo"].ToString();
serialentity.MakeName = dr["MakeName"].ToString();
serialentity.ModelName = dr["ModelName"].ToString();
serialentity.ProcessorName = dr["ProcessorType"].ToString();
serialentity.AvailableQty = Convert.ToInt32(dr["AvailableQty"]);
serialentityList.Add(serialentity);
}
if (isnull)
{
return(null);
}
else
{
return(serialentityList);
}
}
}
}
}
public List <SerialNumberEnity> GetPurchaseDetail()
{
// int i = 0;
SerialNumberEnity serialentity;
List <SerialNumberEnity> serialentityList = new List <SerialNumberEnity>();
using (SqlConnection myConnection = new SqlConnection(cs))
{
using (SqlCommand cmd = new SqlCommand("spGetPurchaseOrder", myConnection))
{
cmd.CommandType = CommandType.StoredProcedure;
myConnection.Open();
bool isnull = true;
using (SqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
isnull = false;
serialentity = new SerialNumberEnity();
serialentity.GulfNo = dr["GulfNo"].ToString();
serialentity.PurchaseQty = Convert.ToInt32(dr["Qty"]);
serialentity.ReceivedQty = Convert.ToInt32(dr["ReceivedQty"]);
serialentity.SCreatedDate = dr["CreatedDate"].ToString();
serialentity.Type = Convert.ToInt32(dr["Type"]);
serialentityList.Add(serialentity);
}
if (isnull)
{
return(null);
}
else
{
return(serialentityList);
}
}
}
}
}
public List <SerialNumberEnity> GetCreateNewOrderDetail(int GulfNo)
{
// int i = 0;
SerialNumberEnity serialentity;
List <SerialNumberEnity> serialentityList = new List <SerialNumberEnity>();
using (SqlConnection myConnection = new SqlConnection(cs))
{
using (SqlCommand cmd = new SqlCommand("spCreateNewOrderForOkStockDetail", myConnection))
{
cmd.CommandType = CommandType.StoredProcedure;
myConnection.Open();
SqlParameter flag = cmd.Parameters.AddWithValue("@GulfNo", GulfNo);
bool isnull = true;
using (SqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
isnull = false;
serialentity = new SerialNumberEnity();
serialentity.GulfNo = dr["GulfNo"].ToString();
serialentity.InhouseSerialNo = dr["InhouseSerialNo"].ToString();
serialentity.OriginalSerialNo = dr["OriginalSerialNo"].ToString();
serialentity.ProcessorName = dr["ProcessorType"].ToString();
serialentityList.Add(serialentity);
}
if (isnull)
{
return(null);
}
else
{
return(serialentityList);
}
}
}
}
}
public List <SerialNumberEnity> GetAllMakeProductData(int id, string Flag)
{
SerialNumberEnity productDetail;
List <SerialNumberEnity> productDetailList = new List <SerialNumberEnity>();
using (SqlConnection myConnection = new SqlConnection(cs))
{
using (SqlCommand cmd = new SqlCommand("spGETPRODUCTDETAIL", myConnection))
{
cmd.CommandType = CommandType.StoredProcedure;
myConnection.Open();
SqlParameter ProductId = cmd.Parameters.AddWithValue("@ProductId", id);
SqlParameter ProductFlag = cmd.Parameters.AddWithValue("@Flag", Flag);
bool isnull = true;
using (SqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
isnull = false;
productDetail = new SerialNumberEnity();
productDetail.MakeId = Convert.ToInt32(dr["ProductId"]);
productDetail.MakeName = dr["ProductName"].ToString();
productDetailList.Add(productDetail);
}
if (isnull)
{
return(null);
}
else
{
return(productDetailList);
}
}
}
}
}
