public ActionResult Addcountry(AddCountrymodel add) { using (projectEntities1 db = new projectEntities1()) { if (Session["Id"] != null) { int id = Convert.ToInt32(Session["Id"].ToString()); MembersData usr = db.MembersDatas.Where(u => u.Id == id).FirstOrDefault(); { admin a = db.admins.Where(u => u.CreatedBy == id).FirstOrDefault(); { Country c = new Country(); c.Country1 = add.country; c.Description = add.dis; c.Date = DateTime.Now; c.AdminId = a.Id; c.IsActive = true; db.Countries.Add(c); db.SaveChanges(); } } return(View()); } } return(View()); }
public void getMembersByID(int id) { string responce = ""; ResponseData rsData = new ResponseData(); List <MembersData> clist = new List <MembersData>(); try { MembersData cdata = new MembersData(); DataSet ds = cdata.getMembers("select * from members where id=" + id); for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { int cid = int.Parse(ds.Tables[0].Rows[i][0].ToString()); MembersData mddata = new MembersData(cid); clist.Add(mddata); } } catch (Exception ex) { } rsData.Message = "successmembers"; rsData.Description = "successfully"; rsData.Data = clist; JavaScriptSerializer js = new JavaScriptSerializer(); responce = js.Serialize(rsData); Context.Response.Clear(); Context.Response.ContentType = "application/json"; Context.Response.AddHeader("content-length", responce.Length.ToString()); Context.Response.Flush(); Context.Response.Write(responce); }
public ActionResult ChangePass(ChangePassModel cpm) { if (Session["Id"] != null) { int id = Convert.ToInt32(Session["Id"].ToString()); using (projectEntities1 db = new projectEntities1()) { MembersData usr = db.MembersDatas.Where(u => u.Id == id).FirstOrDefault(); { if (cpm.OldPassword == usr.Password) { usr.CPassword = cpm.CPassword; usr.Password = cpm.CPassword; db.SaveChanges(); TempData["Success"] = "Password Successfully Changed!"; return(RedirectToAction("Login", "Auth")); } else { TempData["Success"] = "OldPassword miss match"; return(RedirectToAction("Registration", "Auth")); } } } } else { return(RedirectToAction("Forgot", "Auth")); } }
public ActionResult Login(MembersData ml) { using (projectEntities1 db = new projectEntities1()) { MembersData usr = db.MembersDatas.Where(u => u.EmailId == ml.EmailId && u.Password == ml.Password).FirstOrDefault(); if (usr != null) { Session["Id"] = usr.Id; TempData["Success"] = "Loggin Successfully!"; if (usr.ModifiedBy == 1) { return(RedirectToAction("Dashboard", "Admin")); } else { return(RedirectToAction("SearchNotes", "NoteDetails")); } } else { TempData["Success"] = "EmailId or Password is wrong"; ModelState.AddModelError("", "EmailId or Password is wrong"); return(RedirectToAction("Login", "Auth")); } } }
public ActionResult DashBoard(string searchn) { projectEntities1 db = new projectEntities1(); if (Session["Id"] != null) { int id = Convert.ToInt32(Session["Id"].ToString()); MembersData usr = db.MembersDatas.Where(u => u.Id == id).FirstOrDefault(); { List <NoteDetail> notes = db.NoteDetails.Where(u => u.OwnerId == id).ToList(); { //List<NoteDetail> notes = db.NoteDetails.ToList(); if (!string.IsNullOrEmpty(searchn)) { notes = notes.Where(e => e.NoteTitle.ToLower().Contains(searchn.ToLower())).ToList(); return(View(notes)); } return(View(notes)); } } } return(View()); }
public ActionResult Create(MemberModel membr) { MembersData MemRepo = new MembersData(); //if (ModelState.IsValid) //{ ResponseModel isSave = MemRepo.SaveMember(membr); if (isSave.status == 1) { Connection.CommitTransaction(); Connection.CloseConnection(); return(Json(new { status = true, code = 2, msg = "Successfuly Created." }, JsonRequestBehavior.AllowGet)); } else { Connection.RollbackTransaction(); Connection.CloseConnection(); return(Json(new { status = false, code = 0, msg = "Something went wrong." }, JsonRequestBehavior.AllowGet)); } //} MemberModel mem = new MemberModel(); mem.ListyearOfMembership = GetYearofMembership(); mem.StatusList = MemRepo.GetStatusList(); //MemRepo.GetStatusList_1(); mem.PositionList = MemRepo.GetPositionList(); mem.CLPList = GetCLPNumList(); mem.ChapList = MemRepo.GetChapterList(); mem.AccessTypeList = MemRepo.GetAcccessTypeList(); mem.SponsorList = MemRepo.GetSponsorList(); return(Json(new { status = false, code = 0, msg = "Something went wrong." }, JsonRequestBehavior.AllowGet)); //return RedirectToAction("Index"); }
public ActionResult DeleteConfirmed(string id) { MembersData membersData = db.MembersData.Find(id); db.MembersData.Remove(membersData); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Edit([Bind(Include = "UserID,UserPassWord,UserName,Phone,Address")] MembersData membersData) { if (ModelState.IsValid) { db.Entry(membersData).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(membersData)); }
public ActionResult ConfirmEmail(string Email) { using (projectEntities1 db = new projectEntities1()) { MembersData usr = db.MembersDatas.Where(u => u.EmailId == Email).FirstOrDefault(); usr.IsEmailVerified = true; usr.CPassword = "******"; db.SaveChanges(); return(View(usr)); } }
public ActionResult Create([Bind(Include = "UserID,UserPassWord,UserName,Phone,Address")] MembersData membersData) { if (ModelState.IsValid) { db.MembersData.Add(membersData); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(membersData)); }
public void saveMembers(string name, string mobile) { try { MembersData mdata = new MembersData(); mdata.Name = name; mdata.Mobile = mobile; mdata.Save(); } catch (Exception ex) { } }
public ActionResult EditNotes(string noteid, AddNotesModel notesModel, HttpPostedFileBase dp, HttpPostedFileBase uploadnote, HttpPostedFileBase notepreview) { if (Session["Id"] != null) { int id = Convert.ToInt32(Session["Id"].ToString()); using (projectEntities1 db = new projectEntities1()) { MembersData usr = db.MembersDatas.Where(u => u.Id == id).FirstOrDefault(); { NoteDetail notes = db.NoteDetails.Where(u => u.NoteTitle == noteid).FirstOrDefault(); { notes.Status = "Inreview"; string fileName = Path.GetFileName(dp.FileName); notesModel.dppath = "~/images/" + fileName; fileName = Path.Combine(Server.MapPath("~/images/"), fileName); dp.SaveAs(fileName); string fileName1 = Path.GetFileName(uploadnote.FileName); notesModel.uploadpath = "~/images/" + fileName1; fileName = Path.Combine(Server.MapPath("~/images/"), fileName1); uploadnote.SaveAs(fileName); string fileName2 = Path.GetFileName(notepreview.FileName); notesModel.notepath = "~/images/" + fileName2; fileName = Path.Combine(Server.MapPath("~/images/"), fileName2); notepreview.SaveAs(fileName); notes.ApprovedDate = DateTime.Now; notes.DisplayPic = notesModel.dppath; notes.Preview = notesModel.notepath; notes.note = notesModel.uploadpath; db.SaveChanges(); return(RedirectToAction("SearchNotes", "NoteDetails")); } } } } else { return(View()); } }
public ActionResult Create() { MembersData MemRepo = new MembersData(); MemberModel mem = new MemberModel(); mem.ListyearOfMembership = GetYearofMembership(); mem.StatusList = MemRepo.GetStatusList(); mem.PositionList = MemRepo.GetPositionList(); mem.CLPList = GetCLPNumList(); mem.ChapList = MemRepo.GetChapterList(); mem.AccessTypeList = MemRepo.GetAcccessTypeList(); mem.SponsorList = MemRepo.GetSponsorList(); return(View(mem)); }
// GET: MembersDatas/Delete/5 public ActionResult Delete(string id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } MembersData membersData = db.MembersData.Find(id); if (membersData == null) { return(HttpNotFound()); } return(View(membersData)); }
public ActionResult MemberList() { List <MemberModel> model = MembersData.MemberList(0); if (model.Count() == 0) { return(Json(new { status = false, msg = "No data found!" }, JsonRequestBehavior.AllowGet)); } else { //get supplier name } return(Json(new { status = true, msg = "Success", data = RenderPartialViewToString("_MemberListPartial", model) }, JsonRequestBehavior.AllowGet)); }
//ContactUs public ActionResult UserProfile(UserProfileModal userProfile) { int id = Convert.ToInt32(Session["Id"].ToString()); using (projectEntities1 db = new projectEntities1()) { MembersData usr = db.MembersDatas.Where(u => u.Id == id).FirstOrDefault(); { userProfile.FirstName = usr.FirstName; userProfile.LastName = usr.LastName; userProfile.EmailId = usr.EmailId; return(View(userProfile)); } } }
private void displayDetailLabel(TaskEntryData ted) { SqlHandling sh = new SqlHandling("M_Members"); string[] mCodeArray = new string[2]; string[] mNameArray = new string[2]; mCodeArray[0] = ted.LeaderMCode; mCodeArray[1] = ted.SalesMCode; MembersData md = new MembersData(); for (int i = 0; i < mCodeArray.Length; i++) { if (!String.IsNullOrEmpty(mCodeArray[i])) { mNameArray[i] = md.SelectMemberName(mCodeArray[i]); } } clearDetailLabel(); // 業務担当者 if (!String.IsNullOrEmpty(mNameArray[0])) { labelTtlLeader.Visible = true; labelLeaderName.Text = mNameArray[0]; } // 営業担当者 if (!String.IsNullOrEmpty(mNameArray[1])) { labelTtlSales.Visible = true; labelSalesMName.Text = mNameArray[1]; } // 契約日 if (DHandling.CheckDateMiniValue(ted.ContractDate)) { labelContractDate.Text = "契約日: " + DHandling.PickUpTopCharacters(Convert.ToString(ted.ContractDate), 10); } // 工期 開始日 if (DHandling.CheckDateMiniValue(ted.StartDate)) { labelStartDate.Text = "工期: " + DHandling.PickUpTopCharacters(Convert.ToString(ted.StartDate), 10); } // 工期 終了日 if (DHandling.CheckDateMiniValue(ted.EndDate)) { labelStartDate.Text += " ~ " + DHandling.PickUpTopCharacters(Convert.ToString(ted.EndDate), 10); } }
public ActionResult Forgot(MembersData ml) { using (projectEntities1 db = new projectEntities1()) { MembersData usr = db.MembersDatas.Where(u => u.EmailId == ml.EmailId).FirstOrDefault(); if (usr != null) { usr.CPassword = "******"; usr.Password = "******"; var fromemail = new MailAddress("*****@*****.**"); var toemail = new MailAddress(ml.EmailId); MailMessage mm = new MailMessage("*****@*****.**", ml.EmailId); mm.Subject = "New temporory password has been genrated for you"; mm.IsBodyHtml = true; mm.Body = "<div>Hello,</div> <div>We have genrated a new password for you .</div> <div>Password :Note@123<div>------</div><div> Regards,<div> NoteMarketplace</div>"; SmtpClient smtp = new SmtpClient(); smtp.Host = "smtp.gmail.com"; smtp.Port = 587; smtp.EnableSsl = true; smtp.DeliveryMethod = SmtpDeliveryMethod.Network; smtp.UseDefaultCredentials = false; smtp.Credentials = new NetworkCredential(fromemail.Address, "Note@tatva"); smtp.Send(mm); db.SaveChanges(); TempData["Success"] = "Email sent Successfully Done!"; return(RedirectToAction("ChangePass", "Auth")); } else { TempData["Success"] = "EmailId is wrong"; ModelState.AddModelError("", "EmailId is wrong"); return(RedirectToAction("Forgot", "Auth")); } } }
public ActionResult DeleteNotes(int noteid) { if (Session["Id"] != null) { int id = Convert.ToInt32(Session["Id"].ToString()); using (projectEntities1 db = new projectEntities1()) { MembersData usr = db.MembersDatas.Where(u => u.Id == id).FirstOrDefault(); { NoteDetail nd = db.NoteDetails.Where(u => u.Id == noteid).FirstOrDefault(); { db.NoteDetails.Remove(nd); return(View()); } } } } return(View()); }
private void edit_Labels() { labelTaskCode.Text = ted.TaskCode; labelTask.Text = ted.TaskName; PartnersData pd = new PartnersData(); labelPartner.Text = pd.SelectPartnerName(ted.PartnerCode); MembersData md = new MembersData(); labelSalesM.Text = md.SelectMemberName(ted.SalesMCode); labelLeader.Text = md.SelectMemberName(ted.LeaderMCode); recordedDate = DHandling.EndOfMonth(dateTimePickerRecDate.Value); labelOrderNo.Text = ""; labelSubCo.Text = ""; textBoxSubCo.Text = ""; }
public ActionResult Edit(int id) { MembersData MemRepo = new MembersData(); MemberModel mem = MembersData.MemberDetails(id); if (mem != null) { mem.ListyearOfMembership = GetYearofMembership(); mem.StatusList = MemRepo.GetStatusList(); mem.PositionList = MemRepo.GetPositionList(); mem.CLPList = GetCLPNumList(); mem.ChapList = MemRepo.GetChapterList(); mem.AccessTypeList = MemRepo.GetAcccessTypeList(); mem.SponsorList = MemRepo.GetSponsorList(); } return(View(mem)); //return Json(new { status = true, msg = "Success", data = mem }, JsonRequestBehavior.AllowGet); }
public void saveMembersExt(string name, string mobile, string app_id) { try { MembersData mdata = new MembersData(mobile); if (mdata.HasValue) { } else { mdata.App_id = 10; mdata.Name = name; mdata.Mobile = mobile; mdata.Save(); } } catch (Exception ex) { } }
private void edit_Labels() { labelTaskCode.Text = (ted.TaskCode == "") ? "" : ted.TaskCode; labelTask.Text = ted.TaskName; if (ted.PartnerName == "") { PartnersData pd = new PartnersData(); labelOPartner.Text = pd.SelectPartnerName(ted.PartnerCode); } else { labelOPartner.Text = ted.PartnerName; } MembersData md = new MembersData(); labelSalesM.Text = md.SelectMemberName(ted.SalesMCode); labelLeader.Text = md.SelectMemberName(ted.LeaderMCode); labelPartner.Text = ""; labelOrderNo.Text = ""; }
private bool displayTaskData(DataGridView dgv, string officeCode, string department) { dgv.Rows.Clear(); TaskIndData tid = new TaskIndData(); tida = tid.SelectTaskIndData(officeCode, department); if (tida == null) { return(false); } int addRCnt = (tida.GetLength(0) > iniRCnt) ? tida.GetLength(0) - 1 : iniRCnt; dgv.Rows.Add(addRCnt); MembersData md = new MembersData(); TaskData td = new TaskData(); PartnersData pd = new PartnersData(); //for( int i = 0; i < tida.GetLength( 0 ); i++ ) for (int i = 0; i < tida.Length; i++) { dgv.Rows[i].Cells["TaskCode"].Value = tida[i].TaskCode; dgv.Rows[i].Cells["TaskName"].Value = tida[i].TaskName; dgv.Rows[i].Cells["Cost"].Value = decFormat(tida[i].Contract); dgv.Rows[i].Cells["LeaderM"].Value = md.SelectMemberName(tida[i].LeaderMCode); td = td.SelectTaskData(tida[i].TaskID); // Wakamatsu 20170315 //if (td == null) return false; if (td != null) { dgv.Rows[i].Cells["DateFR"].Value = td.StartDate.ToString("yyyy/MM/dd"); dgv.Rows[i].Cells["DateTO"].Value = td.EndDate.ToString("yyyy/MM/dd"); dgv.Rows[i].Cells["IssueDate"].Value = td.IssueDate.ToString("yyyy/MM/dd"); dgv.Rows[i].Cells["SalesM"].Value = md.SelectMemberName(td.SalesMCode); dgv.Rows[i].Cells["Customer"].Value = pd.SelectPartnerName(td.PartnerCode); } } // Wakamatsu 20170315 this.dataGridView1.CurrentCell = null; return(true); }
public ActionResult EditNotes(int noteid, AddNotesModel notesModel) { if (Session["Id"] != null) { int id = Convert.ToInt32(Session["Id"].ToString()); using (projectEntities1 db = new projectEntities1()) { MembersData usr = db.MembersDatas.Where(u => u.Id == id).FirstOrDefault(); { NoteDetail nd = db.NoteDetails.Where(u => u.Id == noteid).FirstOrDefault(); { ViewData["Category"] = db.Categories.ToList <Category>(); ViewData["Type"] = db.Types.ToList(); ViewData["Country"] = db.Countries.ToList(); notesModel.country = nd.Country; notesModel.category = nd.Category; notesModel.coursecode = nd.CourseCode; notesModel.coursename = nd.Course; notesModel.Disc = nd.Description; notesModel.instituename = nd.University; notesModel.Noofpage = nd.NoOfPages; notesModel.price = nd.SellPrice; notesModel.professor = nd.Professor; notesModel.Title = nd.NoteTitle; notesModel.type = nd.Type; return(View(notesModel)); } } } } else { return(View()); } }
//private void displayMembersData( DataGridView dgv, string officeCode, string department ) private bool displayMembersData(DataGridView dgv, string officeCode, string department) { labelMessage.Text = ""; dataGridView1.Rows.Clear(); MembersData mdp = new MembersData(); DataTable dt = mdp.SelectWorkReportMembersData(officeCode, department); //if( dt == null || dt.Rows.Count < 1 ) return; if (dt == null || dt.Rows.Count < 1) { labelMessage.Text = "表示できるデータがありません。"; return(false); } //dataGridView1.Rows.Clear(); if (dt.Rows.Count > 1) { dataGridView1.Rows.Add(dt.Rows.Count - 1); } DataRow dr; for (int i = 0; i < dt.Rows.Count; i++) { dr = dt.Rows[i]; dgv.Rows[i].Cells["MemberCode"].Value = Convert.ToString(dr["MemberCode"]); string wkMCode = Convert.ToString(dr["MemberCode"]); string wkMName = Convert.ToString(dr["Name"]); if (string.IsNullOrEmpty(wkMCode)) { MessageBox.Show(wkMName); } dgv.Rows[i].Cells["MemberName"].Value = Convert.ToString(dr["Name"]); } return(true); }
public ActionResult UserProfile(UserProfileModal userProfile, HttpPostedFileBase dp) { if (Session["Id"] != null) { int id = Convert.ToInt32(Session["Id"].ToString()); using (projectEntities1 db = new projectEntities1()) { MembersData usr = db.MembersDatas.Where(u => u.Id == id).FirstOrDefault(); { string fileName = Path.GetFileName(dp.FileName); userProfile.uploaddp = "~/images/" + fileName; fileName = Path.Combine(Server.MapPath("~/images/"), fileName); dp.SaveAs(fileName); usr.AddLine1 = userProfile.add1; usr.Addline2 = userProfile.add2; usr.City = userProfile.city; usr.Collage = userProfile.collage; usr.Country = userProfile.country; usr.State = userProfile.state; usr.University = userProfile.university; usr.ZipCode = userProfile.zipcode; usr.DOB = userProfile.bdate; usr.PhoneNo = userProfile.phone; usr.IsDetailsSubmitted = true; usr.CPassword = "******"; usr.Gender = "Male"; usr.ProfilePicture = userProfile.uploaddp; db.SaveChanges(); return(View()); } } } else { return(View()); } }
public ActionResult Registration(MembersData md) { projectEntities1 db = new projectEntities1(); db.MembersDatas.Add(md); if (md.Password == md.CPassword) { db.SaveChanges(); var verifyUrl = "/Auth/ConfirmEmail?Email=" + md.EmailId; var link = Request.Url.AbsoluteUri.Replace(Request.Url.PathAndQuery, verifyUrl); var fromemail = new MailAddress("*****@*****.**"); var toemail = new MailAddress(md.EmailId); MailMessage mm = new MailMessage("*****@*****.**", md.EmailId); mm.Subject = " Note Marketplace - Email Verification "; mm.IsBodyHtml = true; mm.Body = "<a'" + link + "'>" + link + "</a>"; SmtpClient smtp = new SmtpClient(); smtp.Host = "smtp.gmail.com"; smtp.Port = 587; smtp.EnableSsl = true; smtp.DeliveryMethod = SmtpDeliveryMethod.Network; smtp.UseDefaultCredentials = false; smtp.Credentials = new NetworkCredential(fromemail.Address, "Note@tatva"); smtp.Send(mm); TempData["Success"] = "Registration Successfully Done!"; return(RedirectToAction("Login", "Auth")); } else { TempData["Success"] = "Password and Confirm password miss match"; return(RedirectToAction("Registration", "Auth")); } }
public ActionResult MembersDetails(int id, MemberDetailfull md) { projectEntities1 db = new projectEntities1(); MembersData mb = db.MembersDatas.Where(u => u.Id == id).FirstOrDefault(); { ViewData["Notedetail"] = db.NoteDetails.ToList(); md.id = id; md.ad1 = mb.AddLine1; md.ad2 = mb.Addline2; md.bd = mb.DOB.ToString(); md.city = mb.City; md.country = mb.Country; md.emailid = mb.EmailId; md.fn = mb.FirstName; md.ln = mb.LastName; md.phone = mb.PhoneNo; md.state = mb.State; md.uni = mb.University; md.zip = mb.ZipCode; md.img = mb.ProfilePicture; return(View(md)); } }
public ActionResult Registration() { MembersData md = new MembersData(); return(View(md)); }