public List <InvModel> getInvProduct(string Name)
{
string strcon = "Data Source=CSCINDAE752836\\SQLEXPRESS;Initial Catalog=MC_90_June;User ID=sa;Password=password-1";
using (SqlConnection connection = new SqlConnection(strcon))
{
connection.Open();
SqlCommand cmd = new SqlCommand("", connection);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.CommandText = "Inventory";
cmd.Parameters.Add("@mode", SqlDbType.Int);
cmd.Parameters.Add("@ProductName", SqlDbType.VarChar);
cmd.Parameters["@mode"].Value = 1;
cmd.Parameters["@ProductName"].Value = (!string.IsNullOrEmpty(Name)) ? Name : Convert.DBNull;
SqlDataAdapter da = new SqlDataAdapter(cmd);
List <InvModel> lstInv = new List <InvModel>();
DataSet ds = new DataSet();
da.Fill(ds);
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
InvModel objinv = new InvModel();
objinv.ProductName = ds.Tables[0].Rows[i]["Product_Name"].ToString();
objinv.InventoryID = Convert.ToInt32(ds.Tables[0].Rows[i]["Inventory_ID"]);
objinv.QtyIn = Convert.ToDecimal(ds.Tables[0].Rows[i]["QuantityIn"]);
objinv.QtyOut = Convert.ToDecimal(ds.Tables[0].Rows[i]["QuantityOut"]);
lstInv.Add(objinv);
}
return(lstInv);
}
}
public int pInsertInv(InvModel invdet, out object oResult)
{
int lnResult = 0;
oResult = null;
string strcon = "Data Source=CSCINDAE752836\\SQLEXPRESS;Initial Catalog=MC_90_June;User ID=sa;Password=password-1";
using (SqlConnection sqlcon = new SqlConnection(strcon))
{
sqlcon.Open();
SqlCommand cmd = new SqlCommand(strcon, sqlcon);
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "Inventory";
cmd.Parameters.Add("@mode", SqlDbType.Int);
cmd.Parameters.Add("@ProductName", SqlDbType.VarChar);
cmd.Parameters.Add("@QtyIn", SqlDbType.Decimal);
cmd.Parameters.Add("@QtyOut", SqlDbType.Decimal);
cmd.Parameters.Add("@DateCreated", SqlDbType.DateTime);
cmd.Parameters["@mode"].Value = 2;
cmd.Parameters["@ProductName"].Value = (!string.IsNullOrEmpty(invdet.ProductName)) ? invdet.ProductName : Convert.DBNull;
cmd.Parameters["@QtyIn"].Value = (invdet.QtyIn.HasValue) ? invdet.QtyIn : Convert.DBNull;
cmd.Parameters["@QtyOut"].Value = (invdet.QtyOut.HasValue) ? invdet.QtyIn : Convert.DBNull;
cmd.Parameters["@DateCreated"].Value = DateTime.Now;
cmd.Parameters["@InvID"].Direction = ParameterDirection.Output;
lnResult = cmd.ExecuteNonQuery();
if (lnResult != 0)
{
oResult = cmd.Parameters["@InvID"].Value;
}
}
return(lnResult);
}
