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));
}
