public HttpResponseMessage EditEstablishment([FromBody] Establishment2Edit establishment)
{
int totalRecordsEffected = EstablishmentManagement.GetInstance.EditEstablishment(establishment);
if (totalRecordsEffected > 0)
{
return(new iCAS.WebAPI.ResponseMessage().ReturnHttpResponseMessage(true, totalRecordsEffected, string.Format("Successfully updated {0} record", totalRecordsEffected)));
}
else
{
return(new iCAS.WebAPI.ResponseMessage().ReturnHttpResponseMessage(false, totalRecordsEffected, "Failed to update any record"));
}
}
public int EditEstablishment(Establishment2Edit establishment)
{
int ReturnValue = 0;
using (SqlCommand UpdateCommand = new SqlCommand())
{
UpdateCommand.Parameters.Add(GetParameter("@ReturnValue", SqlDbType.Int, ReturnValue)).Direction = ParameterDirection.Output;
UpdateCommand.Parameters.Add(GetParameter("@ESTB_ID", SqlDbType.Int, establishment.EstbID));
UpdateCommand.Parameters.Add(GetParameter("@ESTB_TITLE", SqlDbType.VarChar, establishment.Title));
UpdateCommand.Parameters.Add(GetParameter("@ESTB_DESC", SqlDbType.VarChar, establishment.Description));
UpdateCommand.CommandText = "pICAS_Establishments_Update_Record";
ExecuteStoredProcedure(UpdateCommand);
ReturnValue = int.Parse(UpdateCommand.Parameters[0].Value.ToString());
return(ReturnValue);
}
}
public int EditEstablishment(Establishment2Edit establishment)
{
return(EstablishmentIntegration.EditEstablishment(establishment));
}
public static int EditEstablishment(Establishment2Edit establishment)
{
return(EstablishmentDataAccess.GetInstance.EditEstablishment(establishment));
}
