public void CreateWShelfItemDetails(WShelfItemDetails obj)
{
SqlConnection conn = new SqlConnection();
conn.ConnectionString = CONNSTRING;
var strSqlContactStmt = @"INSERT INTO WShelfItemDetails(OEMCode, LocationId, CreatedUserId,Length,Width,Height,Weight,Boxing,Damaged,CreatedDate)
VALUES(@oEMCode, @locationId,@createdUserId,@length,@width, @height,@weight,@boxing,@damaged,CURRENT_TIMESTAMP)";
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = conn;
conn.Open();
cmd.Parameters.Add("@oEMCode", SqlDbType.NVarChar).Value = obj.OEMCode;
cmd.Parameters.Add("@locationId", SqlDbType.Int).Value = obj.LocationId;
cmd.Parameters.Add("@createdUserId", SqlDbType.Int).Value = obj.CreatedUserId;
cmd.Parameters.Add("@length", SqlDbType.NVarChar).Value = obj.Length;
cmd.Parameters.Add("@width", SqlDbType.NVarChar).Value = obj.Width;
cmd.Parameters.Add("@weight", SqlDbType.NVarChar).Value = obj.Weight;
cmd.Parameters.Add("@boxing", SqlDbType.NVarChar).Value = obj.Boxing;
cmd.Parameters.Add("@damaged", SqlDbType.Bit).Value = obj.Damaged;
cmd.CommandText = strSqlContactStmt;
cmd.ExecuteNonQuery();
}
conn.Close();
}
public WShelfItemDetails GetBYId(int id)
{
var obj = new WShelfItemDetails();
SqlConnection conn = new SqlConnection();
conn.ConnectionString = CONNSTRING;
var strSqlContactStmt = @"SELECT Id, OEMCode, LocationId,Length,Width,Height,Weight,Boxing,Damaged, CreatedUserId ,CreatedDate
FROM dbo.WShelfItemDetails WHERE Id=@Id";
using (SqlCommand cmd = new SqlCommand())
{
cmd.Parameters.Add("@Id", SqlDbType.Int).Value = id;
cmd.CommandText = strSqlContactStmt;
cmd.Connection = conn;
conn.Open();
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
obj.Id = Convert.ToInt32(reader["Id"]);
obj.OEMCode = Convert.ToString(reader["OEMCode"]);
obj.LocationId = Convert.ToInt32(reader["LocationId"]);
obj.CreatedUserId = Convert.ToInt32(reader["CreatedUserId"]);
obj.Length = Convert.ToString(reader["Length"]);
obj.Width = Convert.ToString(reader["Width"]);
obj.Height = Convert.ToString(reader["Height"]);
obj.Weight = Convert.ToString(reader["Weight"]);
obj.Boxing = Convert.ToString(reader["Boxing"]);
obj.Damaged = Convert.ToBoolean(reader["Damaged"]);
obj.CreatedDate = Convert.ToDateTime(reader["CreatedDate"].ToString());
}
}
conn.Close();
return(obj);
}
public void UpdateWShelfItemDetails(WShelfItemDetails obj)
{
SqlConnection conn = new SqlConnection();
conn.ConnectionString = CONNSTRING;
var strSqlContactStmt = @"UPDATE WShelfItemDetails SET OEMCode=@oEMCode, LocationId=@locationId,
Length=@length,Width=@width,Height=@height,Weight=@weight ,
Boxing=@boxing,Damaged=@damaged ModifiedDate=CURRENT_TIMESTAMP WHERE Id=@Id";
using (SqlCommand cmd = new SqlCommand())
{
cmd.Parameters.Add("@Id", SqlDbType.Int).Value = obj.Id;
cmd.Connection = conn;
cmd.Parameters.Add("@oEMCode", SqlDbType.NVarChar).Value = obj.OEMCode;
cmd.Parameters.Add("@locationId", SqlDbType.Int).Value = obj.LocationId;
cmd.Parameters.Add("@length", SqlDbType.NVarChar).Value = obj.Length;
cmd.Parameters.Add("@width", SqlDbType.NVarChar).Value = obj.Width;
cmd.Parameters.Add("@weight", SqlDbType.NVarChar).Value = obj.Weight;
cmd.Parameters.Add("@boxing", SqlDbType.NVarChar).Value = obj.Boxing;
cmd.Parameters.Add("@damaged", SqlDbType.Bit).Value = obj.Damaged;
cmd.CommandText = strSqlContactStmt;
cmd.Connection = conn;
conn.Open();
cmd.ExecuteNonQuery();
}
conn.Close();
}
