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