public bool UpdateLIB_Publisher(LIB_Publisher lIB_Publisher)
{
using (SqlConnection connection = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("UpdateLIB_Publisher", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@PublisherID", SqlDbType.Int).Value = lIB_Publisher.PublisherID;
cmd.Parameters.Add("@Address", SqlDbType.NVarChar).Value = lIB_Publisher.Address;
cmd.Parameters.Add("@PublisherName", SqlDbType.NVarChar).Value = lIB_Publisher.PublisherName;
cmd.Parameters.Add("@Email", SqlDbType.NVarChar).Value = lIB_Publisher.Email;
cmd.Parameters.Add("@Phone", SqlDbType.NVarChar).Value = lIB_Publisher.Phone;
cmd.Parameters.Add("@Mobile", SqlDbType.NVarChar).Value = lIB_Publisher.Mobile;
cmd.Parameters.Add("@Country", SqlDbType.NVarChar).Value = lIB_Publisher.Country;
cmd.Parameters.Add("@ModifiedBy", SqlDbType.NVarChar).Value = lIB_Publisher.ModifiedBy;
cmd.Parameters.Add("@ModifiedDate", SqlDbType.DateTime).Value = lIB_Publisher.ModifiedDate;
connection.Open();
int result = cmd.ExecuteNonQuery();
return result == 1;
}
}
public LIB_Publisher GetLIB_PublisherFromReader(IDataReader reader)
{
try
{
LIB_Publisher lIB_Publisher = new LIB_Publisher
(
DataAccessObject.IsNULL<int>(reader["PublisherID"]),
DataAccessObject.IsNULL<string>(reader["Address"]),
DataAccessObject.IsNULL<string>(reader["PublisherName"]),
DataAccessObject.IsNULL<string>(reader["Email"]),
DataAccessObject.IsNULL<string>(reader["Phone"]),
DataAccessObject.IsNULL<string>(reader["Mobile"]),
DataAccessObject.IsNULL<string>(reader["Country"]),
DataAccessObject.IsNULL<string>(reader["AddedBy"].ToString()),
DataAccessObject.IsNULL<DateTime>(reader["AddedDate"]),
DataAccessObject.IsNULL<string>(reader["ModifiedBy"].ToString()),
DataAccessObject.IsNULL<DateTime>(reader["ModifiedDate"])
);
return lIB_Publisher;
}
catch(Exception ex)
{
return null;
}
}
