public async Task <IActionResult> Edit(int id, [Bind("Id,Question,Answer")] Faqs faqs)
{
if (id != faqs.Id)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(faqs);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!FaqsExists(faqs.Id))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
return(View(faqs));
}
private Faqs ReceiveHtml()
{
Faqs faqs = new Faqs();
faqs.FaqsID = 0;
faqs.FaqsCateID = Convert.ToInt32(ddlFaqsCate.SelectedValue);
faqs.ParentFaqsID = 0;
faqs.Title = txtTitle.Text;
faqs.Contents = txtContent.Text;
faqs.PostDate = DateTime.Now;
faqs.FullName = txtFullname.Text;
faqs.Address = txtAddress.Text;
faqs.Department = txtDepartment.Text;
faqs.Email = txtEmail.Text;
faqs.Fax = "";
faqs.Phone = txtPhone.Text;
faqs.NickSkype = "";
faqs.NickYahoo = "";
faqs.Orders = 1;
faqs.Actived = false;
faqs.UserName = "";
faqs.ApprovedDate = DateTime.Now;
return(faqs);
}
public Faqs GetFaqsById(int Id)
{
Faqs _faqs = null;
using (SqlConnection connection = GetConnection())
{
SqlCommand command = new SqlCommand("_FaqsGetById", connection);
command.CommandType = CommandType.StoredProcedure;
command.Parameters.AddWithValue("@FaqsID", Id);
connection.Open();
using (SqlDataReader reader = command.ExecuteReader(CommandBehavior.CloseConnection))
{
if (reader.Read())
{
_faqs = FaqsReader(reader);
}
else
{
throw new DataAccessException("khong ton tai _faqs");
}
}
command.Dispose();
}
return(_faqs);
}
// GET: Admin/Faqs/Delete/5
public bool DeleteConfirmed(int id)
{
Faqs faqs = db.Faqses.Find(id);
db.Faqses.Remove(faqs);
db.SaveChanges();
return(true);
}
public ActionResult Edit([Bind(Include = "Id,Title,Body,Status")] Faqs faqs)
{
if (ModelState.IsValid)
{
db.Entry(faqs).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(faqs));
}
public ActionResult Create([Bind(Include = "Id,Title,Body,Status")] Faqs faqs)
{
if (ModelState.IsValid)
{
db.Faqs.Add(faqs);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(faqs));
}
public ActionResult Edit([Bind(Include = "FaqsID,FaqsTitle,FaqsDiscription,ProductTypeId")] Faqs faqs)
{
if (ModelState.IsValid)
{
db.Entry(faqs).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.ProductTypeId = new SelectList(db.ProductTypes, "ProductTypeId", "Title", faqs.ProductTypeId);
return(RedirectToAction("Index"));
}
public async Task <IActionResult> Create([Bind("Id,Question,Answer")] Faqs faqs)
{
if (ModelState.IsValid)
{
_context.Add(faqs);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(faqs));
}
public ActionResult Create([Bind(Include = "FaqsID,FaqsTitle,FaqsDiscription,ProductTypeId")] Faqs faqs)
{
if (ModelState.IsValid)
{
db.Faqses.Add(faqs);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.ProductTypeId = new SelectList(db.ProductTypes, "ProductTypeId", "Title", faqs.ProductTypeId);
return(View(faqs));
}
// GET: Admin/Faqs/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Faqs faqs = db.Faqs.Find(id);
if (faqs == null)
{
return(HttpNotFound());
}
return(View(faqs));
}
// GET: Admin/Faqs/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Faqs faqs = db.Faqses.Find(id);
if (faqs == null)
{
return(HttpNotFound());
}
ViewBag.ProductTypeId = new SelectList(db.ProductTypes, "ProductTypeId", "Title", faqs.ProductTypeId);
return(PartialView(faqs));
}
// GET: Admin/Faqs/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Faqs faqs = db.Faqs.Find(id);
if (faqs == null)
{
return(HttpNotFound());
}
db.Faqs.Remove(faqs);
db.SaveChanges();
return(RedirectToAction("Index"));
}
protected void btn_add_faqs(object sender, EventArgs e)
{
Faqs obj = ReceiveHtml();
if (txtCapcha.Text.ToLower() == Session["Random"].ToString().ToLower())
{
FaqsBSO objBSO = new FaqsBSO();
FaqsCateBSO faqscateBSO = new FaqsCateBSO();
FaqsCate _faqCate = faqscateBSO.GetFaqsCateById(obj.FaqsCateID);
int i = objBSO.CreateFaqsGet(obj);
string strBody = "<b>Thông tin khách hàng : </b><br/>";
strBody += "<b>Họ tên khách hàng : </b> " + obj.FullName + "<br/>";
strBody += "<b>Email : </b> " + obj.Email + "<br/>";
strBody += "<b>Điện thoại : </b> " + obj.Phone + "<br/>";
strBody += "<b>Đơn vị công tác : </b> " + obj.Department + "<br/>";
strBody += "<b>Địa chỉ : </b> " + obj.Address + "<br/><br/>";
strBody += "<b>Thông tin yêu cầu hỗ trợ : </b> <br/>";
strBody += "<b>Tiêu đề : </b> " + obj.Title + "<br/><br/>";
strBody += "<b>Nội dung yêu cầu : </b> " + obj.Contents + "<br/><br/>";
strBody += "<a href='" + Variables.sWebRoot + "d3/faqs/" + GetString(obj.Title) + "-" + obj.FaqsID + ".aspx'><b>Xem chi tiết</b></a>";
strBody += "<br/>";
ConfigBSO configBSO = new ConfigBSO();
Config config = configBSO.GetAllConfig(Language.language);
MailBSO mailBSO = new MailBSO();
mailBSO.EmailFrom = config.Email_from;
string strObj = "Thông tin yêu cầu hỗ trợ trên website " + config.WebName + " ngày: " + DateTime.Now.ToString("dd:MM:yyyy");
mailBSO.SendMail(config.Email_to, strObj, strBody);
//string strObj1 = "Website Thoitrangdongphuc.com.vn tran trong cam on ";
//mailBSO.SendMail(obj.Email, strObj1, contentMail());
//string strObj3 = "Website Thoitrangdongphuc.com.vn gioi thieu ";
//mailBSO.SendMail(obj.Email, strObj3, contentSendMail());
Tool.Message(this.Page, "Cám ơn bạn đã gửi yêu cầu hỗ trợ đến chúng tôi, tất cả các thông tin bạn yêu cầu chúng tôi sẽ trả lời ngay khi chúng tôi nhận được. Trân trọng!");
}
else
{
Tool.Message(this.Page, "Sai mã xác nhận. Trân trọng!");
}
}
public int CreateFaqsGet(Faqs _faqs)
{
int i = 0;
using (SqlConnection connection = GetConnection())
{
SqlCommand command = new SqlCommand("_FaqsInsert", connection);
command.CommandType = CommandType.StoredProcedure;
command.Parameters.AddWithValue("@Type", 0);
command.Parameters.AddWithValue("@FaqsID", 0);
command.Parameters.AddWithValue("@FaqsCateID", _faqs.FaqsCateID);
command.Parameters.AddWithValue("@ParentFaqsID", _faqs.ParentFaqsID);
command.Parameters.AddWithValue("@FullName", _faqs.FullName);
command.Parameters.AddWithValue("@Title", _faqs.Title);
command.Parameters.AddWithValue("@Contents", _faqs.Contents);
command.Parameters.AddWithValue("@Email", _faqs.Email);
command.Parameters.AddWithValue("@Department", _faqs.Department);
command.Parameters.AddWithValue("@Phone", _faqs.Phone);
command.Parameters.AddWithValue("@Fax", _faqs.Fax);
command.Parameters.AddWithValue("@Address", _faqs.Address);
command.Parameters.AddWithValue("@Actived", _faqs.Actived);
command.Parameters.AddWithValue("@NickYahoo", _faqs.NickYahoo);
command.Parameters.AddWithValue("@NickSkype", _faqs.NickSkype);
command.Parameters.AddWithValue("@Orders", _faqs.Orders);
command.Parameters.AddWithValue("@PostDate", _faqs.PostDate);
command.Parameters.AddWithValue("@UserName", _faqs.UserName);
command.Parameters.AddWithValue("@ApprovedDate", _faqs.ApprovedDate);
SqlParameter parameter = new SqlParameter("@ReturnId", SqlDbType.Int);
parameter.Direction = ParameterDirection.ReturnValue;
command.Parameters.Add(parameter);
connection.Open();
if (command.ExecuteNonQuery() <= 0)
{
throw new DataAccessException("Khong them duoc");
}
else
{
i = (int)parameter.Value;
}
command.Dispose();
}
return(i);
}
public void UpdateFaqs(Faqs _faqs)
{
using (SqlConnection connection = GetConnection())
{
SqlCommand command = new SqlCommand("_FaqsUpdate", connection);
command.CommandType = CommandType.StoredProcedure;
command.Parameters.AddWithValue("@Type", 1);
command.Parameters.AddWithValue("@FaqsID", _faqs.FaqsID);
command.Parameters.AddWithValue("@FaqsCateID", _faqs.FaqsCateID);
command.Parameters.AddWithValue("@ParentFaqsID", _faqs.ParentFaqsID);
command.Parameters.AddWithValue("@FullName", _faqs.FullName);
command.Parameters.AddWithValue("@Title", _faqs.Title);
command.Parameters.AddWithValue("@Contents", _faqs.Contents);
command.Parameters.AddWithValue("@Email", _faqs.Email);
command.Parameters.AddWithValue("@Department", _faqs.Department);
command.Parameters.AddWithValue("@Phone", _faqs.Phone);
command.Parameters.AddWithValue("@Fax", _faqs.Fax);
command.Parameters.AddWithValue("@Address", _faqs.Address);
command.Parameters.AddWithValue("@Actived", _faqs.Actived);
command.Parameters.AddWithValue("@NickYahoo", _faqs.NickYahoo);
command.Parameters.AddWithValue("@NickSkype", _faqs.NickSkype);
command.Parameters.AddWithValue("@Orders", _faqs.Orders);
command.Parameters.AddWithValue("@PostDate", _faqs.PostDate);
command.Parameters.AddWithValue("@UserName", _faqs.UserName);
command.Parameters.AddWithValue("@ApprovedDate", _faqs.ApprovedDate);
connection.Open();
if (command.ExecuteNonQuery() <= 0)
{
throw new DataAccessException("Lỗi không thể cập nhật");
}
else
{
command.Dispose();
}
}
}
private Faqs FaqsReader(SqlDataReader reader)
{
Faqs _faqs = new Faqs();
_faqs.FaqsID = (int)reader["FaqsID"];
_faqs.FaqsCateID = (int)reader["FaqsCateID"];
_faqs.ParentFaqsID = (int)reader["ParentFaqsID"];
_faqs.FullName = (string)reader["FullName"];
_faqs.Title = (string)reader["Title"];
_faqs.Contents = (string)reader["Contents"];
_faqs.Email = (string)reader["Email"];
_faqs.Department = (string)reader["Department"];
_faqs.Phone = (string)reader["Phone"];
_faqs.Fax = (string)reader["Fax"];
_faqs.Address = (string)reader["Address"];
_faqs.Actived = (bool)reader["Actived"];
_faqs.NickYahoo = (string)reader["NickYahoo"];
_faqs.NickSkype = (string)reader["NickSkype"];
_faqs.Orders = (int)reader["Orders"];
_faqs.PostDate = (DateTime)reader["PostDate"];
_faqs.UserName = (string)reader["UserName"];
_faqs.ApprovedDate = (DateTime)reader["ApprovedDate"];
return(_faqs);
}
public void UpdateFaqs(Faqs _faqs)
{
FaqsDAO _faqsDAO = new FaqsDAO();
_faqsDAO.UpdateFaqs(_faqs);
}
public int CreateFaqsGet(Faqs _faqs)
{
FaqsDAO _faqsDAO = new FaqsDAO();
return(_faqsDAO.CreateFaqsGet(_faqs));
}
public void CreateFaqs(Faqs _faqs)
{
FaqsDAO _faqsDAO = new FaqsDAO();
_faqsDAO.CreateFaqs(_faqs);
}
public void InitializeBase(IWebDriver objDriver)
{
//LoginPage = new MdnHomePage(driver);
//LoginPage1 = new MdnLoginPage1(driver);
//HomePage = new MdnHomePage(driver);
//CommonPage = new MdnCommonPage(driver);
#region initialize old
driver = objDriver;
CheckOutobj = new CheckOut(driver);
takeScreenhsot = new ScreenShot(driver);
approvalrequest = new Approvalrequestobject(driver);
instructors = new Instructor(driver);
approvalrequest = new Approvalrequestobject(driver);
DomainConsoleobj = new DomainConsole(driver);
ManageGradebookobj = new ManageGradebook();
Instructorsobj = new Instructorspof();
MyResponsibilitiesobj = new My_Responsibilities(driver);
manageuserobj = new ManageUsers(driver);
objTrainingHome = new TrainingHomes(driver);
objCurriculum = new CreateCurriculum(driver);
classroomcourse = new ClassroomCourse(driver);
ContentSearchobj = new ContentSearch(driver);
objCreate = new Create(driver);
detailspage = new Details(driver);
TrainingHomeobj = new TrainingHomes(driver);
AdminstrationConsoleobj = new AdminstrationConsole(driver);
Testsobj = new Tests(driver);
Detailsobj = new Details(driver);
EditSummaryobj = new EditSummary(driver);
Scorm1_2obj = new Scorm1_2(driver);
EditQuestionobj = new EditQuestion(driver);
EditQuestionGroupobj = new EditQuestionGroup(driver);
AddUsrObj = new AddUsers(driver);
generalcourseobj = new GeneralCourse(driver);
myteachingscheduleobj = new MyTeachingSchedule();
professionaldevelopmentobj = new ProfessionalDevelopments(driver);
documentobj = new Document(driver);
CreateNewAccountobj = new CreateNewAccount(driver);
ManageUsersobj = new ManageUsers(driver);
Createobj = new Create(driver);
summaryobj = new Summary(driver);
reauiredtrainingconsoleobj = new RequiredTrainingConsoles(driver);
requiredtrainingobj = new RequiredTraining(driver);
Trainingobj = new Training(driver);
Loginobj = new Login(driver);
Contentobj = new Content(driver);
Creditsobj = new Credits(driver);
AddContentobj = new AddContent(driver);
Summaryobj = new Summary(driver);
ScheduleAndManageSectionobj = new ScheduleAndManageSection(driver);
SearchResultsobj = new SearchResults(driver);
CourseSectionobj = new CreateNewCourseSectionAndEventPage(driver);
Transcriptsobj = new Transcripts(driver);
Productsobj = new Products(driver);
BrowseTrainingCatalogobj = new BrowseTrainingCatalog(driver);
ShoppingCartsobj = new ShoppingCarts(driver);
ProfessionalDevelopmentsobj = new ProfessionalDevelopments(driver);
Createnewproficencyscaleobj = new Createnewproficencyscale(driver);
Createnewcompetencyobj = new Createnewcompetency(driver);
CreateNewSucessProfileobj = new CreateNewSucessProfile(driver);
SucessProfileobj = new SucessProfile(driver);
Searchobj = new Search(driver);
TrainingActivitiesobj = new TrainingActivities(driver);
ProfessionalDevelopments_learnerobj = new ProfessionalDevelopments_learner(driver);
Organizationobj = new Organization(driver);
DevelopmentPlansobj = new DevelopmentPlans(driver);
AddDevelopmentActivitiesobj = new AddDevelopmentActivities(driver);
MyAccountobj = new MyAccount(driver);
UsersUtilobj = new UsersUtil(driver);
MyCalendersobj = new MyCalenders(driver);
MyReportsobj = new MyReports(driver);
Config_Reportsobj = new Config_Reports(driver);
ConfigurationConsoleobj = new ConfigurationConsole(driver);
ApprovalPathobj = new ApprovalPath(driver);
MyMessageobj = new MyMessages(driver);
MessageUtilobj = new MessageUtil(driver);
MyRequestsobj = new MyRequests(driver);
Blogsobj = new Blogs(driver);
CollabarationSpacesobj = new CollabarationSpaces(driver);
Faqsobj = new Faqs(driver);
HomePageFeedobj = new HomePageFeed(driver);
ProductTypesobj = new ProductTypes(driver);
Surveysobj = new Surveys(driver);
SurveyScalesobj = new SurveyScales(driver);
AuditingConsolesobj = new AuditingConsoles(driver);
Categoryobj = new Category(driver);
Trainingsobj = new Trainings(driver);
VirtualMeetingsobj = new VirtualMeetings(driver);
CreditTypeobj = new CreditType(driver);
AssignedUserobj = new AssignedUser(driver);
AddUsersobj = new AddUsers(driver);
CustomFieldobj = new CustomField(driver);
CreateNewCustomFieldobj = new CreateNewCustomField(driver);
EditFieldobj = new EditField(driver);
EducationLevelobj = new EducationLevel(driver);
EditOrganizationobj = new EditOrganization(driver);
SelectManagerobj = new SelectManager(driver);
Roleobj = new Role(driver);
SelectTrainingPOCobj = new SelectTrainingPOC(driver);
Complexobj = new Complex(driver);
AccountCodesobj = new AccountCodes(driver);
AccountCodeTypesobj = new AccountCodeTypes(driver);
DiscountCodesobj = new DiscountCodes(driver);
ManageTaxRatesobj = new ManageTaxRates(driver);
TaxItemCategoriesobj = new TaxItemCategories(driver);
Certificatesobj = new Certificates(driver);
CourseProvidersobj = new CourseProviders(driver);
ExternalLearningsobj = new ExternalLearnings(driver);
ExternalLearningConsolesobj = new ExternalLearningConsoles(driver);
ExternalLearningtypesobj = new ExternalLearningtypes(driver);
RequiredTrainingConsolesobj = new RequiredTrainingConsoles(driver);
SelectProfileobj = new SelectProfile(driver);
TrainingProfilesobj = new TrainingProfiles(driver);
EditTrainingProfileobj = new EditTrainingProfile(driver);
MergeUsersobj = new MergeUsers(driver);
UserGroupobj = new UserGroup(driver);
SelectCertificateobj = new SelectCertificate(driver);
ManageProficencyScaleobj = new ManageProficencyScale(driver);
ArchivedProficencyScaleobj = new ArchivedProficencyScale(driver);
MappedContentobj = new MappedContent(driver);
MappedCompetencyobj = new MappedCompetency(driver);
ManageSuccessProfileobj = new ManageSuccessProfile(driver);
FAQ_lobj = new FAQ_l(driver);
Announcements_lobj = new Announcements_l(driver);
JobTitlesobj = new JobTitles(driver);
ManageJobTitleobj = new ManageJobTitle(driver);
ManagePricingScheduleobj = new ManagePricingSchedule(driver);
ExternalLearningSearchobj = new ExternalLearningSearch(driver);
urlobj = new url(driver);
skinobj = new skin(driver);
MyOwnLearningobj = new MyOwnLearningUtils(driver);
CurrentTrainingsobj = new CurrentTrainings(driver);
scormobj = new Scorm12(driver);
aicccourse = new AICC(driver);
ojtcourse = new OJT(driver);
TrainingCatalogobj = new TrainingCatalogUtil(driver);
accesskeys = new AccessKeys(driver);
#endregion
}
public List<Faq> Todos()
{
Faqs faqs = new Faqs();
return faqs.Todos<Faq>().ToList();
}
