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