public CreateNewOfferResponse AddNewOffer(CreateNewOfferRequest request) { var response = new CreateNewOfferResponse { ResponseStatus = ResponseStatus.Success }; var offersProvider = new OffersProvider(); try { if (request.ActionType == ActionType.Insert) { response.isSuccesful = offersProvider.AddNewOffer(request); } else { response.ResponseStatus = ResponseStatus.Failure; response.ResponseDescription = "Not update action"; } } catch (Exception ex) { response.ResponseStatus = ResponseStatus.Failure; response.ResponseDescription = ex.Message; } return(response); }
public bool AddNewOffer(CreateNewOfferRequest request) { var conn = GetConnection(ConnectionNames.CSPSqlDatabase); var commandWrapper = GetStoredProcCommand("dbo.InsertOffer", conn); AddInParameter(commandWrapper, "@ContactPerson", DbType.String, request.Offer.ContactPerson); AddInParameter(commandWrapper, "@PIB", DbType.String, request.Offer.PIB); AddInParameter(commandWrapper, "@Name", DbType.String, request.Offer.Name); AddInParameter(commandWrapper, "@PhoneNumber", DbType.String, request.Offer.PhoneNumber); AddInParameter(commandWrapper, "@Mail", DbType.String, request.Offer.Mail); var services = ""; foreach (var service in request.Offer.Services) { services += service.ServiceId + ","; } AddInParameter(commandWrapper, "@ServiceId", DbType.String, services.Substring(0, services.Length - 1)); AddInParameter(commandWrapper, "@UserId", DbType.Int16, request.Offer.UserId); AddInParameter(commandWrapper, "@HeardFrom", DbType.String, request.Offer.HeardFrom); AddInParameter(commandWrapper, "@Impression", DbType.String, request.Offer.Impression); AddInParameter(commandWrapper, "@BackInfo", DbType.String, request.Offer.BackInfo); AddInParameter(commandWrapper, "@Amount", DbType.Int16, request.Offer.Amount); AddInParameter(commandWrapper, "@AmountCurrency", DbType.String, request.Offer.AmountCurrency); AddInParameter(commandWrapper, "@IsOurCreation", DbType.Boolean, request.Offer.IsOurCreation); AddInParameter(commandWrapper, "@Note", DbType.String, request.Offer.Note); AddInParameter(commandWrapper, "@MakeRent", DbType.Boolean, request.Offer.MakeRent); AddInParameter(commandWrapper, "@CompanyType", DbType.String, request.Offer.CompanyType); AddInParameter(commandWrapper, "@CompanySubType", DbType.String, request.Offer.CompanySubType); AddInParameter(commandWrapper, "@ERROR", DbType.String, 1000); AddInParameter(commandWrapper, "@ERROR_CODE", DbType.String, 4); try { conn.Open(); int results = commandWrapper.ExecuteNonQuery(); var isProcedureSucced = Convert.ToBoolean(results); MakeDboLog(request.ToString(), isProcedureSucced.ToString(), "dbo.InsertOffer"); var errorObject = GetParameterValue(commandWrapper, "@ERROR"); var errorCodeObject = GetParameterValue(commandWrapper, "@ERROR_CODE"); return(Convert.ToBoolean(results)); } finally { commandWrapper.Dispose(); conn.Close(); } }
public CreateNewOfferRequest GetCreateNewOfferRequest(Offer offer) { var request = new CreateNewOfferRequest { Offer = offer, ActionType = Requests.ActionType.Insert }; return(request); }