public IHttpActionResult MMCS_EditCompanyDetail([FromBody] MMCS_CompanySet MMCS_CompanyEditSet) { int status; try { status = iCompanyBL.MMCS_EditCompanyDetail(MMCS_CompanyEditSet); } catch (Exception ex) { throw ex; } return(Ok(status)); }
public int MMCS_EditCompanyDetail(MMCS_CompanySet MMCS_CompanyEditSet) { int status = 0; try { status = icompanyDL.MMCS_EditCompanyDetail(MMCS_CompanyEditSet); } catch (Exception ex) { throw ex; } return(status); }
public int MMCS_EditCompanyDetail(MMCS_CompanySet MMCS_CompanyEditSet) { var statusParameter = new SqlParameter(); statusParameter.ParameterName = "@Status"; statusParameter.Direction = ParameterDirection.Output; statusParameter.SqlDbType = SqlDbType.Int; try { using (aircheck_cloneEntities db = new aircheck_cloneEntities()) { db.Database.ExecuteSqlCommand("[dbo].[MMCS_CompanySet] @companyID,@companyName,@arid,@mediaOwnerID,@marketID,@phone,@fax,@address,@city,@state,@zipcode,@country,@contractDesc,@contractStart,@contractEnd,@dataStart,@dataEnd,@paymentType,@active,@themeID,@isAllFullAudioOverride,@salesRepID,@autoRenewal,@Status OUT", new SqlParameter("@companyID", MMCS_CompanyEditSet.companyID), new SqlParameter("@companyName", MMCS_CompanyEditSet.companyName), new SqlParameter("@arid", MMCS_CompanyEditSet.arid), new SqlParameter("@mediaOwnerID", MMCS_CompanyEditSet.mediaOwnerID), new SqlParameter("@marketID", MMCS_CompanyEditSet.marketID), new SqlParameter("@phone", MMCS_CompanyEditSet.phone), new SqlParameter("@fax", MMCS_CompanyEditSet.fax), new SqlParameter("@address", MMCS_CompanyEditSet.address), new SqlParameter("@city", MMCS_CompanyEditSet.city), new SqlParameter("@state", MMCS_CompanyEditSet.state), new SqlParameter("@zipcode", MMCS_CompanyEditSet.zipcode), new SqlParameter("@country", MMCS_CompanyEditSet.country), new SqlParameter("@contractDesc", MMCS_CompanyEditSet.contractDesc), new SqlParameter("@contractStart", MMCS_CompanyEditSet.contractStart), new SqlParameter("@contractEnd", MMCS_CompanyEditSet.contractEnd), new SqlParameter("@dataStart", MMCS_CompanyEditSet.dataStart), new SqlParameter("@dataEnd", MMCS_CompanyEditSet.dataEnd), new SqlParameter("@paymentType", MMCS_CompanyEditSet.paymentType), new SqlParameter("@active", MMCS_CompanyEditSet.active), new SqlParameter("@themeID", MMCS_CompanyEditSet.themeID), new SqlParameter("@isAllFullAudioOverride", MMCS_CompanyEditSet.isAllFullAudioOverride), new SqlParameter("@salesRepID", MMCS_CompanyEditSet.salesRepID), new SqlParameter("@autoRenewal", MMCS_CompanyEditSet.autoRenewal), statusParameter); } } catch (Exception ex) { statusParameter.Value = -1; throw ex; } return(Convert.ToInt32(statusParameter.Value)); }