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