public ActionResult Modify(Student Stdnt) { try { string _connectionString = ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString as string; using (IDbConnection db = new SqlConnection(_connectionString)) { CustomerPageVM pageVM = new CustomerPageVM(); var query = "ModifyById"; var param = new DynamicParameters(); param.Add("id", Stdnt.Id); param.Add("firstName", Stdnt.FirstName); param.Add("midName", Stdnt.MidName); param.Add("lastName", Stdnt.LastName); param.Add("genderId", Stdnt.GenderId); param.Add("email", Stdnt.Email); param.Add("address", Stdnt.Address); param.Add("quillContent", Stdnt.QuillContent); param.Add("bloodId", Stdnt.BloodId); db.Query <Student>(query, param, commandType: CommandType.StoredProcedure); query = "GetStudentById"; var param1 = new DynamicParameters(); param1.Add("Id", Stdnt.Id); var list = db.Query <Student>(query, param1, commandType: CommandType.StoredProcedure).First(); return(Redirect("/CmsAdmin/AdminCms/")); //return View(list); } } catch (Exception ex) { return(View(ex.Message)); } }
// GET: Admin/Customers public async Task <IActionResult> Index(string keyword, int?page) { CustomerPageVM vm = new CustomerPageVM() { PageIndex = page == null || page <= 0 ? 1 : page.Value, Keyword = keyword }; var pageSize = 10; var query = _context.Customers.AsNoTracking().AsQueryable(); if (!string.IsNullOrEmpty(keyword)) { query = query.Where(d => d.Mobile.Contains(keyword)); } vm.TotalCount = await query.CountAsync(); var list = await query.Skip((vm.PageIndex - 1) *pageSize).Take(pageSize).ProjectTo <CustomerVM>(_mapper.ConfigurationProvider).ToListAsync(); // var list = _mapper.Map<IEnumerable<CustomerVM>>(agents); vm.Customers = new StaticPagedList <CustomerVM>(list, vm.PageIndex, pageSize, vm.TotalCount); return(View(vm)); }
public ActionResult create(Student Instd) { try { string _connectionString = ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString as string; using (IDbConnection db = new SqlConnection(_connectionString)) { CustomerPageVM pageVM = new CustomerPageVM(); var query = "InsertStudent"; var param = new DynamicParameters(); param.Add("id", Instd.Id); param.Add("firstName", Instd.FirstName); param.Add("midName", Instd.MidName); param.Add("lastName", Instd.LastName); param.Add("genderId", Instd.GenderId); param.Add("email", Instd.Email); param.Add("address", Instd.Address); param.Add("quillContent", Instd.QuillContent); param.Add("bloodId", Instd.BloodId); db.Query <Student>(query, param, commandType: CommandType.StoredProcedure); return(Redirect("/CmsAdmin/AdminCms/")); } } catch (Exception ex) { return(View(ex.Message)); } }
public ActionResult VueIndex() { try { string _connectionString = ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString as string; using (IDbConnection db = new SqlConnection(_connectionString)) { CustomerPageVM pageVM = new CustomerPageVM(); var query = "GetAllStudent"; pageVM.OurCustomers = db.Query <Student>(query, commandType: CommandType.StoredProcedure); return(new ViewAsPdf(pageVM)); } } catch (Exception ex) { return(Content(ex.Message)); } }
public CustomerPageUI() { InitializeComponent(); BindingContext = new CustomerPageVM(Navigation); client = new FireSharp.FirebaseClient(config.config); CMND.Text = UserData.shared.IDCard; CMND_ = CMND.Text; dantoc.Text = _dantoc; tongiao.Text = _tongiao; addpickerhocvan(); addgioitinh(); addloaixe(); getkhachthue(); this.handleEvent(); }
public ActionResult details(int id) { try { string _connectionString = ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString as string; using (IDbConnection db = new SqlConnection(_connectionString)) { CustomerPageVM pageVM = new CustomerPageVM(); var query = "GetStudentById"; var param = new DynamicParameters(); param.Add("id", id); var list = db.Query <Student>(query, param, commandType: CommandType.StoredProcedure).First(); return(View(list)); } } catch (Exception ex) { return(View(ex.Message)); } }
public ActionResult delete(int id) { try { string _connectionString = ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString as string; using (IDbConnection db = new SqlConnection(_connectionString)) { CustomerPageVM pageVM = new CustomerPageVM(); var query = "DeleteStudentWithId"; var param = new DynamicParameters(); param.Add("id", id); db.Query <Student>(query, param, commandType: CommandType.StoredProcedure); return(Redirect("/CmsAdmin/AdminCms/")); } } catch (Exception ex) { return(View(ex.Message)); } }
// GET: CmsAdmin/AdminCms public ActionResult Index() { try { string _connectionString = ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString as string; using (IDbConnection db = new SqlConnection(_connectionString)) { CustomerPageVM pageVM = new CustomerPageVM(); var query = "GetAllStudent"; pageVM.OurCustomers = db.Query <Student>(query, commandType: CommandType.StoredProcedure); HttpCookie cookie = new HttpCookie("TestCookie"); cookie.Value = "This is test cookie"; this.ControllerContext.HttpContext.Response.Cookies.Add(cookie); return(View(pageVM)); } } catch (Exception ex) { return(Content(ex.Message)); } }
public async Task OnGet(string searchString, int pageIndex = 1) { ListCustomerPage = await _serviceVM.GetCustomerPageViewModelAsync(SearchString, pageIndex); }
protected override void OnAppearing() { base.OnAppearing(); var vm = BindingContext as CustomerPageVM; if (vm.Items.Count <= 0) { BindingContext = new CustomerPageVM(Navigation); } SiteCurentLabelNavigatePage.Text = this._customerInforPlaceholder_CurentSite; HometownLabelNavigatePage.Text = this._customerInforPlaceholder_Hometown; PlaceJobLabelNavigatePage.Text = this._customerInforPlaceholder_JobSite; AddressResidentLabelNavigatePage.Text = this._customerInforPlaceholder_Resident; if (Application.Current.Properties.ContainsKey(KeyCustomerViewEnumeration.CustomerInforCurrentSite)) { SiteCurentLabelNavigatePage.Text = Application.Current.Properties[KeyCustomerViewEnumeration.CustomerInforCurrentSite].ToString(); } if (Application.Current.Properties.ContainsKey(KeyCustomerViewEnumeration.CustomerInforHometown)) { HometownLabelNavigatePage.Text = Application.Current.Properties[KeyCustomerViewEnumeration.CustomerInforHometown].ToString(); } if (Application.Current.Properties.ContainsKey(KeyCustomerViewEnumeration.CustomerInforJobSite)) { PlaceJobLabelNavigatePage.Text = Application.Current.Properties[KeyCustomerViewEnumeration.CustomerInforJobSite].ToString(); } if (Application.Current.Properties.ContainsKey(KeyCustomerViewEnumeration.CustomerInforResidentSite)) { AddressResidentLabelNavigatePage.Text = Application.Current.Properties[KeyCustomerViewEnumeration.CustomerInforResidentSite].ToString(); } if (Application.Current.Properties.ContainsKey(KeyCustomerViewEnumeration.CustomerInforName)) { TENKH.Text = Application.Current.Properties[KeyCustomerViewEnumeration.CustomerInforName] == null ? "" : Application.Current.Properties[KeyCustomerViewEnumeration.CustomerInforName].ToString(); } if (Application.Current.Properties.ContainsKey(KeyCustomerViewEnumeration.CustomerInforCMNDCreateDate)) { ngaycap.Date = Convert.ToDateTime(Application.Current.Properties[KeyCustomerViewEnumeration.CustomerInforCMNDCreateDate]); } if (Application.Current.Properties.ContainsKey(KeyCustomerViewEnumeration.CustomerInforBirthday)) { ngaysinh.Date = Convert.ToDateTime(Application.Current.Properties[KeyCustomerViewEnumeration.CustomerInforBirthday]); } if (Application.Current.Properties.ContainsKey(KeyCustomerViewEnumeration.CustomerInforSex)) { //gioitinh_.SelectedItem = Application.Current.Properties[KeyCustomerViewEnumeration.CustomerInforSex]; } if (Application.Current.Properties.ContainsKey(KeyCustomerViewEnumeration.CustomerInforPhone)) { dienthoai.Text = Application.Current.Properties[KeyCustomerViewEnumeration.CustomerInforPhone] == null ? "" : Application.Current.Properties[KeyCustomerViewEnumeration.CustomerInforPhone].ToString(); } if (Application.Current.Properties.ContainsKey(KeyCustomerViewEnumeration.CustomerInforDanToc)) { dantoc.Text = Application.Current.Properties[KeyCustomerViewEnumeration.CustomerInforDanToc] == null ? "" : Application.Current.Properties[KeyCustomerViewEnumeration.CustomerInforDanToc].ToString(); } if (Application.Current.Properties.ContainsKey(KeyCustomerViewEnumeration.CustomerInforTonGiao)) { tongiao.Text = Application.Current.Properties[KeyCustomerViewEnumeration.CustomerInforTonGiao] == null ? "" : Application.Current.Properties[KeyCustomerViewEnumeration.CustomerInforTonGiao].ToString(); } if (Application.Current.Properties.ContainsKey(KeyCustomerViewEnumeration.CustomerInforJob)) { nghenghiep.Text = Application.Current.Properties[KeyCustomerViewEnumeration.CustomerInforJob] == null ? "" : Application.Current.Properties[KeyCustomerViewEnumeration.CustomerInforJob].ToString(); } if (Application.Current.Properties.ContainsKey(KeyCustomerViewEnumeration.CustomerInforCompany)) { Congty.Text = Application.Current.Properties[KeyCustomerViewEnumeration.CustomerInforCompany] == null ? "" : Application.Current.Properties[KeyCustomerViewEnumeration.CustomerInforCompany].ToString(); } if (Application.Current.Properties.ContainsKey(KeyCustomerViewEnumeration.CustomerInforEmail)) { mail.Text = Application.Current.Properties[KeyCustomerViewEnumeration.CustomerInforEmail] == null ? "" : Application.Current.Properties[KeyCustomerViewEnumeration.CustomerInforEmail].ToString(); } if (Application.Current.Properties.ContainsKey(KeyCustomerViewEnumeration.CustomerInforCartMoto)) { bienso.Text = Application.Current.Properties[KeyCustomerViewEnumeration.CustomerInforCartMoto] == null ? "" : Application.Current.Properties[KeyCustomerViewEnumeration.CustomerInforCartMoto].ToString(); } if (Application.Current.Properties.ContainsKey(KeyCustomerViewEnumeration.CustomerInforTypeMoto)) { //bienso.Text = Application.Current.Properties[KeyCustomerViewEnumeration.CustomerInforCartMoto].ToString(); } if (Application.Current.Properties.ContainsKey(KeyCustomerViewEnumeration.CustomerInforEdu)) { //bienso.Text = Application.Current.Properties[KeyCustomerViewEnumeration.CustomerInforEdu].ToString(); } if (Application.Current.Properties.ContainsKey(KeyCustomerViewEnumeration.CustomerInforProfection)) { Chuyenmon.Text = Application.Current.Properties[KeyCustomerViewEnumeration.CustomerInforProfection] == null ? "" : Application.Current.Properties[KeyCustomerViewEnumeration.CustomerInforProfection].ToString(); } }