/// Function Header*******************************************************
/// Function Name: InesrtSectionVisitedDetails
/// Function Type: Function
/// Functionality: used to insert the section visited details
/// Input:
/// Output:
/// Return Value:
/// Note:
/// *********************************************************************
public bool InsertFAQ(Entity.UserInfo oUserInfo)
{
using (TLWDALDataContext _db = new TLWDALDataContext())
{
bool _blnRetVal = true;
var _varFAQ = (from _f in _db.FAQs
where _f.strQuestion.ToLower().Equals(oUserInfo.StrQuestion.ToLower())
&& _f.strHeading.ToLower().Equals(oUserInfo.StrHeading.ToLower())
&& _f.chrisDeleted.Equals('N')
select _f).FirstOrDefault();
if (_varFAQ != null)
_blnRetVal = false;
else
{
DAL.FAQ oFAQ = new FAQ();
oFAQ.intQuestionId = 0;
oFAQ.strHeading = oUserInfo.StrHeading;
oFAQ.strQuestion = oUserInfo.StrQuestion;
oFAQ.strAnswer = oUserInfo.StrAnswer;
oFAQ.chrUserType = oUserInfo.ChrUserType;
oFAQ.dtCreatedOn = oUserInfo.DtCreatedOn;
oFAQ.strUserId = oUserInfo.StrUserId;
oFAQ.chrisDeleted = 'N';
_db.FAQs.InsertOnSubmit(oFAQ);
_db.SubmitChanges();
oFAQ = null;
}
_varFAQ = null;
return _blnRetVal;
}
}
public ActionResult Save(int id = 0, string question = "", string answer = "")
{
try {
if (question.Length == 0) { throw new Exception("You must enter a question"); }
if (answer.Length == 0) { throw new Exception("You must enter an answer"); }
CurtDevDataContext db = new CurtDevDataContext();
if (id == 0) {
FAQ faq = new FAQ {
answer = answer,
question = question
};
db.FAQs.InsertOnSubmit(faq);
} else {
FAQ faq = db.FAQs.Where(x => x.faqID == id).FirstOrDefault<FAQ>();
faq.question = question;
faq.answer = answer;
}
db.SubmitChanges();
return RedirectToAction("Index");
} catch (Exception e) {
if (id == 0) {
return RedirectToAction("Add", new { err = e.Message, q = question, a = answer });
} else {
return RedirectToAction("Edit", new { id = id, err = e.Message, q = question, a = answer });
}
}
}
protected void BtnCommand_Click(object sender, EventArgs e)
{
int result = -1;
try
{
if (Request.Params["action"] != null)
{
action = Request.Params["action"];
if (int.Parse(action) == 1)
{
bid = Request.Params["pid"];
FAQ aston = new FAQ();
aston.Id = int.Parse(bid);
aston.FaqQuestion = txtQuestion.Text;
aston.FaqAnswer = txtAnswer.Text;
aston.Active = chkActive.Checked;
result = DataService.Provider.UpdateFAQ(aston);
}
else
{
}
}
}
catch (Exception ex)
{
ShowError(ex.Message);
}
if (result > 0)
{
Response.Redirect(Util.AdminUrl + "faq-list", true);
}
}
//
// GET: /Faq/Create
public ActionResult Creer()
{
FAQ faq = new FAQ();
faq.DateCreated = DateTime.Now;
ViewData.Model = faq;
ViewBag.idFAQQuestionTheme = new SelectList(db.FAQQuestionTheme, "idFAQQuestionTheme", "Theme");
return View();
}
public ActionResult Creer(FAQ faq)
{
if (ModelState.IsValid)
{
db.FAQ.AddObject(faq);
db.SaveChanges();
return RedirectToAction("Index");
}
ViewBag.idFAQQuestionTheme = new SelectList(db.FAQQuestionTheme, "idFAQQuestionTheme", "Theme", faq.idFAQQuestionTheme);
return View(faq);
}
public static FAQ Get(int id = 0)
{
try {
CurtDevDataContext db = new CurtDevDataContext();
FAQ faq = new FAQ();
faq = db.FAQs.Where(x => x.faqID == id).FirstOrDefault<FAQ>();
return faq;
} catch (Exception e) {
return new FAQ();
}
}
protected void BtnCommand_Click(object sender, EventArgs e)
{
FAQ curr = new FAQ();
curr.FaqAnswer = txtAnswer.Text;
curr.FaqQuestion = txtQuestion.Text;
curr.Active = chkActive.Checked;
int result = DataService.Provider.AddFAQ(curr);
if (result > 0)
{
Response.Redirect(Util.AdminUrl + "faq-list", true);
}
}
public void DeleteQuestion(int id = 0)
{
try {
FAQ tmp = new FAQ {
ID = id
};
tmp.Get();
tmp.Delete();
} catch (Exception e) {
Response.StatusCode = (int)System.Net.HttpStatusCode.InternalServerError;
Response.StatusDescription = e.Message;
Response.Write(e.Message);
}
}
public ActionResult DeleteConfirmed(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
FAQ model = db.forum.Find(id);
if (model == null)
{
return(HttpNotFound());
}
db.forum.Remove(model);
db.SaveChanges();
return(RedirectToAction("List"));
}
public async Task <IHttpActionResult> DeleteQuestion(int id)
{
FAQ faq = await db.FAQ.FindAsync(id);
if (faq == null)
{
return(Json(new { state = false, message = "سوال مورد نظر یافت شد" }));
}
db.FAQ.Remove(faq);
await db.SaveChangesAsync();
return(Json(new { state = true, message = "سوال مورد نظر حذف شد" }));
}
public NewCaseBreakWindow()
{
InitializeComponent();
DataTable dt = FAQ.GetEmployees("SELECT * FROM EMPLOYEES");
cboReceivedBy.DataSource = dt;
cboReceivedBy.DropDownStyle = ComboBoxStyle.DropDown;
cboReceivedBy.AutoCompleteSource = AutoCompleteSource.ListItems;
cboReceivedBy.AutoCompleteMode = AutoCompleteMode.SuggestAppend;
cboReceivedBy.DisplayMember = "name";
cboReceivedBy.ValueMember = "employee_id";
if (dt.Rows.Count > 0)
{
cboReceivedBy.SelectedIndex = 0;
}
}
public ActionResult HideFAQ(int id)
{
FAQ faq = _faqService.GetById(id);
if (faq.isHidden)
{
faq.isHidden = false;
}
else
{
faq.isHidden = true;
}
_faqService.editFAQ(faq);
return(RedirectToAction("FAQManagement", "Admin"));
}
public ActionResult Update([DataSourceRequest] DataSourceRequest request, FAQ faq)
{
if (ModelState.IsValid)
{
try
{
db.Entry(faq).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
catch (Exception ex)
{
}
}
return(RedirectToAction("Index"));
}
public static Boolean DoesOrderHaveStocks(String order_id)
{
DataTable detailsDT = DataSupport.RunDataSet("SELECT * FROM ReleaseOrderDetails WHERE release_order = @id", "id", order_id).Tables[0];
foreach (DataRow row in detailsDT.Rows)
{
int pieces_in_warehouse = FAQ.HowManyPiecesInWarehouse(row["product"].ToString());
int pieces_in_order = FAQ.HowManyPiecesInUOM(row["product"].ToString(), row["uom"].ToString(), int.Parse(row["qty"].ToString()));
if (pieces_in_warehouse < pieces_in_order)
{
return(false);
}
}
return(true);
}
public bool AddFAQ(FAQ fAQ)
{
using (var db = new StoreContext(null))
{
db.FAQs.Add(fAQ);
try
{
db.SaveChanges();
return(true);
}
catch (Exception)
{
return(false);
}
}
}
public async Task UpdateFAQ(FAQ faq)
{
try
{
faq.DateLastUpdated = DateTime.Now;
faq.LastUpdatedBy = _userManager.CurrentUser();
faq.Title = faq.Title.Replace("\r\n", "<br/>");
faq.Content = HttpUtility.HtmlDecode(faq.Content);
_unitOfWork.FAQRepository.Update(faq);
await _unitOfWork.SaveChangesAsync();
}
catch (Exception ex)
{
throw ex;
}
}
private void txtPicklistCode_Click(object sender, KeyEventArgs e)
{
if (e.KeyCode == Keys.Enter)
{
if (!FAQ.DoesPicklistExist(txtPicklistCode.Text))
{
MessageBox.Show("Barcode Not Recognized");
return;
}
DeclarePicklistScanningWindow dialog = new DeclarePicklistScanningWindow();
dialog.txtPicklist.Text = txtPicklistCode.Text;
dialog.ShowDialog();
this.Close();
}
}
public ActionResult Create([Bind(Include = "Question,Answer")] ForumViewModel model)
{
if (ModelState.IsValid)
{
FAQ forum = new FAQ();
forum.Question = model.Question;
forum.Answer = model.Answer;
db.forum.Add(forum);
db.SaveChanges();
ViewBag.AlertMessage = "creation has ended succesfully";
return(RedirectToAction("List"));
}
ViewBag.AlertMessage = "Something gone wrong. Try again please!";
return(RedirectToAction("List"));
}
public ActionResult Edit(FAQ faq)
{
if (ModelState.IsValid)
{
db.Entry(faq).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch
{
return(RedirectToAction("Error", "Home"));
}
return(RedirectToAction("Index"));
}
return(View(faq));
}
public ActionResult TousuAddFAQ(FAQ fAQ)
{
if (fAQ.PKID == 0)
{
manager.TousuFaqAdd(fAQ);
}
else
{
manager.TousuFaqUpdate(fAQ);
}
System.Web.Caching.Cache objCache = System.Web.HttpRuntime.Cache;
if (objCache["AllTousuFAQList"] != null)
{
objCache.Remove("AllTousuFAQList");
}
return(Redirect("TousuFAQManage"));
}
public async Task <ActionResult <List <Group> > > PutFAQ(int id, FAQ fAQ) //
{
if (fAQ.Answer == null || fAQ.Question == null || fAQ.GroupId <= 0 || id <= 0)
{
return(BadRequest());
}
bool done = await FAQActions.PutFAQ(id, fAQ);
if (!done)
{
return(BadRequest());
}
else
{
return(AG.Groups);
}
}
public static void TousuAdd(SqlConnection connection, FAQ fAQ)
{
var sqlParamters = new[]
{
new SqlParameter("@Orderchannel", fAQ.Orderchannel ?? string.Empty),
new SqlParameter("@CateOne", fAQ.CateOne ?? string.Empty),
new SqlParameter("@CateTwo", fAQ.CateTwo ?? string.Empty),
new SqlParameter("@CateThree", fAQ.CateThree ?? string.Empty),
new SqlParameter("@Question", fAQ.Question ?? string.Empty),
new SqlParameter("@Answer", fAQ.Answer ?? string.Empty)
};
SqlHelper.ExecuteNonQuery(connection, CommandType.Text,
@"insert into tbl_TousuFAQ(Orderchannel,CateOne,CateTwo,CateThree,Question,Answer) values
(@Orderchannel,@CateOne,@CateTwo,@CateThree,@Question,@Answer)"
, sqlParamters);
}
public ActionResult Create(FAQ model)
{
try
{
if (ModelState.IsValid)
{
this.faqRepository.Insert(model);
ViewBag.Message = "Record addded successfully.";
}
return(View(model));
}
catch (Exception ex)
{
ViewBag.Message = ex.Message;
return(View(model));
}
}
private void txtPicklistCode_KeyDown(object sender, KeyEventArgs e)
{
if (e.KeyCode == Keys.Enter)
{
if (!FAQ.DoesCaseBreakExist(txtPicklistCode.Text))
{
MessageBox.Show("Barcode Not Recognized");
return;
}
DeclareCaseBreakPicklistScanningWindow dialog = new DeclareCaseBreakPicklistScanningWindow();
dialog.txtPicklist.Text = txtPicklistCode.Text;
if (dialog.ShowDialog() == DialogResult.OK)
{
this.Close();
}
}
}
public FAQ AddFaq(FAQ item)
{
try
{
this.iUnitOfWork.FaqRepository.Insert(item);
this.iUnitOfWork.Save();
if (item.id == null || item.id == 0)
{
return(null);
}
return(item);
}
catch (Exception ex)
{
return(null);
}
}
public ActionResult NewFAQ(FAQ newFAQ)
{
try
{
if (ModelState.IsValid)
{
context.FAQSet.Add(newFAQ);
context.SaveChanges();
return(RedirectToAction("FAQ"));
}
}
catch (DataException)
{
ModelState.AddModelError("", "Unable to save changes. Try again, and if the problem persists see your system administrator.");
}
return(PartialView("_NewFAQ"));
}
private void txtScan_KeyDown(object sender, KeyEventArgs e)
{
if (e.KeyCode == Keys.Enter)
{
String phcount_id = txtScan.Text;
if (!FAQ.DoesPhysicalCountExist(phcount_id))
{
MessageBox.Show("Barcode not recognized");
return;
}
DeclarePhysicalCountWindow dialog = new DeclarePhysicalCountWindow();
dialog.phcount_id = phcount_id;
dialog.ShowDialog();
this.Close();
}
}
[HttpPost] public ActionResult Edit(FAQ model)
{
try
{
if (ModelState.IsValid)
{
this.faqRepository.Update(model);
ViewBag.Message = "Record updated successfully.";
}
return(View(model));
}
catch (Exception ex)
{
ViewBag.Message = ex.Message;
return(View(model));
}
}
public async Task Deletar(int IdFAQ)
{
try
{
unitOfWork = unitOfWork ?? new UnitOfWork(context);
UsuarioADE usuario = await ObterUsuarioLogado();
FAQ FAQ = await _servicoFAQ.BuscarPorId(IdFAQ);
FAQ.Status = EnumStatusFAQ.Rejeitado;
await _servicoFAQ.RemoverAsync(usuario, FAQ);
}
catch (Exception ex)
{
await LogError(ex.Message, ex.Source, Dominio.Models.Enums.EnumTipoLog.CriacaoFAQ);
}
}
public static void Add(SqlConnection connection, FAQ fAQ)
{
var sqlParamters = new[]
{
new SqlParameter("@Orderchannel", fAQ.Orderchannel ?? string.Empty),
new SqlParameter("@CateOne", fAQ.CateOne ?? string.Empty),
new SqlParameter("@CateTwo", fAQ.CateTwo ?? string.Empty),
new SqlParameter("@CateThree", fAQ.CateThree ?? string.Empty),
new SqlParameter("@Question", fAQ.Question ?? string.Empty),
new SqlParameter("@Answer", fAQ.Answer ?? string.Empty),
new SqlParameter("@EndTime", fAQ.EndTime)
};
SqlHelper.ExecuteNonQuery(connection, CommandType.StoredProcedure,
"proc_AddFaq"
, sqlParamters);
}
public IActionResult Edit(FAQ model)
{
var updatefaq = _caseRepository.GetFaqsById(model.Id);
if (model == null)
{
return(NotFound());
}
if (ModelState.IsValid)
{
updatefaq.ModifiedBy = _admin.Name;
updatefaq.ModifiedDate = DateTime.Now;
_caseRepository.UpdateFaq(updatefaq, model);
return(RedirectToAction("index"));
}
return(View(model));
}
public ActionResult Get()
{
try
{
StringBuilder sb = new StringBuilder();
List <Manuscript> documents = new List <Manuscript>();
var formatter = new StandardFormatter();
var faq = new FAQ(formatter);
faq.Title = "The Bridge Pattern FAQ";
faq.Questions.Add("What is it?", "A design pattern");
faq.Questions.Add("When do we use it?", "When you need to separate an abstraction from an implementation.");
documents.Add(faq);
var book = new Book(formatter)
{
Title = "Lots of Patterns",
Author = "Alfonso Gomez",
Text = "Blah blah blah..."
};
documents.Add(book);
var paper = new TermPaper(formatter)
{
Class = "Design Patterns",
Student = "Jose Sanchez",
Text = "Blah blah blah...",
References = "GOF"
};
documents.Add(paper);
foreach (var doc in documents)
{
sb.Append(doc.Print());
}
return(Ok(sb.ToString()));
}
catch (Exception ex)
{
_logger.LogError(ex.ToString());
return(StatusCode(StatusCodes.Status500InternalServerError));
}
}
public HttpResponseMessage Get([FromUri] int service_id)
{
List <FAQ> toReturn = new List <FAQ>();
using (SqlConnection connection = new SqlConnection(System.Web.Configuration.WebConfigurationManager.ConnectionStrings["DBCS"].ConnectionString))
{
string cmdString = "SELECT ID, SERVICE_ID, ANSWER, QUESTION FROM FAQs WHERE SERVICE_ID=@Id";
SqlDataAdapter da = new SqlDataAdapter(cmdString, connection);
da.SelectCommand.Parameters.AddWithValue("@Id", service_id);
DataSet set = new DataSet();
try
{
da.Fill(set);
if (set.Tables[0].Rows.Count > 0)
{
foreach (DataRow row in set.Tables[0].Rows)
{
FAQ faq = new FAQ();
faq.Id = Convert.ToInt32(row["ID"].ToString());
faq.ServiceId = Convert.ToInt32(row["SERVICE_ID"].ToString());
faq.Answer = row["ANSWER"].ToString();
faq.Question = row["QUESTION"].ToString();
toReturn.Add(faq);
}
}
else
{
toReturn = null;
}
return(Request.CreateResponse(HttpStatusCode.OK, toReturn));
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, ex.Message));
}
}
}
public static FAQ LoadFAQ(FAQ faq, DataRow r)
{
if (r["QuestionId"] != DBNull.Value)
{
faq.QuestionId = r["QuestionId"].ToString();
}
faq.Question = r["Question"].ToString();
faq.QuestionDateCreated = Convert.ToDateTime(r["DateCreated"].ToString());
faq.QuestionUserId = r["UserId"].ToString();
faq.Status = Convert.ToBoolean(r["Status"].ToString());
faq.AnswerId = r["AnswerId"].ToString();
faq.Answer = r["Answer"].ToString();
faq.DateAnswered = Convert.ToDateTime(r["DateAnswered"].ToString());
faq.UserAnswerId = r["UserAnsweredId"].ToString();
return(faq);
}
public ActionResult CreateFAQ(FAQ faq)
{
if (Session["User"] != null)
{
if (ModelState.IsValid)
{
if (DAO.InsertFAQ(faq))
{
TempData["IsSuccess"] = true;
return(new HttpStatusCodeResult(200));
}
}
Response.StatusCode = 201;
return(PartialView("CreateFAQForm", faq));
}
return(RedirectToAction("Login"));
}
public ActionResult FAQUpdate(int id, FAQ fa)
{
ViewBag.Group = "Admin";
if (ModelState.IsValid)
{
try
{
objFAQ.commitUpdate(id, fa.Question, fa.Answer);
return(RedirectToAction("FAQAdmin"));
}
catch
{
return(View());
}
}
return(View());
}
public ActionResult Create([Bind(Include = "FaqID,Title,Question,Answer,Author")] FAQ faq)
{
if (ModelState.IsValid)
{
faq.FaqID = Guid.NewGuid();
faq.DateCreated = DateTime.Now;
faq.DateModified = DateTime.Now;
faq.UserCreatedID = Auxiliaries.GetUserId(User);
faq.UserModifiedID = Auxiliaries.GetUserId(User);
db.FAQs.Add(faq);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(faq));
}
public ActionResult Edit([Bind(Include = "Id,Question,Answer,SortOrder")] FAQ fAQ)
{
int nSort = 1000000;
if (fAQ.SortOrder != null)
{
nSort = (int)fAQ.SortOrder;
}
if (ModelState.IsValid)
{
db.Entry(fAQ).State = EntityState.Modified;
db.SaveChanges();
nSort = _dc.ReOrderFAQ(fAQ, nSort);
return(RedirectToAction("Index"));
}
return(View(fAQ));
}
public ActionResult EditQuestion(int id = 0)
{
// Get the FAQ to be edited
FAQ faq = new FAQ { ID = id };
faq.Get();
ViewBag.faq = faq;
// Get the topics
List<FaqTopic> topics = FaqTopic.GetAll();
ViewBag.topics = topics;
try {
FAQ tmp = (FAQ)TempData["faq"];
if (tmp != null) {
ViewBag.faq = tmp;
}
} catch (Exception) { }
if (TempData["error"] != null) {
ViewBag.error = TempData["error"].ToString();
}
return View();
}
internal static void Main(string[] args)
{
var documents = new List<Manuscript>();
///Mojem da podadem koito si iskame Formatter tuka i vsichko ste se formatira po razlichen nachin
var formatter = new FancyFormatter();
var faq = new FAQ(formatter) { Title = "The Bridge Pattern FAQ" };
faq.Questions.Add("What is it?", "A design pattern");
faq.Questions.Add("When do we use it?", "When you need to separate an abstraction from an implementation.");
documents.Add(faq);
var book = new Book(formatter)
{
Title = "Lots of Patterns",
Author = "John Sonmez",
Text = "Blah blah blah..."
};
documents.Add(book);
var paper = new TermPaper(formatter)
{
Class = "Design Patterns",
Student = "Joe N00b",
Text = "Blah blah blah...",
References = "GOF"
};
documents.Add(paper);
foreach (var doc in documents)
{
doc.Print();
}
// Wait for user
Console.ReadKey();
}
public ActionResult faqedit(string t, int? sn)
{
ReturnValue r = new ReturnValue();
FAQ one = new FAQ();
var category = diagnosticService.Faqunitcategory();
dynamic data = new System.Dynamic.ExpandoObject();
try
{
if (!Masterpage.CurrUser.IsExpert)
{
LogHelper.Info(Masterpage.CurrUser.alias, "803022:客户," + Masterpage.CurrUser.client_code + ",编辑FAQ" + sn + "失败，不是专家，权限不足");
r = new ReturnValue { status = "error", message = "权限不足!" };
}
else
{
if (t == "edit") one = diagnosticService.GetOneFAQ(sn.Value);
LogHelper.Info(Masterpage.CurrUser.alias, "803022:客户," + Masterpage.CurrUser.client_code + ",编辑FAQ" + sn);
r = new ReturnValue { status = "ok" };
}
}
catch (Exception ex)
{
LogHelper.Info(Masterpage.CurrUser.alias, "803022:客户," + Masterpage.CurrUser.client_code + ",编辑FAQ" + sn + "失败" + ex.Message);
r = new ReturnValue { status = "error", message = "读取失败!" };
}
data.category = category;
data.r = r;
data.one = one;
data.sn = sn;
data.t = t;
return PartialView("faqedit", data);
}
public ActionResult faqview(string sn)
{
dynamic data = new System.Dynamic.ExpandoObject();
ReturnValue r = new ReturnValue();
FAQ one = new FAQ();
string type = "";
try
{
one = diagnosticService.GetOneFAQ(Convert.ToInt32(sn));
var category = diagnosticService.Faqunitcategory();
if (one.FaqSn > 0)
{
var h = category.FirstOrDefault(p => p.value == one.FaqCategory);
if (h != null) type = h.text;
r.message = "";
r.status = "ok";
LogHelper.Info(Masterpage.CurrUser.alias, "803023:客户," + Masterpage.CurrUser.client_code + ",查看FAQ信息，对应sn:" + sn);
}
else
{
LogHelper.Info(Masterpage.CurrUser.alias, "803023:客户," + Masterpage.CurrUser.client_code + ",查看FAQ信息失败，对应sn:" + sn + ",读取不存在");
r.message = "读取不存在";
r.status = "error";
}
}
catch (Exception ex)
{
LogHelper.Info(Masterpage.CurrUser.alias, "803023:客户," + Masterpage.CurrUser.client_code + ",查看FAQ信息失败，对应sn:" + sn + ex.Message);
r.message = "读取失败";
r.status = "error";
}
data.one = one;
data.type = type;
data.r = r;
return PartialView("faqview", data);
}
public ActionResult Modifier(FAQ faq)
{
if (ModelState.IsValid)
{
db.FAQ.Attach(faq);
db.ObjectStateManager.ChangeObjectState(faq, EntityState.Modified);
db.SaveChanges();
return RedirectToAction("Index");
}
ViewBag.idFAQQuestionTheme = new SelectList(db.FAQQuestionTheme, "idFAQQuestionTheme", "Theme", faq.idFAQQuestionTheme);
return View(faq);
}
/// Function Header*******************************************************
/// Function Name: PrivateAnsweredtoUsersQuestion
/// Function Type: Function
/// Functionality: used to save the answered to private question
/// Input:
/// Output:
/// Return Value:
/// Note:
/// *********************************************************************
public int SaveAnswerFromHealthCoach(Entity.CompanyInfo oCompanyInfo)
{
using (TLWDALDataContext _db = new TLWDALDataContext())
{
int intRetVal = 1;
DAL.UsersPrivateAnswer oUsersPrivateAnswer = new UsersPrivateAnswer();
oUsersPrivateAnswer.intQuestionId = oCompanyInfo.IntQuestionId;
oUsersPrivateAnswer.strAnswer = oCompanyInfo.StrAnswer;
oUsersPrivateAnswer.dtAnsweredOn = oCompanyInfo.DtAnsweredOn;
oUsersPrivateAnswer.strAnswerBy = oCompanyInfo.StrAnsweredBy;
_db.UsersPrivateAnswers.InsertOnSubmit(oUsersPrivateAnswer);
if (oCompanyInfo.StrQuestionType.ToLower().Equals("public"))
{
var _varFAQ = (from _f in _db.FAQs
where _f.intQuestionId.Equals(oCompanyInfo.IntQuestionId)
select _f).FirstOrDefault();
if (_varFAQ != null)
{
_varFAQ.strAnswer = oCompanyInfo.StrAnswer;
}
else
{
DAL.FAQ oFAQ = new FAQ();
oFAQ.intQuestionId = oCompanyInfo.IntQuestionId;
oFAQ.strHeading = "Users FAQ";
oFAQ.strQuestion = oCompanyInfo.StrQuestion;
oFAQ.strAnswer = oCompanyInfo.StrAnswer;
oFAQ.chrUserType = 'U';
oFAQ.dtCreatedOn = oCompanyInfo.DtAnsweredOn;
oFAQ.strUserId = oCompanyInfo.StrUserId;
oFAQ.chrisDeleted = 'N';
_db.FAQs.InsertOnSubmit(oFAQ);
}
}
var _varQuestion = _db.QuestionsForHealthCoaches.Where(x => x.intQuestionId.Equals(oCompanyInfo.IntQuestionId)).FirstOrDefault();
if (_varQuestion != null)
{
_varQuestion.strQuestionType = oCompanyInfo.StrQuestionType;
_varQuestion.chrIsAnsweredGiven = 'Y';
// _db.SubmitChanges();
}
_db.SubmitChanges();
return intRetVal;
}
}
public ActionResult SaveQuestion(int id = 0, string question = "", string answer = "", int topic = 0)
{
FAQ new_faq = new FAQ();
try {
new_faq = new FAQ {
ID = id,
question = question,
answer = answer,
topic = topic
};
new_faq.Save();
return RedirectToAction("Index", "FAQManager");
} catch (Exception e) {
TempData["faq"] = new_faq;
TempData["error"] = e.Message;
return RedirectToAction("EditQuestion", "FAQManager", new { id = id });
}
}
