/// <summary>
/// Update a row
/// </summary>
/// <param name="entity"></param>
/// <returns></returns>
public int Company_Update(Company entity)
{
return companyDal.Company_Update(entity);
}
/// <summary>
/// Update a row
/// </summary>
/// <param name="entity"></param>
/// <returns></returns>
public int Company_Update(Company entity)
{
using (SqlConnection connection = new SqlConnection(AppConfiguration.ConnectionString))
{
try
{
SqlCommand command = new SqlCommand("Company_Update", connection);
command.CommandType = CommandType.StoredProcedure;
command.Parameters.Add("@Company_Id", SqlDbType.UniqueIdentifier);
command.Parameters["@Company_Id"].Value = entity.Company_Id;
command.Parameters.Add("@Company_Name", SqlDbType.NVarChar);
command.Parameters["@Company_Name"].Value = entity.Company_Name;
command.Parameters.Add("@Company_Logo", SqlDbType.NVarChar);
command.Parameters["@Company_Logo"].Value = entity.Company_Logo;
command.Parameters.Add("@Company_Description", SqlDbType.NVarChar);
command.Parameters["@Company_Description"].Value = entity.Company_Description;
command.Parameters.Add("@Company_Phone", SqlDbType.NVarChar);
command.Parameters["@Company_Phone"].Value = entity.Company_Phone;
command.Parameters.Add("@Company_Email", SqlDbType.NVarChar);
command.Parameters["@Company_Email"].Value = entity.Company_Email;
command.Parameters.Add("@Company_Address", SqlDbType.NVarChar);
command.Parameters["@Company_Address"].Value = entity.Company_Address;
command.Parameters.Add("@Company_IsDelete", SqlDbType.Bit);
command.Parameters["@Company_IsDelete"].Value = entity.Company_IsDelete;
connection.Open();
return command.ExecuteNonQuery();
}
catch (Exception)
{
throw;
}
finally
{
connection.Dispose();
}
}
}
/// <summary>
/// Insert a row
/// </summary>
/// <param name="entity"></param>
/// <returns></returns>
public int Company_Insert(Company entity)
{
return companyDal.Company_Insert(entity);
}