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