public JsonResult AddNewStaff(Profile newMember) { //------------------------------for Custom MemberID----------------------------- var date = DateTime.Today; //var dateforcustomMemberID = date.ToString("yyyyMMdd"); //var customMemberID = ""; //var data = context.tbl_Profile.Where(o => o.Walk_In_Member != true && o.UserType == 3).ToList(); //if (data.Count != 0) //{ // var lastRec = data.LastOrDefault(); // if (lastRec.CustomMemberID != null && lastRec.CustomMemberID != "") // { // if (lastRec.CustomMemberID.Count(x => x == '-') != 0) // { // customMemberID = "CWC" + dateforcustomMemberID + "001"; // } // else // { // string dateSub = lastRec.CustomMemberID.Substring(3, 8); // if (dateforcustomMemberID == dateSub) // { // string seriesSub = lastRec.CustomMemberID.Substring(11); // int series = Convert.ToInt32(seriesSub); // series += 1; // customMemberID = "CWC" + dateSub + series.ToString("000"); // } // else // { // customMemberID = "CWC" + dateforcustomMemberID + "001"; // } // } // } // else // { // customMemberID = "CWC" + dateforcustomMemberID + "001"; // } //} //else //{ // customMemberID = "CWC" + dateforcustomMemberID + "001"; //} //----------------------------------------------------------- int currentUserTypeLoggedin = Convert.ToInt32(Request.Cookies["UserType"].Value); tbl_Profile prf = new tbl_Profile(); prf.F_Name = newMember.F_Name; prf.L_Name = newMember.L_Name; prf.Address = newMember.Address; prf.Email = newMember.Email; prf.PhoneNo = newMember.PhoneNo; prf.DOB = newMember.DOB; prf.City = newMember.City; prf.State = newMember.State; prf.Status = true; prf.EmailNotifications = newMember.EmailNotifications; prf.UserType = newMember.UserType; //prf.Password = newMember.Password; prf.FatherName = newMember.FatherName; // prf.Reference_Of_Walk_In = newMember.Reference_Of_Walk_In; //prf.CustomMemberID = customMemberID; prf.AddedBy = Request.Cookies["AddedBy"].Value; prf.Walk_In_Member = false; prf.Additional_Notes = newMember.Additional_Notes; //prf.Addon_Member = newMember.Addon_Member; //prf.Relationship = newMember.Relationship; prf.JoiningDate = newMember.Staff_JoiningDate; if (newMember.AadharNo != null && newMember.AadharNo != "") { prf.AadharNo = newMember.AadharNo; } if (newMember.PAN_Card != null && newMember.PAN_Card != "") { prf.PAN_Card = newMember.PAN_Card; } if (currentUserTypeLoggedin == 2) { prf.NewUsrBySuperApprv = false; } else { prf.NewUsrBySuperApprv = true; } prf.DelUsrBySuperApprv = false; context.tbl_Profile.Add(prf); context.SaveChanges(); int id = prf.ID; //string expDate = ""; //if (id != 0) //{ // //var date = DateTime.Today; // string DateFormat = date.ToString(@"MM\/dd\/yyyy"); // if (newMember.MembershipPlanIDForUser != 0 && newMember.MembershipPlanIDForUser != null) // { // string[] expiredate = newMember.MembershipJoiningDate.Split('/'); // var expireFullDate = new DateTime(Convert.ToInt32(expiredate[2]), Convert.ToInt32(expiredate[0]), Convert.ToInt32(expiredate[1])); // var getMembershipPlanYear = context.tbl_MembershipPlans.SingleOrDefault(py => py.ID == newMember.MembershipPlanIDForUser); // int planYear = getMembershipPlanYear.MembershipPlanForYear; // tbl_UserMembership n = new tbl_UserMembership(); // n.UserID = id; // n.MembershipID = newMember.MembershipPlanIDForUser; // n.MembershipJoiningDate = newMember.MembershipJoiningDate; // n.MembershipExpiryDate = expireFullDate.AddYears(planYear).ToString(@"MM\/dd\/yyyy"); // //n.MembershipPlanForYear = newMember.PlanForYear; // context.tbl_UserMembership.Add(n); // context.SaveChanges(); // expDate = expireFullDate.AddYears(planYear).ToString(@"MM\/dd\/yyyy"); // } // tbl_MembersBillingDetails bill = new tbl_MembersBillingDetails(); // var billingDetails = JsonConvert.DeserializeObject<BillingDetails>(newMember.billingDetailsInJson); // bill.Mode_Of_Payment = billingDetails.Mode_Of_Payment; // bill.TotalAmount = billingDetails.Amount_Paid; // if (billingDetails.Cheque_No != "" && billingDetails.Cheque_No != null) // bill.Cheque_No = billingDetails.Cheque_No; // else // bill.Cheque_No = null; // if (billingDetails.BankName != "" && billingDetails.BankName != null) // bill.BankName = billingDetails.BankName; // else // bill.BankName = null; // bill.UserID = id; // bill.Payment_Date = DateFormat; // context.tbl_MembersBillingDetails.Add(bill); // context.SaveChanges(); //=================================================================================== if (newMember.MemberPhoto != null) { string directoryPath = Server.MapPath("/images/MembersPhotoFolder/" + id); if (!Directory.Exists(directoryPath)) { Directory.CreateDirectory(directoryPath); } var fileName = Path.GetFileName(newMember.MemberPhoto.FileName); string _name = Guid.NewGuid().ToString() + fileName; var comPath = Server.MapPath("/images/MembersPhotoFolder/" + id + "/") + _name; var path = "/images/MembersPhotoFolder/" + id + "/" + _name; newMember.MemberPhoto.SaveAs(comPath); tbl_MembersPhoto photo = new tbl_MembersPhoto(); photo.UserID = id; photo.MemberImagePath = path; context.tbl_MembersPhoto.Add(photo); context.SaveChanges(); } if (newMember.MemberDocuments != null) { for (int i = 0; i < newMember.MemberDocuments.Count; i++) { HttpPostedFileBase file = newMember.MemberDocuments[i]; string directoryPath = Server.MapPath("/images/MembersDocumentsFolder/" + id); if (!Directory.Exists(directoryPath)) { Directory.CreateDirectory(directoryPath); } var fileName = Path.GetFileName(file.FileName); string _name = Guid.NewGuid().ToString() + fileName; var comPath = Server.MapPath("/images/MembersDocumentsFolder/" + id + "/") + _name; var path = "/images/MembersDocumentsFolder/" + id + "/" + _name; file.SaveAs(comPath); tbl_MembersDocs photo = new tbl_MembersDocs(); photo.UserID = id; photo.MemberDocsPath = path; context.tbl_MembersDocs.Add(photo); context.SaveChanges(); } //} //=================================================================================== // HttpPostedFileBase imageFile = Request.Files["MemberPhoto"]; // if (imageFile != null) // { // string directoryPath = Server.MapPath("/MembersPhotoFolder/" + id); // if (!Directory.Exists(directoryPath)) // { // Directory.CreateDirectory(directoryPath); // } // var fileName = Path.GetFileName(imageFile.FileName); // string _name = Guid.NewGuid().ToString() + fileName; // var comPath = Server.MapPath("/MembersPhotoFolder/" + id + "/") + _name; // var path = "/MembersPhotoFolder/" + id + "/" + _name; // imageFile.SaveAs(comPath); // tbl_MembersPhoto photo = new tbl_MembersPhoto(); // photo.UserID = id; // photo.MemberImagePath = path; // context.tbl_MembersPhoto.Add(photo); // context.SaveChanges(); // } //} } var result = new { currentUserTypeLoggedin = currentUserTypeLoggedin, //userID = id, //ExpiryDate = expDate }; return(Json(result)); }
public JsonResult UpdateDetailsByID(Profile prf) { var data = context.tbl_Profile.Find(prf.ID); if (data != null) { data.F_Name = prf.F_Name; data.L_Name = prf.L_Name; data.Address = prf.Address; data.Email = prf.Email; data.PhoneNo = prf.PhoneNo; data.City = prf.City; //data.Password = prf.Password; data.State = prf.State; data.AddedBy = Request.Cookies["AddedBy"].Value; data.UserType = prf.UserType; data.DOB = prf.DOB; // data.CustomMemberID = prf.CustomMemberID; data.FatherName = prf.FatherName; //data.Reference_Of_Walk_In = prf.Reference_Of_Walk_In; data.EmailNotifications = prf.EmailNotifications; data.JoiningDate = prf.Staff_JoiningDate; data.Additional_Notes = prf.Additional_Notes; //data.Addon_Member = prf.Addon_Member; //data.Relationship = prf.Relationship; if (prf.AadharNo != null && prf.AadharNo != "") { data.AadharNo = prf.AadharNo; } if (prf.PAN_Card != null && prf.PAN_Card != "") { data.PAN_Card = prf.PAN_Card; } //if (prf.MembershipPlanIDForUser != null && prf.MembershipPlanIDForUser != 0) //{ // var date = DateTime.Today; // string DateFormat = date.ToString(@"MM\/dd\/yyyy"); // var modifyUserPlan = context.tbl_UserMembership.SingleOrDefault(m => m.UserID == data.ID); // var getPlanYear = context.tbl_MembershipPlans.SingleOrDefault(py => py.ID == prf.MembershipPlanIDForUser); // if (modifyUserPlan != null) // { // string[] expiredate = prf.MembershipJoiningDate.Split('/'); // var expireFullDate = new DateTime(Convert.ToInt32(expiredate[2]), Convert.ToInt32(expiredate[0]), Convert.ToInt32(expiredate[1])); // modifyUserPlan.MembershipID = prf.MembershipPlanIDForUser; // modifyUserPlan.MembershipJoiningDate = prf.MembershipJoiningDate; // modifyUserPlan.MembershipExpiryDate = expireFullDate.AddYears(getPlanYear.MembershipPlanForYear).ToString(@"MM\/dd\/yyyy"); // //modifyUserPlan.MembershipPlanForYear = prf.PlanForYear; // context.Entry(modifyUserPlan).State = EntityState.Modified; // var delUserStay = context.tbl_UsersStay.Where(du => du.UserID == data.ID).ToList(); // if (delUserStay != null) // { // foreach (var d in delUserStay) // { // var delBillingDet = context.tbl_BillingDetails.Where(du => du.UserStay_ID == d.ID).ToList(); // if (delBillingDet != null) // { // foreach (var b in delBillingDet) // { // context.Entry(b).State = EntityState.Deleted; // } // } // var delUsersOrders = context.tbl_UsersOrder.Where(du => du.UserStay_ID == d.ID).ToList(); // if (delUsersOrders != null) // { // foreach (var u in delUsersOrders) // { // context.Entry(u).State = EntityState.Deleted; // } // } // var delMemWhileStaying = context.tbl_MembersWhileStayingWithUser.Where(du => du.UserStay_ID == d.ID).ToList(); // if (delMemWhileStaying != null) // { // foreach (var m in delMemWhileStaying) // { // context.Entry(m).State = EntityState.Deleted; // } // } // context.Entry(d).State = EntityState.Deleted; // } // } // } // else // { // tbl_UserMembership usrMember = new tbl_UserMembership(); // usrMember.UserID = data.ID; // usrMember.MembershipID = prf.MembershipPlanIDForUser; // usrMember.MembershipJoiningDate = DateFormat; // usrMember.MembershipExpiryDate = date.AddYears(getPlanYear.MembershipPlanForYear).ToString(@"MM\/dd\/yyyy"); // //usrMember.MembershipPlanForYear = prf.PlanForYear; // context.tbl_UserMembership.Add(usrMember); // } //} context.Entry(data).State = EntityState.Modified; context.SaveChanges(); //----------------------------------------------------------------------------------------------------- if (prf.MemberPhoto != null) { string directoryPath = Server.MapPath("/images/MembersPhotoFolder/" + data.ID); if (!Directory.Exists(directoryPath)) { Directory.CreateDirectory(directoryPath); } var fileName = Path.GetFileName(prf.MemberPhoto.FileName); string _name = Guid.NewGuid().ToString() + fileName; var comPath = Server.MapPath("/images/MembersPhotoFolder/" + data.ID + "/") + _name; var path = "/images/MembersPhotoFolder/" + data.ID + "/" + _name; prf.MemberPhoto.SaveAs(comPath); tbl_MembersPhoto photo = new tbl_MembersPhoto(); photo.UserID = data.ID; photo.MemberImagePath = path; context.tbl_MembersPhoto.Add(photo); context.SaveChanges(); } if (prf.MemberDocuments != null) { for (int i = 0; i < prf.MemberDocuments.Count; i++) { HttpPostedFileBase file = prf.MemberDocuments[i]; string directoryPath = Server.MapPath("/images/MembersDocumentsFolder/" + data.ID); if (!Directory.Exists(directoryPath)) { Directory.CreateDirectory(directoryPath); } var fileName = Path.GetFileName(file.FileName); string _name = Guid.NewGuid().ToString() + fileName; var comPath = Server.MapPath("/images/MembersDocumentsFolder/" + data.ID + "/") + _name; var path = "/images/MembersDocumentsFolder/" + data.ID + "/" + _name; file.SaveAs(comPath); tbl_MembersDocs photo = new tbl_MembersDocs(); photo.UserID = data.ID; photo.MemberDocsPath = path; context.tbl_MembersDocs.Add(photo); context.SaveChanges(); } } } return(Json("Updated.")); }