public ActionResult Index(int?id)
{
if (id == null)
{
if (Session["modules"] != null)
{
List <ModuleDetails> md = Session["modules"] as List <ModuleDetails>;
ModuleDetails md1 = md.Find(x => x.Module.Equals("Member"));
ViewBag.Create = md1.Create;
ViewBag.Edit = md1.Edit;
ViewBag.Delete = md1.Delete;
}
ViewBag.ID = mo.getMemberID();
MemberRegistration mr = new MemberRegistration();
mr.member = new Member();
mr.contact = new Contact()
{
Id = int.Parse(mo.getMemberID())
};
ViewBag.Alert = "none";
ViewBag.Message = "";
return(View(mr));
}
else
{
Member mem = mo.getMember(id);
ViewBag.ID = mem.Id;
model.data = mem;
ViewBag.Alert = "none";
return(View(mem));
}
}
public int UpdateMember(MemberRegistration memberRegistration)
{
using (var con = new SqlConnection(_configuration.GetConnectionString("DatabaseConnection")))
{
con.Open();
var sqlTransaction = con.BeginTransaction();
var para = new DynamicParameters();
para.Add("@MemberId", memberRegistration.MemberId);
para.Add("@MemberFName", memberRegistration.MemberFName);
para.Add("@MemberLName", memberRegistration.MemberLName);
para.Add("@MemberMName", memberRegistration.MemberMName);
para.Add("@Address", memberRegistration.Address);
para.Add("@DOB", memberRegistration.Dob);
para.Add("@Age", memberRegistration.Age);
para.Add("@Contactno", memberRegistration.Contactno);
para.Add("@EmailID", memberRegistration.EmailId);
para.Add("@Gender", memberRegistration.Gender);
para.Add("@ModifiedBy", 0);
int result = con.Execute("Usp_UpdateMemberDetails", para, sqlTransaction, 0, CommandType.StoredProcedure);
if (result > 0)
{
sqlTransaction.Commit();
return(result);
}
else
{
sqlTransaction.Rollback();
return(0);
}
}
}
public ActionResult Edit(int?id)
{
if (Session["modules"] != null)
{
List <ModuleDetails> md = Session["modules"] as List <ModuleDetails>;
ModuleDetails md1 = md.Find(x => x.Module.Equals("Member"));
ViewBag.Edit = md1.Edit;
}
if (id == null)
{
ViewBag.ID = id;
ViewBag.Alert = "none";
ViewBag.Message = "";
return(View());
}
else
{
SubscriptionOpt subs = new SubscriptionOpt();
Member mem = mo.getMember(id);
Contact cn = co.GetContact(mem.Id);
MemberRegistration m = new MemberRegistration();
List <Subscriptions> susbData = subs.getSubscriptionsByID(id);
m.member = mem;
ViewBag.ID = mem.Id;
ViewBag.Message = "";
m.contact = cn;
m.subs = susbData;
return(View(m));
}
}
public HttpResponseMessage PostUpdateMemberProfile(AgencyAdminInfo objAgentStepA)
{
AgencyDAL _objAgencyDAL = new AgencyDAL();
Response objResponse = new Response();
MemberRegistration _objNewMemberRegt = new MemberRegistration();
try
{
var jsonResult = new StringBuilder();
jsonResult = _objAgencyDAL.SetMemberProfile(objAgentStepA);
objResponse.Data = jsonResult.ToString();
if (!string.IsNullOrEmpty(jsonResult.ToString()) && jsonResult.ToString() != "-2000")
{
objResponse.Success = true;
}
else
{
objResponse.Success = false;
}
return(Request.CreateResponse(HttpStatusCode.OK, objResponse));
}
catch (Exception ex)
{
#region set exception response
string logMsg = Environment.NewLine + DateTime.Now + Environment.NewLine + "Method Name: UpdateMemberProfile | Contoller Name: Agency Controller" + Environment.NewLine;
logMsg += "Temp Reg ID:" + objAgentStepA.TmpAgencyID + "|" + DateTime.Now + "|" + ex.ToString() + "-" + Environment.NewLine;
ErrorHandler.ErrorLog(logMsg);
#endregion
objResponse.Success = false;
HttpResponseMessage response = Request.CreateResponse(HttpStatusCode.BadRequest, objResponse);
return(response);
}
}
public ActionResult create(MemberRegistration ObjMember)
{
// MemberRegistration MemberRegistration = new MemberRegistration();
// UpdateModel(MemberRegistration);
if (string.IsNullOrEmpty(ObjMember.MemberFirstName))
{
ModelState.AddModelError("Error", "Please enter First Name");
}
else if (string.IsNullOrEmpty(ObjMember.MemberLastName))
{
ModelState.AddModelError("Error", "Please enter Last Name");
}
else if (string.IsNullOrEmpty(ObjMember.MemberAddress))
{
ModelState.AddModelError("Error", "Please enter Member Address");
}
else if (string.IsNullOrEmpty(ObjMember.MembershipAmount.ToString()))
{
ModelState.AddModelError("Error", "Please enter Membership Amount");
}
else if (string.IsNullOrEmpty(Convert.ToString(ObjMember.MembershipDate)))
{
ModelState.AddModelError("Error", "Please enter Membership Date");
}
else
{
// ObjMember.CreatedBy = Session["UserName"].ToString();
ObjMember.CreateBy = "Avi";
ObjMember.Gender = "M";
int MemberId = objRegisterMember.InsertMember(ObjMember);
if (MemberId > 0)
{
int ResultPayment = InsertPayment(ObjMember, MemberId);
if (ResultPayment > 0)
{
ViewBag.Text = "Member Created Successfully.";
}
else
{
TempData["Message"] = "Some thing went wrong while Member Created .";
}
}
else
{
TempData["Message"] = "Some thing went wrong while Member Created.";
}
return(RedirectToAction("Create"));
}
return(View(ObjMember));
}
public StringBuilder UpdaterManagementDetails(MemberRegistration _objMemberRegistrationA)
{
try
{
SqlParameter[] P = new SqlParameter[] {
new SqlParameter("@UserInfoID", _objMemberRegistrationA.UserInfoID),
new SqlParameter("@FullName", String.IsNullOrEmpty(_objMemberRegistrationA.FullName)?DBNull.Value:(object)_objMemberRegistrationA.FullName),
new SqlParameter("@Gender", String.IsNullOrEmpty(_objMemberRegistrationA.Gender)?DBNull.Value:(object)_objMemberRegistrationA.Gender),
//new SqlParameter("@Marital",String.IsNullOrEmpty(_objMemberRegistrationA.MaritalStatus)?DBNull.Value:(object)_objMemberRegistrationA.MaritalStatus ),
new SqlParameter("@DOB", String.IsNullOrEmpty(_objMemberRegistrationA.Date_of_Birth)?DBNull.Value:(object)_objMemberRegistrationA.Date_of_Birth),
//new SqlParameter("@DOB",_objMemberRegistrationA.Date_of_Birth),
new SqlParameter("@KRAPin", String.IsNullOrEmpty(_objMemberRegistrationA.KRAPin)?DBNull.Value:(object)_objMemberRegistrationA.KRAPin),
//new SqlParameter("@Mobile",String.IsNullOrEmpty(_objMemberRegistrationA.MobileNumber)?DBNull.Value:(object)_objMemberRegistrationA.MobileNumber ),
new SqlParameter("@AltMobile", String.IsNullOrEmpty(_objMemberRegistrationA.AlternateMobileNo)?DBNull.Value:(object)_objMemberRegistrationA.AlternateMobileNo),
new SqlParameter("@Email", String.IsNullOrEmpty(_objMemberRegistrationA.Email)?DBNull.Value:(object)_objMemberRegistrationA.Email),
new SqlParameter("@RightGroup", String.IsNullOrEmpty(_objMemberRegistrationA.GroupID)?DBNull.Value:(object)_objMemberRegistrationA.GroupID),
new SqlParameter("@CreatedBy", String.IsNullOrEmpty(_objMemberRegistrationA.CreatedBy)?DBNull.Value:(object)_objMemberRegistrationA.CreatedBy),
new SqlParameter("@ProfileImage", String.IsNullOrEmpty(_objMemberRegistrationA.UserImageName)?DBNull.Value:(object)_objMemberRegistrationA.UserImageName),
new SqlParameter("@UserCategoryID", String.IsNullOrEmpty(_objMemberRegistrationA.UserCategory)?DBNull.Value:(object)_objMemberRegistrationA.UserCategory),
new SqlParameter("@DialerID", String.IsNullOrEmpty(_objMemberRegistrationA.DialerID)?DBNull.Value:(object)_objMemberRegistrationA.DialerID),
};
var jsonResult = new StringBuilder();
jsonResult = DataLib.JsonStringExecuteReader(DataLib.Connection.SetConnectionString, SPKeys.SPSetAdminUserRegistration, P);
return(jsonResult);
}
catch { throw; }
}
public MembershipCostCalculator()
{
UmbracoHelper umbracoHelper = new UmbracoHelper(UmbracoContext.Current);
var memberRegistrationContent = umbracoHelper?.TypedContentAtRoot().DescendantsOrSelf(MemberRegistration.ModelTypeAlias).FirstOrDefault();
if (memberRegistrationContent != null)
{
_memberRegistration = new MemberRegistration(memberRegistrationContent);
}
}
public int InsertMember(MemberRegistration memberRegistration)
{
using (var con = new SqlConnection(_configuration["SQLConnString_PRD:DBConnGymDB_PRD"]))
{
con.Open();
var sqlTransaction = con.BeginTransaction();
var para = new DynamicParameters();
para.Add("@MemberId", "0");
para.Add("@MemberFName", memberRegistration.MemberFName);
para.Add("@MemberLName", memberRegistration.MemberLName);
para.Add("@MemberMName", memberRegistration.MemberMName);
para.Add("@Address", memberRegistration.Address);
para.Add("@DOB", memberRegistration.Dob);
para.Add("@Age", memberRegistration.Age);
para.Add("@Contactno", memberRegistration.Contactno);
para.Add("@EmailID", memberRegistration.EmailId);
para.Add("@Gender", memberRegistration.Gender);
para.Add("@PlanID", memberRegistration.PlanID);
para.Add("@SchemeID", memberRegistration.SchemeID);
para.Add("@Createdby", memberRegistration.Createdby);
para.Add("@JoiningDate", memberRegistration.JoiningDate);
para.Add("@ModifiedBy", 0);
para.Add("@MemIDOUT", dbType: DbType.Int32, direction: ParameterDirection.Output);
int resultMember = con.Execute("SprocMemberRegistrationInsertUpdateSingleItem",
para, sqlTransaction, 0, CommandType.StoredProcedure);
int memberId = para.Get <int>("MemIDOUT");
var paramater = new DynamicParameters();
paramater.Add("@PaymentID", 0);
paramater.Add("@PlanID", memberRegistration.PlanID);
paramater.Add("@WorkouttypeID", memberRegistration.SchemeID);
paramater.Add("@Paymenttype", "Cash");
paramater.Add("@PaymentFromdt", memberRegistration.JoiningDate);
paramater.Add("@PaymentAmount", memberRegistration.Amount);
paramater.Add("@CreateUserID", memberRegistration.Createdby);
paramater.Add("@ModifyUserID", memberRegistration.Createdby);
paramater.Add("@RecStatus", "A");
paramater.Add("@MemberID", memberId);
paramater.Add("@PaymentIDOUT", dbType: DbType.Int32, direction: ParameterDirection.Output);
int resultPayment = con.Execute("sprocPaymentDetailsInsertUpdateSingleItem",
paramater, sqlTransaction, 0, CommandType.StoredProcedure);
int paymentId = paramater.Get <int>("PaymentIDOUT");
if (resultMember > 0 && resultPayment > 0)
{
sqlTransaction.Commit();
return(memberId);
}
else
{
sqlTransaction.Rollback();
return(0);
}
}
}
public IActionResult RegistrationConfirmation(MemberRegistration member)
{
if (ModelState.IsValid)
{
return(View(member));
}
else
{
ViewData["errorMsg"] = "Your form had errors. Please correct and re-submit.";
return(View("RegistrationIndex", member));
}
}
public int InsertMember(MemberRegistration member)
{
try
{
using (SqlConnection con = new SqlConnection(connection))
{
SqlCommand cmd = new SqlCommand("sp_AddMember", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@MemberFirstName", member.MemberFirstName);
if (string.IsNullOrEmpty(member.MemberMiddleName))
{
member.MemberMiddleName = "";
}
cmd.Parameters.AddWithValue("@MemberMiddleName", member.MemberMiddleName);
cmd.Parameters.AddWithValue("@MemberLastName", member.MemberLastName);
cmd.Parameters.AddWithValue("@MemberAddress", member.MemberAddress);
cmd.Parameters.AddWithValue("@EmailAddress", member.EmailAddress);
cmd.Parameters.AddWithValue("@MembershipAmount", member.MembershipAmount);
cmd.Parameters.AddWithValue("@MembershipDate", member.MembershipDate);
cmd.Parameters.AddWithValue("@MembershipExpiryDate", member.MembershipExpiryDate);
if (string.IsNullOrEmpty(member.MemberImageName))
{
member.MemberImageName = "";
}
cmd.Parameters.AddWithValue("@MemberImageName", member.MemberImageName);
if (string.IsNullOrEmpty(member.MemberImagePath))
{
member.MemberImagePath = "";
}
cmd.Parameters.AddWithValue("@MemberImagePath", member.MemberImagePath);
cmd.Parameters.AddWithValue("@CreateBy", member.CreateBy);
if (string.IsNullOrEmpty(member.Gender))
{
member.Gender = "";
}
cmd.Parameters.AddWithValue("@Gender", member.Gender);
cmd.Parameters.Add("@MemberId", SqlDbType.Int, 0, "MemberId");
cmd.Parameters["@MemberId"].Direction = ParameterDirection.Output;
con.Open();
cmd.ExecuteNonQuery();
int insertedID = (int)cmd.Parameters["@MemberId"].Value;
con.Close();
return(insertedID);
}
}
catch (Exception ex)
{
throw ex;
}
}
public JsonResult IsAlreadyEmail(MemberRegistration mr, int?Id)
{
String mode = "";
if (Id == null)
{
mode = "C";
}
else
{
mode = "E";
}
return(Json(IsEmailAvailable(mr.contact.Email, mode)));
}
public ActionResult Edit(MemberRegistration objMember)
{
if (string.IsNullOrEmpty(objMember.MemberFirstName))
{
ModelState.AddModelError("Error", "Please enter First Name");
}
else if (string.IsNullOrEmpty(objMember.MemberLastName))
{
ModelState.AddModelError("Error", "Please enter Last Name");
}
else if (string.IsNullOrEmpty(objMember.MemberAddress))
{
ModelState.AddModelError("Error", "Please enter Member Address");
}
else if (string.IsNullOrEmpty(objMember.MembershipAmount.ToString()))
{
ModelState.AddModelError("Error", "Please enter Membership Amount");
}
else if (string.IsNullOrEmpty(Convert.ToString(objMember.MembershipDate)))
{
ModelState.AddModelError("Error", "Please enter Membership Date");
}
else
{
// ObjMember.CreatedBy = Session["UserName"].ToString();
objMember.CreateBy = "Avi";
int MemberId = objRegisterMember.UpdateMember(objMember);
if (MemberId > 0)
{
ViewBag.Text = "Member updated Successfully.";
}
else
{
TempData["Message"] = "Some thing went wrong while Member updated.";
}
return(RedirectToAction("Edit"));
}
return(View(objMember));
}
public int UpdateMember(MemberRegistration member)
{
try
{
using (SqlConnection con = new SqlConnection(connection))
{
SqlCommand cmd = new SqlCommand("sp_UpdateMember", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@MemberId", member.MemberId);
cmd.Parameters.AddWithValue("@MemberFirstName", member.MemberFirstName);
if (string.IsNullOrEmpty(member.MemberMiddleName))
{
member.MemberMiddleName = "";
}
cmd.Parameters.AddWithValue("@MemberMiddleName", member.MemberMiddleName);
cmd.Parameters.AddWithValue("@MemberLastName", member.MemberLastName);
cmd.Parameters.AddWithValue("@MemberAddress", member.MemberAddress);
cmd.Parameters.AddWithValue("@EmailAddress", member.EmailAddress);
cmd.Parameters.AddWithValue("@MembershipAmount", member.MembershipAmount);
cmd.Parameters.AddWithValue("@MembershipDate", member.MembershipDate);
cmd.Parameters.AddWithValue("@MembershipExpiryDate", member.MembershipExpiryDate);
if (string.IsNullOrEmpty(member.MemberImageName))
{
member.MemberImageName = "";
}
cmd.Parameters.AddWithValue("@MemberImageName", member.MemberImageName);
if (string.IsNullOrEmpty(member.MemberImagePath))
{
member.MemberImagePath = "";
}
cmd.Parameters.AddWithValue("@MemberImagePath", member.MemberImagePath);
cmd.Parameters.AddWithValue("@CreateBy", member.CreateBy);
con.Open();
// int id = cmd.ExecuteNonQuery();
int insertedID = Convert.ToInt32(cmd.ExecuteNonQuery());
con.Close();
return(insertedID);
}
}
catch (Exception ex)
{
throw ex;
}
}
public int InsertPayment(MemberRegistration ObjMember, int MemberId)
{
try {
MemberPayment ObjMemberPayment = new MemberPayment();
ObjMemberPayment.MemberId = MemberId;
ObjMemberPayment.PaymentDate = ObjMember.MembershipDate;
ObjMemberPayment.NextPaymentDate = ObjMember.MembershipExpiryDate;
ObjMemberPayment.PaymentAmount = ObjMember.MembershipAmount;
ObjMemberPayment.PaymentBy = "Avi";
ObjMemberPayment.IsRenewal = "N";
int paymentid = objPaymentMember.InsertMemberPayment(ObjMemberPayment);
return(paymentid);
}
catch (Exception e)
{
throw e;
}
}
public IEnumerable <MemberRegistration> AllMemberDetails()
{
try
{
SqlDataReader dr;
List <MemberRegistration> MemberList = new List <MemberRegistration>();
using (SqlConnection con = new SqlConnection(connection))
{
con.Open();
SqlCommand cmd = new SqlCommand("select * from Tbl_Member", con);
dr = cmd.ExecuteReader();
while (dr.Read())
{
MemberRegistration member = new MemberRegistration();
member.MemberId = Convert.ToInt32(dr["MemberId"]);
member.MemberFirstName = dr["MemberFirstName"].ToString();
member.MemberMiddleName = dr["MemberMiddleName"].ToString();
member.MemberLastName = dr["MemberLastName"].ToString();
member.MemberAddress = dr["MemberAddress"].ToString();
member.EmailAddress = dr["EmailAddress"].ToString();
member.MembershipAmount = Convert.ToInt32(dr["MembershipAmount"]);
member.MembershipDate = Convert.ToDateTime(dr["MembershipDate"].ToString());
member.MembershipExpiryDate = Convert.ToDateTime(dr["MembershipExpiryDate"].ToString());
member.MemberImageName = dr["MemberImageName"].ToString();
member.MemberImagePath = dr["MemberImagePath"].ToString();
member.CreateBy = dr["CreateBy"].ToString();
MemberList.Add(member);
}
con.Close();
}
return(MemberList);
}
catch (Exception e)
{
throw e;
}
}
public ActionResult Details(int id)
{
MemberRegistration MemberRegistration = new MemberRegistration();
var memberDetails = id.GetMemberById(id);
var paymentDetails = objPaymentMember.GetPaymentDetails(id);
memberDetails.IsReadOnly = true;
//TO display Memberdetails from dashboard
if (memberDetails == null || memberDetails.MemberId == null)
{
memberDetails.IsReadOnly = false;
}
if (paymentDetails.Count() == 0 && memberDetails.MemberId == null)
{
return(View(memberDetails));
}
int maxId = paymentDetails.Max(x => x.PaymentId);
foreach (var item in paymentDetails)
{
if (item.PaymentId == maxId)
{
item.disable = "enabled";
}
memberDetails.MemberPaymentList.Add(new MemberPayment
{
MemberId = item.MemberId,
PaymentId = item.PaymentId,
PaymentAmount = item.PaymentAmount,
PaymentDate = item.PaymentDate,
NextPaymentDate = item.NextPaymentDate,
_NextPaymentDateToDisplay = item._NextPaymentDateToDisplay,
_PaymentDateToDisplay = item._PaymentDateToDisplay,
disable = item.disable
});
}
return(View(memberDetails));
}
public ActionResult Edit(MemberRegistration mr)
{
var validImageTypes = new string[]
{
"image/gif",
"image/jpeg",
"image/pjpeg",
"image/png"
};
if (mr.ImageFile == null || mr.ImageFile.ContentLength == 0)
{
// ModelState.AddModelError("ImageUpload", "This field is required");
}
else if (!validImageTypes.Contains(mr.ImageFile.ContentType))
{
// ModelState.AddModelError("ImageUpload", "Please choose either a GIF, JPG or PNG image.");
}
mr.member.ImagePath = uploadFile(mr.ImageFile);
if (ModelState.IsValid)
{
mr.member.MemberType = "member";
mr.contact.Subscribed = "";
mo.UpdateMember(mr.member);
mr.contact.MemberID = mr.member.Id;
co.UpdateContact(mr.contact);
SubscriptionOpt subs = new SubscriptionOpt();
List <Subscriptions> susbData = subs.getSubscriptionsByID(mr.member.Id);
mr.subs = susbData;
ViewBag.Message = "Successfully Update Member !!!";
ViewBag.ID = mo.getMemberID();
}
else
{
ViewBag.ID = mo.getMemberID();
mr.member.ImagePath = "/assets/images/users/deafult.png";
}
return(View(mr));
}
public void CreateMember()
{
try
{
MemberRegistration member = new MemberRegistration();
member.MemberFirstName = "Rohan";
member.MemberLastName = "Rai";
member.MemberAddress = "New Road, ktm";
member.EmailAddress = "*****@*****.**";
member.MembershipAmount = 20;
member.MembershipDate = new DateTime(2018, 06, 1);
member.MembershipExpiryDate = new DateTime(2019, 06, 1);
member.CreateBy = "Avi";
int Id = obj.InsertMember(member);
Assert.AreEqual(1, Id);
}
catch (Exception e)
{
throw e;
}
}
public StringBuilder UserManagementCreateDal(MemberRegistration _objMemberRegstA)
{
try
{
SqlParameter[] P = new SqlParameter[] {
new SqlParameter("@UserInfoID", _objMemberRegstA.UserInfoID),
new SqlParameter("@UserCategoryID", _objMemberRegstA.UserCategory),
new SqlParameter("@MobileNo", String.IsNullOrEmpty(_objMemberRegstA.MobileNumber)?DBNull.Value:(object)_objMemberRegstA.MobileNumber),
new SqlParameter("@FirstName", String.IsNullOrEmpty(_objMemberRegstA.First_Name)?DBNull.Value:(object)_objMemberRegstA.First_Name),
new SqlParameter("@LastName", String.IsNullOrEmpty(_objMemberRegstA.LastName)?DBNull.Value:(object)_objMemberRegstA.LastName),
new SqlParameter("@EmailId", String.IsNullOrEmpty(_objMemberRegstA.Email)?DBNull.Value:(object)_objMemberRegstA.Email),
new SqlParameter("@EmployeeCode", String.IsNullOrEmpty(_objMemberRegstA.EmployeeCode)?DBNull.Value:(object)_objMemberRegstA.EmployeeCode),
new SqlParameter("@RightGroup", _objMemberRegstA.GroupID),
new SqlParameter("@CreatedBy", _objMemberRegstA.CreatedBy),
};
var jsonResult = new StringBuilder();
jsonResult = DataLib.JsonStringExecuteReader(DataLib.Connection.SetConnectionString, SPKeys.SPSetAdminUserRegistration, P);
return(jsonResult);
}
catch { throw; }
}
public ActionResult Index([Bind(Exclude = "Id")] MemberRegistration mr)
{
var validImageTypes = new string[]
{
"image/gif",
"image/jpeg",
"image/pjpeg",
"image/png"
};
if (mr.ImageFile == null || mr.ImageFile.ContentLength == 0)
{
// ModelState.AddModelError("ImageUpload", "This field is required");
}
else if (!validImageTypes.Contains(mr.ImageFile.ContentType))
{
// ModelState.AddModelError("ImageUpload", "Please choose either a GIF, JPG or PNG image.");
}
mr.member.ImagePath = uploadFile(mr.ImageFile);
//mr.member.ImagePath = SaveSnap(Request.Form["avatarCropped"]);
if (ModelState.IsValid)
{
mr.member.MemberType = "member";
mr.contact.Subscribed = "";
mo.AddMemeber(mr.member);
int a = int.Parse(mo.getMemberID()) - 1;
if (mr.member.note != null && mr.member.note != "")
{
mr.member.note = mr.member.note.Trim();
}
mr.contact.MemberID = int.Parse(a.ToString());
co.AddContact(mr.contact);
ViewBag.Message = " Successfully Add Member !!! ";
ModelState.Clear();
}
ViewBag.ID = mo.getMemberID();
return(View());
}
private MemberRegistration MapMembers(MemberRegistrationViewModel member)
{
var userId = this.User.FindFirstValue(ClaimTypes.Name);
var memberObj = new MemberRegistration();
memberObj.Address = member.Address;
memberObj.Age = member.Age;
memberObj.Contactno = member.Contactno;
memberObj.Createdby = Convert.ToInt32(userId);
memberObj.Dob = member.Dob;
memberObj.EmailId = member.EmailId;
memberObj.Gender = member.Gender.ToString();
memberObj.JoiningDate = member.JoiningDate;
memberObj.MainMemberId = member.MemberId;
memberObj.MemberFName = member.MemberFName;
memberObj.MemberLName = member.MemberLName;
memberObj.MemberMName = member.MemberMName;
//memberObj.MemberNo = member.MemberId;
//memberObj.PlanID
//memberObj.SchemeID
return(memberObj);
}
public ActionResult create()
{
MemberRegistration MemberRegistration = new MemberRegistration();
return(View(MemberRegistration));
}
public ActionResult Edit(RegistrationViewModel registrationViewModel)
{
var member = new Member();
var memberRegistration = new MemberRegistration();
if (registrationViewModel != null)
{
try
{
memberRegistration = db.MemberRegistrations.Where(mr => mr.ID == registrationViewModel.MemberRegistrationID).FirstOrDefault();
member = memberRegistration.Member;
if (db.Members.Any(m => m.Email == registrationViewModel.Email && m.IsActive == true && m.ID != member.ID))
{
ModelState.AddModelError("Email", "Email address already exist in the system.");
return(View("MemberEdit", registrationViewModel));
}
//if(string.IsNullOrWhiteSpace(registrationViewModel.Password))
//{
// var hashCode = PasswordHelper.GeneratePassword(10);
// var password = PasswordHelper.EncodePassword(registrationViewModel.Password, hashCode);
// member.Password = password;
// member.HashCode = hashCode;
// EmailHelper.SendPasswordChangeMail(registrationViewModel.Email, registrationViewModel.Email);
//}
member.Email = registrationViewModel.Email;
member.IsActive = true;
member.UpdatedDate = DateTime.UtcNow;
member.UpdatedBy = 1;
memberRegistration.Member = member;
//memberRegistration.PharmacyName = string.IsNullOrWhiteSpace(registrationViewModel.CustomerName) ? string.Empty : registrationViewModel.CustomerName;
memberRegistration.OwnerName = string.IsNullOrWhiteSpace(registrationViewModel.OwnerName) ? string.Empty : registrationViewModel.OwnerName;
memberRegistration.ContactPersonName = string.IsNullOrWhiteSpace(registrationViewModel.ContactPersonName) ? string.Empty : registrationViewModel.ContactPersonName;
memberRegistration.TinNumber = string.IsNullOrWhiteSpace(registrationViewModel.TinNumber) ? string.Empty : registrationViewModel.TinNumber;
memberRegistration.Address = string.IsNullOrWhiteSpace(registrationViewModel.Address) ? string.Empty : registrationViewModel.Address;
memberRegistration.DrugLicenceNumber1 = string.IsNullOrWhiteSpace(registrationViewModel.DrugLicenceNumber1) ? string.Empty : registrationViewModel.DrugLicenceNumber1;
memberRegistration.DrugLicenceNumber2 = string.IsNullOrWhiteSpace(registrationViewModel.DrugLicenceNumber2) ? string.Empty : registrationViewModel.DrugLicenceNumber2;
memberRegistration.DrugLicenceNumber3 = string.IsNullOrWhiteSpace(registrationViewModel.DrugLicenceNumber3) ? string.Empty : registrationViewModel.DrugLicenceNumber3;
memberRegistration.DrugLicenceNumber4 = string.IsNullOrWhiteSpace(registrationViewModel.DrugLicenceNumber4) ? string.Empty : registrationViewModel.DrugLicenceNumber4;
memberRegistration.DrugLicenceExpiry1 = Convert.ToDateTime(registrationViewModel.DrugLicenceExpiry1);
memberRegistration.DrugLicenceExpiry2 = Convert.ToDateTime(registrationViewModel.DrugLicenceExpiry2);
memberRegistration.DrugLicenceExpiry3 = Convert.ToDateTime(registrationViewModel.DrugLicenceExpiry3);
memberRegistration.DrugLicenceExpiry4 = Convert.ToDateTime(registrationViewModel.DrugLicenceExpiry4);
memberRegistration.PanNumber = registrationViewModel.PanNumber;
memberRegistration.RegisteredForGst = registrationViewModel.HasGstRegistrationNumber;
memberRegistration.Constitution = registrationViewModel.Constitution;
memberRegistration.GSTResgistrationNumber = string.IsNullOrWhiteSpace(registrationViewModel.GstRegistrationNumber)
? string.Empty
: registrationViewModel.GstRegistrationNumber.Trim();
//memberRegistration.Phone = registrationViewModel.MobileNumber;
memberRegistration.IsActive = true;
memberRegistration.UpdatedBy = 1;
memberRegistration.UpdatedDate = DateTime.UtcNow;
db.MemberRegistrations.Attach(memberRegistration);
var entry = db.Entry(memberRegistration);
entry.Property(e => e.CustomerName).IsModified = true;
entry.Property(e => e.OwnerName).IsModified = true;
entry.Property(e => e.ContactPersonName).IsModified = true;
entry.Property(e => e.TinNumber).IsModified = true;
entry.Property(e => e.Address).IsModified = true;
entry.Property(e => e.DrugLicenceExpiry1).IsModified = true;
entry.Property(e => e.DrugLicenceExpiry2).IsModified = true;
entry.Property(e => e.DrugLicenceExpiry3).IsModified = true;
entry.Property(e => e.DrugLicenceExpiry4).IsModified = true;
entry.Property(e => e.DrugLicenceNumber1).IsModified = true;
entry.Property(e => e.DrugLicenceNumber2).IsModified = true;
entry.Property(e => e.DrugLicenceNumber3).IsModified = true;
entry.Property(e => e.DrugLicenceNumber4).IsModified = true;
entry.Property(e => e.PanNumber).IsModified = true;
entry.Property(e => e.RegisteredForGst).IsModified = true;
entry.Property(e => e.Constitution).IsModified = true;
entry.Property(e => e.GSTResgistrationNumber).IsModified = true;
//entry.Property(e => e.Phone).IsModified = true;
entry.Property(e => e.IsActive).IsModified = true;
entry.Property(e => e.UpdatedBy).IsModified = true;
entry.Property(e => e.UpdatedDate).IsModified = true;
db.SaveChanges();
//EmailHelper.SendUserMail(memberRegistration.PharmacyName, member.Email);
//EmailHelper.SendAdminMail(registrationViewModel);
TempData["Success"] = "Succefully updated";
return(Redirect("/Members/RegisteredMembers"));
}
catch (Exception ex)
{
ModelState.AddModelError("Message", "Error occured while performing you request.");
return(View("MemberEdit", registrationViewModel));
}
}
return(null);
}
//[ValidateAntiForgeryToken]
public ActionResult Create(RegistrationViewModel registrationViewModel)
{
var member = new Member();
var memberRegistration = new MemberRegistration();
if (registrationViewModel != null)
{
var log = "Start of upload -----";
try
{
//if(db.members.any(m => m.email == registrationviewmodel.email && m.isactive == true))
//{
// modelstate.addmodelerror("email", "email address already exist in the system.");
// return view("create", registrationviewmodel);
//}
registrationViewModel.ImageUrl = ConfigurationManager.AppSettings["ImageUrl"];
member.ResourceID = Guid.NewGuid();;
member.Email = registrationViewModel.Email;
member.Role = db.Roles.FirstOrDefault(x => x.RoleName == "User" && x.IsActive == true);
member.IsActive = true;
member.CreatedDate = DateTime.UtcNow;
member.CreatedBy = 1;
memberRegistration.ResourceID = Guid.NewGuid();;
memberRegistration.Member = member;
memberRegistration.CustomerName = string.IsNullOrWhiteSpace(registrationViewModel.CustomerName) ? string.Empty : registrationViewModel.CustomerName;
memberRegistration.Address = string.IsNullOrWhiteSpace(registrationViewModel.Address) ? string.Empty : registrationViewModel.Address;
memberRegistration.PinCode = string.IsNullOrWhiteSpace(registrationViewModel.PinCode) ? 000000 : Convert.ToInt32(registrationViewModel.PinCode);
memberRegistration.CustomerPhone = string.IsNullOrWhiteSpace(registrationViewModel.CustomerPhone) ? string.Empty : registrationViewModel.CustomerPhone;
memberRegistration.Constitution = registrationViewModel.Constitution;
memberRegistration.OwnerName = string.IsNullOrWhiteSpace(registrationViewModel.OwnerName) ? string.Empty : registrationViewModel.OwnerName;
memberRegistration.AuthorizedPersonName = registrationViewModel.AuthorizedPersonName;
memberRegistration.MobileNumber = registrationViewModel.MobileNumber;
memberRegistration.DrugLicenceNumber1 = string.IsNullOrWhiteSpace(registrationViewModel.DrugLicenceNumber1) ? string.Empty : registrationViewModel.DrugLicenceNumber1;
memberRegistration.DrugLicenceNumber2 = string.IsNullOrWhiteSpace(registrationViewModel.DrugLicenceNumber2) ? string.Empty : registrationViewModel.DrugLicenceNumber2;
memberRegistration.DrugLicenceNumber3 = string.IsNullOrWhiteSpace(registrationViewModel.DrugLicenceNumber3) ? string.Empty : registrationViewModel.DrugLicenceNumber3;
memberRegistration.DrugLicenceNumber4 = string.IsNullOrWhiteSpace(registrationViewModel.DrugLicenceNumber4) ? string.Empty : registrationViewModel.DrugLicenceNumber4;
memberRegistration.DrugLicenceExpiry1 = DateTime.ParseExact(registrationViewModel.DrugLicenceExpiry1, "dd/MM/yyyy", null);
memberRegistration.DrugLicenceExpiry2 = !string.IsNullOrWhiteSpace(registrationViewModel.DrugLicenceExpiry2) ? DateTime.ParseExact(registrationViewModel.DrugLicenceExpiry2, "dd/MM/yyyy", null) : DateTime.Now;
memberRegistration.DrugLicenceExpiry3 = !string.IsNullOrWhiteSpace(registrationViewModel.DrugLicenceExpiry3) ? DateTime.ParseExact(registrationViewModel.DrugLicenceExpiry3, "dd/MM/yyyy", null) : DateTime.Now;
memberRegistration.DrugLicenceExpiry4 = !string.IsNullOrWhiteSpace(registrationViewModel.DrugLicenceExpiry4) ? DateTime.ParseExact(registrationViewModel.DrugLicenceExpiry4, "dd/MM/yyyy", null) : DateTime.Now;
memberRegistration.ContactPersonName = string.IsNullOrWhiteSpace(registrationViewModel.ContactPersonName) ? string.Empty : registrationViewModel.ContactPersonName;
memberRegistration.ContactPersonMobile = string.IsNullOrWhiteSpace(registrationViewModel.ContactPersonMobileNumber) ? string.Empty : registrationViewModel.ContactPersonMobileNumber;
memberRegistration.ContactPersonEmail = string.IsNullOrWhiteSpace(registrationViewModel.ContactPersonEmail) ? string.Empty : registrationViewModel.ContactPersonEmail;
memberRegistration.TinNumber = string.IsNullOrWhiteSpace(registrationViewModel.TinNumber) ? string.Empty : registrationViewModel.TinNumber;
memberRegistration.ApplicationReferenceNumber = string.IsNullOrWhiteSpace(registrationViewModel.ApplicationReferenceNumber) ? string.Empty : registrationViewModel.ApplicationReferenceNumber;
memberRegistration.PanNumber = registrationViewModel.PanNumber;
memberRegistration.RegisteredForGst = registrationViewModel.HasGstRegistrationNumber;
registrationViewModel.HasGstRegistrationNumberString = registrationViewModel.HasGstRegistrationNumber ? "Yes" : "No";
memberRegistration.GSTResgistrationNumber = string.IsNullOrWhiteSpace(registrationViewModel.GstRegistrationNumber)
? string.Empty
: registrationViewModel.GstRegistrationNumber.Trim();
//memberRegistration.Phone = registrationViewModel.MobileNumber;
memberRegistration.IsActive = true;
memberRegistration.CreatedBy = 1;
memberRegistration.CreatedDate = DateTime.UtcNow;
if (registrationViewModel.GSTAcknowledgement != null && registrationViewModel.GSTAcknowledgement.ContentLength > 0)
{
string _FileName = Path.GetFileName(registrationViewModel.GSTAcknowledgement.FileName);
string _path = Path.Combine(Server.MapPath("~/GST"));
log += _path + "-----";
if (!Directory.Exists(_path))
{
Directory.CreateDirectory(_path);
DirectoryInfo directory = new DirectoryInfo(_path);
DirectorySecurity security = directory.GetAccessControl();
security.AddAccessRule(new FileSystemAccessRule(@"everyone",
FileSystemRights.Modify,
AccessControlType.Deny));
directory.SetAccessControl(security);
}
var extension = Path.GetExtension(_FileName);
var newName = DateTime.Now.ToString("yyyyMMddHHmmdd") + extension;
_path = Path.Combine(Server.MapPath("~/GSTAcknowledgement/"), newName);
log += "Saving uploaded file -----";
registrationViewModel.GSTAcknowledgement.SaveAs(_path);
memberRegistration.GSTAcknowledgement = newName;
registrationViewModel.GSTAcknowledgementName = newName;
log += "FIles uploaded";
}
db.MemberRegistrations.Add(memberRegistration);
db.SaveChanges();
EmailHelper.SendUserMail(registrationViewModel);
EmailHelper.SendAdminMail(registrationViewModel);
//TempData["Success"] = "You are registered successfully. You will receive an email with instruction.";
return(Redirect("/Home/Login/regsuccess"));
}
catch (Exception ex)
{
log += "In exception ------";
log += ex.Message;
log += ex.InnerException.Message;
ViewBag.exception = log;
ModelState.AddModelError("Message", "Error occured while performing you request.");
return(View(registrationViewModel));
}
}
return(null);
}
public JsonResult IsAlreadyCell(MemberRegistration mr)
{
return(Json(IsCellAvailable(mr.contact.Cell)));
}
