public IHttpActionResult modifySales(int id, string replies)
{
try
{
var query = SellerContactHelper.UpdateReply(id, replies);
var result = _unitOfWork.ExecuteCommand(query, new SqlParameter("@mailId", id));
try
{
var contactDetailsQuery = SellerContactHelper.GetContactInformation(id);
var contactResult = _unitOfWork.ExecuteQuery <SellerContactInfo>(contactDetailsQuery).FirstOrDefault();
var productDetails = _unitOfWork.ProductRepository.Find(x => x.ProductId == contactResult.ProductId).FirstOrDefault();
var branchinfo = _unitOfWork.SellerBranchRepository.Find(x => x.BranchId == contactResult.StoreId).FirstOrDefault();
if (!string.IsNullOrEmpty(contactResult.Email))
{
MailHelper.SendProductReplyMail(contactResult.Email, productDetails.Name, branchinfo.BranchName, replies);
}
if (!string.IsNullOrEmpty(contactResult.Mobile))
{
MessageHelper.SendProductReplyMessage(contactResult.Mobile, productDetails.Name, branchinfo.BranchName, replies);
}
}
catch (Exception ex)
{
}
return(Ok());
}
catch
{
return(StatusCode(HttpStatusCode.ExpectationFailed));
}
}
public List <SellerContact> GetSellerInbox(int storeId)
{
var query = SellerContactHelper.GetSellerInbox(storeId);
var result = _unitOfWork.ExecuteQuery <SellerContact>(query);
return(result);
}
public IHttpActionResult ContactSeller(ProductContactResultSet productContactResultSet)
{
//get brandh details.
var sellerBranch = _unitOfWork.SellerBranchRepository.Find(x => x.BranchId == productContactResultSet.Branchid).FirstOrDefault();
var productDetails = _unitOfWork.ProductRepository.Find(x => x.ProductId == productContactResultSet.ProductId).FirstOrDefault();
if (AllowAdd(productContactResultSet.ProductId, productContactResultSet.Branchid, productContactResultSet.Name, productContactResultSet.Email,
productContactResultSet.Mobile, productContactResultSet.Subject))
{
var sellerquery = SellerContactHelper.InsertSellerContactQuery(productContactResultSet.ProductId, productContactResultSet.Branchid,
productContactResultSet.Name, productContactResultSet.Email, productContactResultSet.Mobile, productContactResultSet.Subject);
var update = _unitOfWork.ExecuteCommand(sellerquery, new SqlParameter("@subject", productContactResultSet.Subject),
new SqlParameter("@branchId", productContactResultSet.Branchid));
try
{
MailHelper.SendProductRequestMail(sellerBranch.BranchName, sellerBranch.Email, productContactResultSet.Name,
productContactResultSet.Email, productContactResultSet.Mobile, productDetails.Name, productContactResultSet.Subject);
MessageHelper.SendProductRequestMessage(sellerBranch.PhoneNumber, productDetails.Name, productContactResultSet.Subject, productContactResultSet.Email,
productContactResultSet.Mobile);
}
catch (Exception ex)
{
}
return(Ok("success"));
}
//You can only sent one message to the store for same product in 2 hours.
return(Ok("failed"));
}
private bool AllowAdd(int productId, int branchid, string name, string email, string mobile, string subject)
{
var verifyInboxquery = SellerContactHelper.VerifyDuplicateInbox(productId, branchid, name, email, mobile);
int count = _unitOfWork.ExecuteQuery <int>(verifyInboxquery).FirstOrDefault();
if (count > 0)
{
return(false);
}
return(true);
}
