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