public static ProductQuestion InsertProductQuestion(int ProductId, string Text, int FollowerId)
{
MarketBotDbContext db = new MarketBotDbContext();
try
{
ProductQuestion question = new ProductQuestion {
FollowerId = FollowerId, ProductId = ProductId, Text = Text, TimeStamp = DateTime.Now
};
db.ProductQuestion.Add(question);
db.SaveChanges();
question.Product = db.Product.Find(ProductId);
question.Follower = db.Follower.Find(FollowerId);
return(question);
}
catch
{
return(null);
}
finally
{
}
}
public static bool OpenModalAndWriteQuestionProduct(ProductQuestion productQuestion)
{
if (ProductPageCommon.GoToFAQAnchor(_driver))
{
return(ProductPageCommon.OpenFAQWindowAndWriteQuestion(_driver, productQuestion));
}
return(false);
}
public ActionResult Add(ProductQuestionModel model)
{
ProductQuestion productQuestion = new ProductQuestion();
productQuestion.Title = model.Title;
productQuestion.QuestionText = model.QuestionText;
productQuestion.OrderNum = model.OrderNum;
_productService.AddProductQuestion(productQuestion);
return(RedirectToAction("List"));
}
public ActionResult Edit(int?id)
{
ProductQuestion productQuestion;
if (id.HasValue)
{
productQuestion = ProductQuestions.GetByID(id.Value);
}
else
{
productQuestion = new ProductQuestion();
}
return(View(model: productQuestion));
}
public void Setup()
{
_configuration = EnvironmentSettings.GetConfiguration();
_exptectedProductForCompare = int.Parse(_configuration[
"CheckComparisonProduct:exptectedProductForCompare"]);
_searchVariable = _configuration["CheckSearchFunction:searchVariable"];
_user = new User(_configuration);
_review = new ProductReview(_configuration);
_question = new ProductQuestion(_configuration);
_expectedBreadcrumbTitle = _configuration["CheckDeliveryPage:expectedBreadcrumbTitle"];
_expectedCountProductsInCart = int.Parse(
_configuration["CheckAddingProductsToCart:expectedCountProductsInCart"]);
Steps.InitBrowser();
}
protected void PrepareProductQuestionModel(ProductQuestionModel model,
ProductQuestion productQuestion, bool excludeProperties, bool formatReviewText)
{
if (model == null)
{
throw new ArgumentNullException("model");
}
if (productQuestion == null)
{
throw new ArgumentNullException("ProductQuestion");
}
model.Id = productQuestion.Id;
model.OrderNum = productQuestion.OrderNum;
model.QuestionText = productQuestion.QuestionText;
model.Title = productQuestion.Title;
}
public static bool FillQuestionForm(IWebDriver driver, ProductQuestion productQuestion)
{
var cityInput = driver.FindElement(By.XPath(_cityInputXPath));
cityInput.Clear();
var phoneInput = driver.FindElement(By.XPath(_phoneInputXPath));
phoneInput.Clear();
var questionInput = driver.FindElement(By.XPath(_questionInputXPath));
questionInput.Clear();
cityInput.SendKeys(productQuestion.City);
phoneInput.SendKeys(productQuestion.PhoneNumber);
questionInput.SendKeys(productQuestion.QuestionBody);
var captchaCheckBox = driver.FindElement(By.Id(_captchaId));
captchaCheckBox.Click();
Thread.Sleep(3000);
return(driver.FindElement(By.Id(_buttonSubmitId)).Enabled);
}
public List <ProductQuestion> GetProductQuestionSList(string conStr, int productId)
{
List <ProductQuestion> productQuestions = new List <ProductQuestion>();
// Creating Connection
using (SqlConnection con = new SqlConnection(conStr))
{
SqlCommand command = new SqlCommand();
command.Connection = con;
command.CommandText = "SP_GetProductQuestions";
command.CommandType = CommandType.StoredProcedure;
command.Parameters.Add("@productid", SqlDbType.Int).Value = productId;
con.Open();
SqlDataReader reader = command.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
//Console.WriteLine("{0}: {1:C}", reader[0], reader[1]);
ProductQuestion question = new ProductQuestion();
question.questionId = reader.IsDBNull(0) ? 0 : reader.GetInt32(0);
question.ProductId = reader.IsDBNull(1) ? 0 : reader.GetInt32(1);
question.questionDescription = reader.IsDBNull(2) ? "" : reader.GetString(2);
question.questionType = reader.IsDBNull(3) ? "" : reader.GetString(3);
question.FeedBackCategoryId = reader.IsDBNull(4) ? 0 : reader.GetInt32(4);
productQuestions.Add(question);
}
}
else
{
//Handle custom message
}
reader.Close();
}
return(productQuestions);
//string val = conStr;
}
public ActionResult Edit(ProductQuestion productQuestion, string sendEmail)
{
try
{
productQuestion.LastUpdate = DateTime.Now;
ViewBag.Success = true;
if (productQuestion.ID == -1)
{
productQuestion.UserID = UserID;
productQuestion.DateTime = DateTime.Now;
ProductQuestions.Insert(productQuestion);
UserNotifications.Send(UserID, String.Format("جدید - سوالات متداول '{0}'", productQuestion.Question), "/Admin/ProductQuestions/Edit/" + productQuestion.ID, NotificationType.Success);
productQuestion = new ProductQuestion();
}
else
{
ProductQuestions.Update(productQuestion);
if (!String.IsNullOrWhiteSpace(productQuestion.UserID) && sendEmail == "on" && productQuestion.QuestionStatus == QuestionStatus.Answered)
{
var user = OSUsers.GetByID(productQuestion.UserID);
EmailServices.SendEmail(user.Email, "پاسخ به پرسش شما", productQuestion.Reply, user.Id);
}
}
}
catch (Exception ex)
{
SetErrors(ex);
}
return(ClearView(model: productQuestion));
}
public ProductQuestionViewMessage(ProductQuestion productQuestion)
{
ProductQuestion = productQuestion;
}
