public ActionResult checkuserlogin(tblRegistration _credantials)
{
/* List<tblRegistration> i=*/
//_regobj.checklogin(_credantials.Username,_credantials.Password);
return(Json(_regobj.checklogin(_credantials.Username, _credantials.Password), JsonRequestBehavior.AllowGet));
}
public ActionResult Registration([Bind(Include = "StudentId,CenterCode,Name,StateId,DistrictId,CollegeId,Year,Semester,StreamId,BranchId,CourseId,Mobile,DOB,Gender,BloodGroupId,EmailId,FatherName,ContactNo,Address,UploadPhoto,ImageFile,CreatedBy,CreatedDate,IsApproved")] tblRegistration tblRegistration)
{
if (tblRegistration.ImageFile != null)
{
string Filename = Path.GetFileNameWithoutExtension(tblRegistration.ImageFile.FileName);
string extension = Path.GetExtension(tblRegistration.ImageFile.FileName);
Filename = Filename + DateTime.Now.ToString("yymmssfff") + extension;
tblRegistration.UploadPhoto = "~/StudentImages/" + Filename;
Filename = Path.Combine(Server.MapPath("~/StudentImages/"), Filename);
tblRegistration.ImageFile.SaveAs(Filename);
}
if (ModelState.IsValid)
{
db.tblRegistrations.Add(tblRegistration);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.BloodGroupId = new SelectList(db.tblBloodGroups, "BloodGroupId", "BloodGroup", tblRegistration.BloodGroupId);
ViewBag.BranchId = new SelectList(db.tblBranches, "BranchId", "BranchName", tblRegistration.BranchId);
ViewBag.CollegeId = new SelectList(db.tblColleges, "CollegeId", "CollegeName", tblRegistration.CollegeId);
ViewBag.CourseId = new SelectList(db.tblCourses, "CourseId", "CourseName", tblRegistration.CourseId);
ViewBag.DistrictId = new SelectList(db.tblDistricts, "DistrictId", "DistrictName", tblRegistration.DistrictId);
ViewBag.StateId = new SelectList(db.tblStates, "StateId", "StateName", tblRegistration.StateId);
ViewBag.StreamId = new SelectList(db.tblStreams, "StreamId", "StreamName", tblRegistration.StreamId);
return(View(tblRegistration));
}
public int DeleteRegisteredUser(int userid)
{
tblRegistration tr = _db.tblRegistrations.Where(u => u.UserId == userid).FirstOrDefault();
_db.tblRegistrations.Remove(tr);
return(_db.SaveChanges());
}
public ActionResult Registration(UserRegistration objUr)
{
try
{
if (ModelState.IsValid)
{
tblRegistration objTr = new tblRegistration();
objTr.Createddate = DateTime.Now;
objTr.IsActive = true;
objTr.Email = objUr.Email;
objTr.Username = objUr.UserName;
objTr.Password = objUr.Password;
db.tblRegistrations.Add(objTr);
db.SaveChanges();
return(RedirectToAction("Login"));
}
else
{
return(View());
}
}
catch (Exception _Ex)
{
string msg = "";
return(RedirectToAction("Error", msg = _Ex.Message));
}
}
public ActionResult Register(tblRegistration reg)
{
if (ModelState.IsValid)
{
// RegMVCEntities db = new RegMVCEntities();
// tblRegistration reg = new tblRegistration();
// reg.Comment = "";
var crypto = new SimpleCrypto.PBKDF2();
var encrypPass = crypto.Compute(reg.Password);
reg.Password = encrypPass;
reg.PasswordSalt = crypto.Salt;
reg.IsApproved = true;
reg.IsAnonymous = false;
reg.LastActivityDate = DateTime.Now;
reg.CreateDate = DateTime.Now;
db.tblRegistrations.Add(reg);
db.SaveChanges();
return(RedirectToAction("Index", "Home"));
}
// return View(reg);
return(View());
}
public ActionResult Registration(tblRegistration registrationView)
{
bool statusRegistration = false;
string messageRegistration = string.Empty;
if (ModelState.IsValid)
{
// Email Verification
//string userName = Membership.GetUserNameByEmail(registrationView.Email);
//if (!string.IsNullOrEmpty(userName))
//{
// ModelState.AddModelError("Warning Email", "Sorry: Email already Exists");
// return View(registrationView);
//}
//Save User Data
using (WebAuthenticationEntities dbContext = new WebAuthenticationEntities())
{
var user = new tblRegistration()
{
Username = registrationView.Username,
FirstName = registrationView.FirstName,
LastName = registrationView.LastName,
Email = registrationView.Email,
Password = registrationView.Password,
ConfirmPassword = registrationView.ConfirmPassword,
// ActivationCode = Guid.NewGuid(),
ID = registrationView.ID,
};
var login = new tbllogin()
{
ID = registrationView.ID,
Username = registrationView.Username,
Password = registrationView.Password,
Role = null,
};
dbContext.tbllogins.Add(login);
dbContext.tblRegistrations.Add(user);
dbContext.SaveChanges();
//dbContext.Entry(user).State = System.Data.Entity.EntityState.Modified;
// context.Entry(foo).State = EntityState.Modified;
// context.SaveChanges();
//dbContext.SaveChanges();
}
//Verification Email
// VerificationEmail(registrationView.Email, registrationView.ActivationCode.ToString());
messageRegistration = "Your account has been created successfully.";
statusRegistration = true;
}
else
{
messageRegistration = "Something Wrong!";
}
ViewBag.Message = messageRegistration;
ViewBag.Status = statusRegistration;
return(View(registrationView));
}
public ActionResult tryOne(tblRegistration s)
{
DbContext.Configuration.ProxyCreationEnabled = false;
// tblRegistration d = DbContext.tblRegistrations.Find(Id);
DbContext.Entry(s).State = EntityState.Modified;
DbContext.SaveChanges();
return(Json(s, JsonRequestBehavior.AllowGet));
}
public JsonResult Index(tblRegistration details)
{
//string strpass = encryptpass(password);
DbContext.tblRegistrations.Add(details);
DbContext.SaveChanges();
return(Json(details));
}
public ActionResult DeleteConfirmed(int id)
{
tblRegistration tblRegistration = db.tblRegistrations.Find(id);
db.tblRegistrations.Remove(tblRegistration);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Update(tblRegistration details)
{
RegisterDbEntities DbContext = new RegisterDbEntities();
DbContext.Entry(details).State = EntityState.Modified;
DbContext.SaveChanges();
return(View());
}
public ActionResult DeleteRecord(string email)
{
tblRegistration DeleteOne = DbContext.tblRegistrations.Where(a => a.Email == email).FirstOrDefault();
// DbContext.re(DeleteOne);
DbContext.tblRegistrations.Remove(DeleteOne);
DbContext.SaveChanges();
return(Json(DeleteOne));
}
public ActionResult Create([Bind(Include = "email,password")] tblRegistration tblRegistration)
{
if (ModelState.IsValid)
{
db.tblRegistrations.Add(tblRegistration);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(tblRegistration));
}
public ActionResult Index(tblRegistration obj)
{
if (ModelState.IsValid)
{
MvcDbStokEntities db = new MvcDbStokEntities();
db.tblRegistration.Add(obj);
db.SaveChanges();
}
return(View(obj));
}
public ActionResult Edit()//[Bind(Include = "CustomerID,CustomerName,ContactMidName,PhoneNumber,EmailID,Password,ConfirmPassword")]Customer customer
{
if (ModelState.IsValid)
{
tblRegistration tblRegistration = new tblRegistration();
UpdateModel(tblRegistration);//UpdateModel<Customer>(customers);
entities.Entry(tblRegistration).State = EntityState.Modified;
entities.SaveChanges();
return(RedirectToAction("EditView"));
}
return(View());
}
public int UpdateRegisteredUser(RegistrationDetails rd)
{
tblRegistration tr = _db.tblRegistrations.Where(u => u.UserId == rd.UserId).FirstOrDefault();
tr.UserName = rd.UserName;
tr.UserType = rd.UserType;
tr.Password = rd.Password;
tr.FullName = rd.FullName;
tr.ContactNo = rd.ContactNo;
tr.Email = rd.Email;
tr.JoiningDate = DateTime.Now;
return(_db.SaveChanges());
}
// GET: tblRegistrations/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
tblRegistration tblRegistration = db.tblRegistrations.Find(id);
if (tblRegistration == null)
{
return(HttpNotFound());
}
return(View(tblRegistration));
}
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
tblRegistration partialView = entities.tblRegistrations.Find(id);
if (partialView == null)
{
return(HttpNotFound());
}
return(View(partialView));
}
public int RegisterNewUser(RegistrationDetails rd)
{
tblRegistration tr = new tblRegistration();
tr.UserName = rd.UserName;
tr.UserType = rd.UserType;
tr.Password = rd.Password;
tr.FullName = rd.FullName;
tr.ContactNo = rd.ContactNo;
tr.Email = rd.Email;
tr.JoiningDate = DateTime.Now;
_db.tblRegistrations.Add(tr);
return(_db.SaveChanges());
}
public ActionResult DeleteConfirmed(int?id)
{
try
{
tblRegistration tblRegistration = entities.tblRegistrations.Find(id);
entities.tblRegistrations.Remove(tblRegistration);
tbllogin tbllogin = entities.tbllogins.Find(id);
entities.tbllogins.Remove(tbllogin);
entities.SaveChanges();
return(RedirectToAction("Deleteview"));
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public ActionResult Edit([Bind(Include = "StudentId,CenterCode,Name,StateId,DistrictId,CollegeId,Year,Semester,StreamId,BranchId,CourseId,Mobile,DOB,Gender,BloodGroupId,EmailId,FatherName,ContactNo,Address,UploadPhoto,CreatedBy,CreatedDate,IsApproved")] tblRegistration tblRegistration)
{
if (ModelState.IsValid)
{
tblRegistration.CreatedBy = Session["UserName"].ToString();
tblRegistration.CreatedDate = DateTime.Now;
db.Entry(tblRegistration).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.BloodGroupId = new SelectList(db.tblBloodGroups, "BloodGroupId", "BloodGroup", tblRegistration.BloodGroupId);
ViewBag.BranchId = new SelectList(db.tblBranches, "BranchId", "BranchName", tblRegistration.BranchId);
ViewBag.CollegeId = new SelectList(db.tblColleges, "CollegeId", "CollegeName", tblRegistration.CollegeId);
ViewBag.CourseId = new SelectList(db.tblCourses, "CourseId", "CourseName", tblRegistration.CourseId);
ViewBag.DistrictId = new SelectList(db.tblDistricts, "DistrictId", "DistrictName", tblRegistration.DistrictId);
ViewBag.StateId = new SelectList(db.tblStates, "StateId", "StateName", tblRegistration.StateId);
ViewBag.StreamId = new SelectList(db.tblStreams, "StreamId", "StreamName", tblRegistration.StreamId);
return(View(tblRegistration));
}
// GET: tblRegistrations/Create
// GET: tblRegistrations/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
tblRegistration tblRegistration = db.tblRegistrations.Find(id);
if (tblRegistration == null)
{
return(HttpNotFound());
}
ViewBag.BloodGroupId = new SelectList(db.tblBloodGroups, "BloodGroupId", "BloodGroup", tblRegistration.BloodGroupId);
ViewBag.BranchId = new SelectList(db.tblBranches, "BranchId", "BranchName", tblRegistration.BranchId);
ViewBag.CollegeId = new SelectList(db.tblColleges, "CollegeId", "CollegeName", tblRegistration.CollegeId);
ViewBag.CourseId = new SelectList(db.tblCourses, "CourseId", "CourseName", tblRegistration.CourseId);
ViewBag.DistrictId = new SelectList(db.tblDistricts, "DistrictId", "DistrictName", tblRegistration.DistrictId);
ViewBag.StateId = new SelectList(db.tblStates, "StateId", "StateName", tblRegistration.StateId);
ViewBag.StreamId = new SelectList(db.tblStreams, "StreamId", "StreamName", tblRegistration.StreamId);
return(View(tblRegistration));
}
// GET: Admin/tblRegistrations/Edit/5
public ActionResult Acept(string id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
tblRegistration tblRegistration = db.tblRegistrations.Find(id + ".com");
if (tblRegistration == null)
{
return(HttpNotFound());
}
db.tblRegistrations.Remove(tblRegistration);
db.SaveChanges();
tblUser user = new tblUser();
user.email = tblRegistration.email;
user.password = tblRegistration.password;
user.role = "User";
db.tblUsers.Add(user);
db.SaveChanges();
return(RedirectToAction("Index"));
}
/// <summary>
///
/// insert and update user data
/// </summary>
/// <returns></returns>s
public ActionResult Register_userdata(tblRegistration _userdata)
{
_regobj.Registration_Insert(_userdata.Id, _userdata.Fullname, _userdata.Email, _userdata.PhoneNo, _userdata.Username, _userdata.Password, _userdata.Gender);
_regobj.SaveChanges();
return(View());
}
public bool GenrateRegistration(ISequenceMaster sequenceMaster, IConsolidatorProfile consolidatorProfile, DBContext context)
{
DateTime CurrentDatetime = DateTime.Now;
//Validate Sponsor
int? SpNid = null;
List <int> AllSpNid = new List <int>();
if (this.SpTcId != null && this.SpTcId.Length > 0)
{
SpNid = consolidatorProfile.GetNId(this.SpTcId, true);
if (SpNid == 0)
{
throw new Exception("Invalid Sponsor Nid");
}
AllSpNid = consolidatorProfile.GetAllSpNid(SpNid.Value);
AllSpNid.Add(SpNid.Value);
}
this.TcId = sequenceMaster.GenrateSequence(this.state_id);
tblRegistration tr = new tblRegistration()
{
Id = TcId,
FirstName = first_name,
MiddleName = middle_name ?? "",
LastName = last_name,
Husband_father_name = husband_father_name,
Gender = gender,
Dob = this.Dob.Value,
JoiningState = state_id,
SpNid = SpNid,
SpId = SpTcId,
Isblock = false,
IsTerminate = false,
is_active = (enmApprovalType)8,
IsKycUpdated = enmIsKycUpdated.No,
JoiningDt = CurrentDatetime,
SpLegNumber = SpNid.HasValue?(consolidatorProfile.GetNidLegCount(SpNid.Value) + 1):1,
TCRanks = enmTCRanks.Level1
};
context.tblRegistration.Add(tr);
context.SaveChanges();
TcNId = tr.Nid;
context.tblTree.AddRange(AllSpNid.Select(p => new tblTree {
TcNid = TcNId, TcSpNid = p
}).ToList());
tblTcAddressDetail tblTcAddressDetail = new tblTcAddressDetail()
{
AddressType = enmAddressType.Permanent,
address_line1 = this.address_line1,
address_line2 = this.address_line2,
StateId = this.state_id,
CountryId = this.country_id,
TcNid = TcNId,
IsDeleted = false,
CityId = null,
CreatedBy = 0,
CreatedDt = CurrentDatetime,
ModifiedBy = 0,
ModifiedDt = CurrentDatetime
};
context.tblTcAddressDetail.Add(tblTcAddressDetail);
context.SaveChanges();
tblTcRanksDetails tblTcRanksDetails = new tblTcRanksDetails()
{
TCRanks = enmTCRanks.Level1,
TcNid = TcNId,
QualifyDate = CurrentDatetime,
PPRequired = 0,
PPDone = 0,
Isdeleted = false
};
context.tblTcRanksDetails.Add(tblTcRanksDetails);
context.SaveChanges();
tblTcEmail tblTCEmail = new tblTcEmail()
{
EmailID = this.EmailAddress,
TcNid = TcNId,
Isdeleted = false,
CreatedBy = 0,
CreatedDt = CurrentDatetime,
lastModifiedBy = 0,
LastModifieddate = CurrentDatetime
};
context.TblTcEmail.Add(tblTCEmail);
context.SaveChanges();
tblTcContact tblTCContact = new tblTcContact()
{
MobileNo = this.PhoneNo,
TcNid = TcNId,
Isdeleted = false,
CreatedBy = 0,
CreatedDt = CurrentDatetime,
lastModifiedBy = 0,
LastModifieddate = CurrentDatetime
};
context.TblTcContact.Add(tblTCContact);
context.SaveChanges();
return(true);
}
