public IActionResult ForgetPwd(string uname, string upwd) { member mb = _context.member.SingleOrDefault(m => m.mem_username == uname.ToUpper()); if (mb != null) { var newpwd = Utils.GeneratePassword(); mb.mem_password = Utils.EncodeMd5(newpwd); _context.Update(mb); _context.SaveChanges(); var mr = _scontext.SecurityMemberRoles.SingleOrDefault(mrr => mrr.MemberId == mb.id); if (mr != null) { mr.EditedBy = mr.MemberId; mr.EditedDate = DateTime.Now; _scontext.Update(mr); _scontext.SaveChanges(); } SendEmail(mb.email, uname, newpwd); return(Json(new { result = "success" })); } else { return(Json(new { result = "fail" })); } }
public IActionResult Create([Bind("album_code,album_date,album_desc,album_name,created_by,id,rowversion,x_log,x_note,x_status")] album album) { album.album_type = "V"; //video album.x_status = "Y"; album.created_by = "Administrator"; _context.Add(album); _context.SaveChanges(); var pImages = _context.pic_image.Where(p => (p.ref_doc_code == album.album_code) && (p.x_status == "N")).ToList(); if (pImages != null) { foreach (var pImage in pImages) { pImage.x_status = "Y"; _context.Update(pImage); } _context.SaveChanges(); var uploads = Path.Combine(_env.WebRootPath, _configuration.GetSection("Paths").GetSection("images_upload").Value); uploads = Path.Combine(uploads, album.album_code); DirectoryInfo di = new DirectoryInfo(uploads); if (di.Exists) { var dest = Path.Combine(_env.WebRootPath, _configuration.GetSection("Paths").GetSection("images_album").Value); dest = Path.Combine(dest, album.album_code); Directory.Move(uploads, dest); } } return(RedirectToAction("Index")); }
public async Task <IActionResult> SettingsDisplayName(string uname) { var memberId = HttpContext.Session.GetString("memberId"); if (memberId != null) { var m = await _context.member.SingleOrDefaultAsync(mm => mm.id == new Guid(memberId)); if (m != null) { uname = uname.Trim(); m.fname = uname; _context.Update(m); await _context.SaveChangesAsync(); HttpContext.Session.SetString("displayname", uname); ViewBag.UserName = uname; return(Json(new { result = "success", uname = uname })); } else { return(Json(new { result = "fail" })); } } else { return(Json(new { result = "fail" })); } }
public async Task <IActionResult> Edit(string id, [Bind("product_code,member_code,grow_area,id,rowversion,x_log,x_note,x_status")] mem_product mem_product) { if (id != mem_product.product_code) { return(NotFound()); } if (ModelState.IsValid) { try { _context.Update(mem_product); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!mem_productExists(mem_product.product_code)) { return(NotFound()); } else { throw; } } return(RedirectToAction("Index")); } return(View(mem_product)); }
public async Task <IActionResult> Edit(string id, [Bind("district_code,province_code,country_code,area_part,dist_desc,id,rowversion,x_log,x_note,x_status")] ini_district ini_district) { if (id != ini_district.district_code) { return(NotFound()); } if (ModelState.IsValid) { try { _context.Update(ini_district); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!ini_districtExists(ini_district.district_code)) { return(NotFound()); } else { throw; } } return(RedirectToAction("Index")); } return(View(ini_district)); }
public async Task <IActionResult> Edit(string id, [Bind("cgroup_code,cgroup_desc,id,x_status")] course_group course_group) { if (course_group.id != new Guid(id)) { return(NotFound()); } if (ModelState.IsValid) { try { course_group cg = _context.course_group.SingleOrDefault(c => (c.id == new Guid(id))); cg.cgroup_code = course_group.cgroup_code.Trim(); cg.cgroup_desc = course_group.cgroup_desc.Trim(); cg.x_status = course_group.x_status; _context.Update(cg); //_context.Update(course_group); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!course_groupExists(course_group.id.ToString())) { return(NotFound()); } else { throw; } } return(RedirectToAction("Index")); } return(View(course_group)); }
public IActionResult Edit(string memberId, string productId, string mem_productId) { var m = _context.member.SingleOrDefault(mb => mb.id == new Guid(memberId)); var pd = _context.product.SingleOrDefault(pr => pr.id == new Guid(productId)); var mproCheck = _context.mem_product.Where(mpr => (mpr.member_code == m.member_code) && (mpr.product_code == pd.product_code)).Count(); if (mproCheck == 0) { mem_product mp = new mem_product(); mp.member_code = m.member_code; mp.product_code = pd.product_code; mp.x_status = "Y"; _context.Add(mp); var mpro = _context.mem_product.SingleOrDefault(mpr => (mpr.member_code == m.member_code) && (mpr.id == new Guid(mem_productId))); var recno = mpro.rec_no; _context.Remove(mpro); _context.SaveChanges(); var mpro2 = _context.mem_product.SingleOrDefault(mpr => (mpr.member_code == m.member_code) && (mpr.product_code == pd.product_code)); mpro2.rec_no = recno; _context.Update(mpro2); _context.SaveChanges(); return(Json(new { result = "success" })); } else { return(Json(new { result = "duplicate" })); } }
public async Task <IActionResult> Edit(string id, [Bind("project_code,active_member_join,budget,id,passed_member,project_approve_date,project_date,project_desc,project_manager,ref_doc,target_member_join,x_log,x_note,x_status")] project project) { if (new Guid(id) != project.id) { return(NotFound()); } if (ModelState.IsValid) { try { _context.Update(project); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!projectExists(project.project_code)) { return(NotFound()); } else { throw; } } return(RedirectToAction("Index")); } return(View(project)); }
public IActionResult Edit(string memberId, string member_code, string medical_history, string blood_group, string hobby, string restrict_food, string special_skill) { ViewBag.memberId = memberId; mem_health mem_health = _context.mem_health.SingleOrDefault(m => m.member_code == member_code); if (mem_health == null) { mem_health mh = new mem_health(); mh.member_code = member_code; mh.medical_history = medical_history; mh.blood_group = blood_group; mh.hobby = hobby; mh.restrict_food = restrict_food; mh.special_skill = special_skill; mh.x_status = "Y"; _context.Add(mh); } else { mem_health mh = mem_health; mh.member_code = member_code; mh.medical_history = medical_history; mh.blood_group = blood_group; mh.hobby = hobby; mh.restrict_food = restrict_food; mh.special_skill = special_skill; mh.x_status = "Y"; _context.Update(mh); } _context.SaveChanges(); return(Json(new { result = "success" })); }
public async Task <IActionResult> Edit(string id, [Bind("spon_code,confirm_date,contactor,contactor_detail,id,ref_doc,spon_desc,x_log,x_note,x_status")] project_sponsor project_sponsor) { if (new Guid(id) != project_sponsor.id) { return(NotFound()); } if (ModelState.IsValid) { try { _context.Update(project_sponsor); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!project_sponsorExists(project_sponsor.spon_code)) { return(NotFound()); } else { throw; } } return(RedirectToAction("Index")); } return(View(project_sponsor)); }
public async Task <IActionResult> Edit(string id, [Bind("client_code,system,module,cnfig_item,id,rowversion,text_value,x_log,x_note,x_status")] ini_config ini_config) { if (id != ini_config.client_code) { return(NotFound()); } if (ModelState.IsValid) { try { _context.Update(ini_config); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!ini_configExists(ini_config.client_code)) { return(NotFound()); } else { throw; } } return(RedirectToAction("Index")); } return(View(ini_config)); }
public async Task <IActionResult> Edit(string id, [Bind("ctype_code,cgroup_code,ctype_desc,id,rowversion,x_log,x_note,x_status")] course_type course_type) { if (course_type.id != new Guid(id)) { return(Json(new { result = "fail" })); } if (ModelState.IsValid) { try { _context.Update(course_type); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!course_typeExists(course_type.ctype_code)) { return(Json(new { result = "fail" })); } else { throw; } } return(Json(new { result = "success" })); } return(Json(new { result = "fail" })); }
public async Task <IActionResult> Edit(string id, [Bind("product_type_code,product_group_code,id,product_type_desc,rowversion,x_log,x_note,x_status")] product_type product_type) { if (id != product_type.product_type_code) { return(NotFound()); } if (ModelState.IsValid) { try { _context.Update(product_type); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!product_typeExists(product_type.product_type_code)) { return(NotFound()); } else { throw; } } return(RedirectToAction("Index")); } return(View(product_type)); }
public async Task <IActionResult> Edit(string id, [Bind("place_code,confirm_date,contactor,contactor_detail,id,place_desc,ref_doc,x_log,x_note,x_status")] train_place train_place) { if (new Guid(id) != train_place.id) { return(NotFound()); } if (ModelState.IsValid) { try { _context.Update(train_place); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!train_placeExists(train_place.place_code)) { return(NotFound()); } else { throw; } } return(RedirectToAction("Index")); } return(View(train_place)); }
public IActionResult Edit(ini_country ini_country) { if (ModelState.IsValid) { _context.Update(ini_country); _context.SaveChanges(); return(RedirectToAction("Index")); } return(View(ini_country)); }
public IActionResult Edit(string id, [Bind("member_code,birthdate,building,cid_card,cid_card_pic,cid_type,country_code,current_age,district_code,email,fax,floor,fname,h_no,id,lane,latitude,lname,longitude,lot_no,marry_status,mem_group_code,mem_photo,mem_type_code,mlevel_code,mobile,mstatus_code,nationality,parent_code,place_name,province_code,religion,room,rowversion,sex,social_app_data,street,subdistrict_code,tel,texta_address,textb_address,textc_address,village,x_log,x_note,x_status,zip_code,zone")] member member) { if (ModelState.IsValid) { member.x_status = "Y"; if ((!string.IsNullOrEmpty(member.mem_photo)) && (member.mem_photo.Substring(0, 1) != "M")) { var fileName = member.mem_photo.Substring(9); pic_image m = new pic_image(); m.image_code = "M" + DateTime.Now.ToString("yyMMddhhmmss"); m.x_status = "Y"; m.image_name = fileName.Substring(0, (fileName.Length <= 50 ? fileName.Length : 50)); m.ref_doc_type = Path.GetExtension(fileName); fileName = m.image_code + m.ref_doc_type; _context.pic_image.Add(m); _context.SaveChanges(); var s = Path.Combine(Path.Combine(_env.WebRootPath, _configuration.GetSection("Paths").GetSection("images_upload").Value), member.mem_photo); var d = Path.Combine(Path.Combine(_env.WebRootPath, _configuration.GetSection("Paths").GetSection("images_member").Value), fileName); System.IO.File.Copy(s, d, true); System.IO.File.Delete(s); clearImageUpload(); member.mem_photo = m.image_code; } if ((!string.IsNullOrEmpty(member.cid_card_pic)) && (member.cid_card_pic.Substring(0, 1) != "C")) { var fileName = member.cid_card_pic.Substring(9); pic_image pic_image = new pic_image(); pic_image.image_code = "C" + DateTime.Now.ToString("yyMMddhhmmss"); pic_image.x_status = "Y"; pic_image.image_name = fileName.Substring(0, (fileName.Length <= 50 ? fileName.Length : 50)); pic_image.ref_doc_type = Path.GetExtension(fileName); fileName = pic_image.image_code + pic_image.ref_doc_type; _context.pic_image.Add(pic_image); _context.SaveChanges(); var s = Path.Combine(Path.Combine(_env.WebRootPath, _configuration.GetSection("Paths").GetSection("images_upload").Value), member.cid_card_pic); var d = Path.Combine(Path.Combine(_env.WebRootPath, _configuration.GetSection("Paths").GetSection("images_member").Value), fileName); System.IO.File.Copy(s, d, true); System.IO.File.Delete(s); clearImageUpload(); member.cid_card_pic = pic_image.image_code; } _context.Update(member); _context.SaveChanges(); return(RedirectToAction("Index")); } prepareViewBag(); return(View(member)); }
public IActionResult Edit(member member) { if (ModelState.IsValid) { member.x_status = "Y"; if ((!string.IsNullOrEmpty(member.mem_photo)) && (member.mem_photo.Substring(0, 1) != "M")) { var fileName = member.mem_photo.Substring(9); pic_image m = new pic_image(); m.image_code = "M" + DateTime.Now.ToString("yyMMddhhmmss"); m.x_status = "Y"; m.image_name = fileName.Substring(0, (fileName.Length <= 50 ? fileName.Length : 50)); m.ref_doc_type = Path.GetExtension(fileName); fileName = m.image_code + m.ref_doc_type; _context.pic_image.Add(m); _context.SaveChanges(); var s = Path.Combine(Path.Combine(_env.WebRootPath, _configuration.GetSection("Paths").GetSection("images_upload").Value), member.mem_photo); var d = Path.Combine(Path.Combine(_env.WebRootPath, _configuration.GetSection("Paths").GetSection("images_member").Value), fileName); System.IO.File.Copy(s, d, true); System.IO.File.Delete(s); clearImageUpload(); member.mem_photo = m.image_code; } if ((!string.IsNullOrEmpty(member.cid_card_pic)) && (member.cid_card_pic.Substring(0, 1) != "C")) { var fileName = member.cid_card_pic.Substring(9); pic_image pic_image = new pic_image(); pic_image.image_code = "C" + DateTime.Now.ToString("yyMMddhhmmss"); pic_image.x_status = "Y"; pic_image.image_name = fileName.Substring(0, (fileName.Length <= 50 ? fileName.Length : 50)); pic_image.ref_doc_type = Path.GetExtension(fileName); fileName = pic_image.image_code + pic_image.ref_doc_type; _context.pic_image.Add(pic_image); _context.SaveChanges(); var s = Path.Combine(Path.Combine(_env.WebRootPath, _configuration.GetSection("Paths").GetSection("images_upload").Value), member.cid_card_pic); var d = Path.Combine(Path.Combine(_env.WebRootPath, _configuration.GetSection("Paths").GetSection("images_member").Value), fileName); System.IO.File.Copy(s, d, true); System.IO.File.Delete(s); clearImageUpload(); member.cid_card_pic = pic_image.image_code; } _context.Update(member); _context.SaveChanges(); return(RedirectToAction("Index")); } prepareViewBag(); return(View(member)); }
public async Task <IActionResult> Edit(string id, [Bind("id,mem_testcenter_code,mem_testcenter_desc,rowversion,x_status,CreatedBy,CreatedDate")] mem_testcenter mem_testcenter) { if (ModelState.IsValid) { mem_testcenter.mem_testcenter_desc = mem_testcenter.mem_testcenter_desc.Trim(); mem_testcenter.x_status = mem_testcenter.x_status.Trim(); _context.Update(mem_testcenter); await _context.SaveChangesAsync(); } return(Json(new { result = "success" })); }
public IActionResult Edit(string memberId, string id, int rec_no, string reward_desc) { var member = _context.member.Single(m => m.id == new Guid(memberId)); var mem_reward = _context.mem_reward.Single(m => m.id == new Guid(id)); mem_reward.reward_desc = reward_desc; _context.Update(mem_reward); _context.SaveChanges(); return(Json(new { result = "success" })); }
public IActionResult Edit(string memberId, string id, int rec_no, string site_visit_desc, int country_code) { var member = _context.member.Single(m => m.id == new Guid(memberId)); var mem_site_visit = _context.mem_site_visit.Single(m => m.id == new Guid(id)); mem_site_visit.country_code = country_code; mem_site_visit.site_visit_desc = site_visit_desc; _context.Update(mem_site_visit); _context.SaveChanges(); return(Json(new { result = "success" })); }
public IActionResult Edit(string memberId, string id, int rec_no, string colledge_name, string degree, string faculty) { var member = _context.member.Single(m => m.id == new Guid(memberId)); var mem_education = _context.mem_education.Single(m => m.id == new Guid(id)); mem_education.colledge_name = colledge_name; mem_education.degree = degree; mem_education.faculty = faculty; _context.Update(mem_education); _context.SaveChanges(); return(Json(new { result = "success" })); }
public async Task <IActionResult> Create(string courseId, string projectCode) { var c = _context.project_course.SingleOrDefault(m => m.id == new Guid(courseId)); //project_course pc = new project_course(); //pc.project_code = projectCode; //pc.active_member_join = c.active_member_join; //pc.budget = c.budget; //pc.cgroup_code = c.cgroup_code; //pc.charge_head = c.charge_head; //pc.course_approve_date = c.course_approve_date; //pc.course_begin = c.course_begin; //pc.course_code = c.course_code; //pc.course_date = c.course_date; //pc.course_desc = c.course_desc; //pc.course_end = c.course_end; //pc.ctype_code = c.ctype_code; //pc.passed_member = c.passed_member; //pc.project_manager = c.project_manager; //pc.ref_doc = c.ref_doc; //pc.support_head = c.support_head; //pc.target_member_join = c.target_member_join; //pc.x_status = c.x_status; c.project_code = projectCode; try { //_context.Add(pc); _context.Update(c); await _context.SaveChangesAsync(); } catch (Exception) { return(Json(new { result = "fail" })); } return(Json(new { result = "success" })); }
public async Task <IActionResult> Edit(string id, [Bind("product_type_code,product_group_code,id,product_type_desc,rowversion,x_log,x_note,x_status")] product_type product_type) { if (ModelState.IsValid) { try { _context.Update(product_type); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { return(Json(new { result = "fail" })); } return(Json(new { result = "success" })); } return(Json(new { result = "fail" })); }
public IActionResult Edit(string memberId, string id, string course_code, string course_desc, string course_grade) { var member = _context.member.Single(m => m.id == new Guid(memberId)); var mem_train_record = _context.mem_train_record.Single(m => m.id == new Guid(id)); mem_train_record.course_code = course_code; mem_train_record.course_grade = course_grade; _context.Update(mem_train_record); //Temp create project, this need to review business logic var project_course = _context.project_course.Single(p => p.course_code == mem_train_record.course_code); project_course.course_desc = course_desc; _context.project_course.Update(project_course); _context.SaveChanges(); return(Json(new { result = "success" })); }
public async Task <IActionResult> Edit(string id, [Bind("album_code,album_desc,album_name,created_by,album_date,id,rowversion,x_log,x_note,x_status")] album album) { try { _context.Update(album); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!albumExists(album.album_code)) { return(NotFound()); } else { throw; } } return(RedirectToAction("Index")); }
public IActionResult Edit(string memberId, string id, int rec_no, string company_name_th, string company_name_eng, string position_name_th, string position_name_eng, string work_year, string office_address) { var member = _context.member.Single(m => m.id == new Guid(memberId)); var mem_worklist = _context.mem_worklist.Single(m => m.id == new Guid(id)); mem_worklist.member_code = member.member_code; mem_worklist.rec_no = rec_no; mem_worklist.company_name_th = company_name_th; mem_worklist.company_name_eng = company_name_eng; mem_worklist.position_name_th = position_name_th; mem_worklist.position_name_eng = position_name_eng; mem_worklist.work_year = work_year; mem_worklist.office_address = office_address; mem_worklist.x_status = "Y"; _context.Update(mem_worklist); _context.SaveChanges(); return(Json(new { result = "success" })); }
public async Task <IActionResult> Edit(string id, [Bind("spon_code,project_code,contactor,contactor_detail,id,ref_doc,support_budget,x_log,x_note,x_status")] project_supporter project_supporter) { if (id != project_supporter.spon_code) { return(NotFound()); } if (ModelState.IsValid) { try { _context.Update(project_supporter); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { return(NotFound()); } return(RedirectToAction("Index")); } return(View(project_supporter)); }