public ActionResult CustomerRegistration([Bind(Exclude = "IsEmailVerified,ActivationCode")] Customer customer)
{
bool status = false;
string message = "";
//Model Validation
if (ModelState.IsValid)
{
#region
//Email is Already exists
var isExist = false;// isEmailExist(user.EmailID);
if (isExist)
{
ModelState.AddModelError("EmailExist", "Email is Already exist");
return(View(customer));
}
#endregion
#region// genrate Activation code
customer.ActivationCode = Guid.NewGuid();
#endregion
#region//Password hashing
customer.Password = Crypto.Hash(customer.Password);
customer.ConfirmPassword = Crypto.Hash(customer.ConfirmPassword);
customer.IsEmailVerified = false;
#endregion
#region
//save to database
using (EWorkDatabaseEntities dc = new EWorkDatabaseEntities())
{
dc.Customers.Add(customer);
dc.SaveChanges();
//send Email to User
sendVerificationEmailLink(customer.EmailID, customer.ActivationCode.ToString());
message = "Registration Sucessfully Done account verification is send to your email ID" + customer.EmailID;
status = true;
}
#endregion
}
else
{
message = "Invalid Request";
}
ViewBag.Message = message;
ViewBag.Status = status;
return(View());
}
public ActionResult VerifyAccount(string id)
{
bool Status = false;
using (EWorkDatabaseEntities dc = new EWorkDatabaseEntities())
{
dc.Configuration.ValidateOnSaveEnabled = false; //this line is added for to avoid the the
//confirm password doesnt match issue
//on save changes
var v = dc.Customers.Where(a => a.ActivationCode == new Guid(id)).FirstOrDefault();
if (v != null)
{
v.IsEmailVerified = true;
dc.SaveChanges();
Status = true;
}
else
{
ViewBag.Message = "Invalid Request";
}
}
ViewBag.Status = Status;
return(View());
}
public bool isEmailExist(string emailID)
{
using (EWorkDatabaseEntities dc = new EWorkDatabaseEntities())
{
var v = dc.Customers.Where(a => a.EmailID == emailID).FirstOrDefault();
return(v != null);
}
}
public ActionResult CustomerLogin(CustomerLogin cslogin, string ReturnUrl)
{
System.Diagnostics.Debug.WriteLine("in Login Action");
string message = "";
using (EWorkDatabaseEntities dc = new EWorkDatabaseEntities()) {
var v = dc.Customers.Where(a => a.EmailID == cslogin.EmailID).FirstOrDefault();
System.Diagnostics.Debug.WriteLine("Here is your query message" + v);
if (v != null)
{
System.Diagnostics.Debug.WriteLine("Compare..." + string.Compare(Crypto.Hash(cslogin.Password), v.Password));
System.Diagnostics.Debug.WriteLine("URL..." + ReturnUrl);
if (string.Compare(Crypto.Hash(cslogin.Password), v.Password) == 0)
{
System.Diagnostics.Debug.WriteLine("Success Login Message..............");
int timeout = cslogin.RememberMe ? 525600 : 20;//525600mint=1year
var ticket = new FormsAuthenticationTicket(cslogin.EmailID, cslogin.RememberMe, timeout);
string encrypted = FormsAuthentication.Encrypt(ticket);
var cookie = new HttpCookie(FormsAuthentication.FormsCookieName, encrypted);
cookie.Expires = DateTime.Now.AddMinutes(timeout);
cookie.HttpOnly = true;
Response.Cookies.Add(cookie);
Session["UserID"] = v.Cust_Id.ToString();
Session["FirstName"] = v.FirstName.ToString();
Session["LastName"] = v.LastName.ToString();
if (Url.IsLocalUrl(ReturnUrl))
{
return(Redirect(ReturnUrl));
}
else
{
return(RedirectToAction("Pro_Index", "Professional"));
}
}
else
{
message = "Invalid Information";
}
}
else
{
message = "Invalid Information";
}
}
ViewBag.Message = message;
return(View());
}
public ActionResult ProfessionalLogin(ProfessionalLogin pslogin, string ReturnUrl)
{
System.Diagnostics.Debug.WriteLine("in Login Action");
string message = "";
List <ProfessionalVM> proVM = new List <ProfessionalVM>();
using (EWorkDatabaseEntities dc = new EWorkDatabaseEntities())
{
var v = dc.Professionals.Where(a => a.Prof_EmailID == pslogin.Prof_EmailID).FirstOrDefault();
System.Diagnostics.Debug.WriteLine("Here is your query message" + v);
if (v != null)
{
System.Diagnostics.Debug.WriteLine("Compare..." + string.Compare(Crypto.Hash(pslogin.Prof_Password), v.Prof_Password));
if (string.Compare(Crypto.Hash(pslogin.Prof_Password), v.Prof_Password) == 0)
{
System.Diagnostics.Debug.WriteLine("Success Login Message..............");
int timeout = pslogin.RememberMe ? 525600 : 20;//525600mint=1year
var ticket = new FormsAuthenticationTicket(pslogin.Prof_EmailID, pslogin.RememberMe, timeout);
string encrypted = FormsAuthentication.Encrypt(ticket);
var cookie = new HttpCookie(FormsAuthentication.FormsCookieName, encrypted);
cookie.Expires = DateTime.Now.AddMinutes(timeout);
cookie.HttpOnly = true;
Response.Cookies.Add(cookie);
if (Url.IsLocalUrl(ReturnUrl))
{
return(Redirect(ReturnUrl));
}
else
{
return(RedirectToAction("ProfessionalDashboard", "Professional"));
}
}
else
{
message = "Invalid Information";
}
}
else
{
message = "Invalid Information";
}
}
ViewBag.Message = message;
return(View());
}
public ActionResult ProfessionalDetail(int id)
{
List <ProfessionalVM> proVM = new List <ProfessionalVM>();
using (EWorkDatabaseEntities dc = new EWorkDatabaseEntities()) {
proVM = dc.Professionals.ToArray().Where(x => x.prof_Id == id).Select(x => new ProfessionalVM(x)).ToList();
}
return(View(proVM));
}
public ActionResult ParticularProfessionals(string city)
{
var professional = new List <ProfessionalVM>();
using (EWorkDatabaseEntities dc = new EWorkDatabaseEntities())
{
professional = dc.Professionals.ToArray().Select(x => new ProfessionalVM(x)).ToList();
}
return(View(professional));
}
public ActionResult Test([Bind(Include = "cust_id,pro_id,date")] HireVm hire)
{
/*bool result;
* int noOfRowInserted;
* System.Diagnostics.Debug.WriteLine("Customer Id " +cust_id+"..................Prof_Id "+pro_id);
*
* System.Diagnostics.Debug.WriteLine("Session "+Session["UserID"]);
* System.Diagnostics.Debug.WriteLine("Sess " +date);
*
*/
var professional = new List <ProfessionalVM>();
try {
using (EWorkDatabaseEntities dc = new EWorkDatabaseEntities())
{
string str1 = "insert into Hire(Cust_Id,prof_Id,Hire_Date)values(cust_id,prof_id,date)";
// string str2 = "Insert Into appointment (id, name, time) Values (id, name, time)";
var sql = @"Insert Into Hire (Cust_Id,prof_Id,Hire_Date) Values (@cust_id,@prof_id, @date)";
string str2 = "Insert Into Hire.Cust_Id, Hire.prof_Id,Hire.Hire_Date Values cust_id,prof_id,date";
var Query = dc.Database.SqlQuery <Models.Hire>(sql).ToList();
System.Diagnostics.Debug.WriteLine("Query................." + Query);
//noOfRowInserted = dc.Database.ExecuteSqlCommand(str1);
//noOfRowInserted = dc.Database.SqlQuery("insert into Hire(Cust_Id,prof_Id,Hire_Date)values(cust_id,prof_id,date)");
/*
* if (noOfRowInserted != 0) {
*
* System.Diagnostics.Debug.WriteLine("Record is successfully added......" + noOfRowInserted + " Rows are effected....");
*
* }*/
}
} catch (Exception e) {
System.Diagnostics.Debug.WriteLine("Errror is.................." + e);
}
return(Json("Hello"));
}
public ActionResult Index()
{
List <ProfessionalCategoryVM> proCatVMs = new List <ProfessionalCategoryVM>();
using (EWorkDatabaseEntities proCatDatabase = new EWorkDatabaseEntities()) {
try
{
proCatVMs = proCatDatabase.ProfessionalCategories.ToArray().Select(x => new ProfessionalCategoryVM(x)).ToList();
ViewBag.Message = proCatDatabase.ProfessionalCategories.ToArray().Select(x => new ProfessionalCategoryVM(x));
}
catch (Exception e) {
System.Diagnostics.Debug.WriteLine("ERROR!" + e);
}
}
System.Diagnostics.Debug.WriteLine("" + proCatVMs);
return(View(proCatVMs));
}
// GET: Professional
public ActionResult Pro_Index(Professional professional)
{
List <ProfessionalVM> proVMList = new List <ProfessionalVM>();
using (var context = new EWorkDatabaseEntities())
{
try
{
// Init the list
proVMList = context.Professionals.ToArray().Select(x => new ProfessionalVM(x)).ToList();
//ViewBag.Status = "query.." + query;
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
ViewBag.Error = "Error.." + ex;
}
}
System.Diagnostics.Debug.WriteLine("" + proVMList);
return(View(proVMList));
}
public ActionResult ProCatDetail(int id)
{
var proCat = new List <ProfessionalCategoryVM>();
var professional = new List <ProfessionalVM>();
var city_info = new List <CityInfoVm>();
using (EWorkDatabaseEntities dc = new EWorkDatabaseEntities())
{
proCat = dc.ProfessionalCategories.ToArray().Where(x => x.Prof_Cat_Id == id).Select(x => new ProfessionalCategoryVM(x)).ToList();
professional = dc.Professionals.ToArray().Select(x => new ProfessionalVM(x)).ToList();
city_info = dc.CityInfoes.ToArray().Select(x => new CityInfoVm(x)).ToList();
//Where(x => x.Prof_Cat_Id == id).Where(x => x.Prof_City == "Jamshoro").
}
var viewmodel = new Random_Professional
{
ProCat = proCat,
Professional = professional,
City_info = city_info
};
return(View(viewmodel));
}
public ActionResult ProfessionalRegistration([Bind(Exclude = "IsEmailVerified,ActivationCode")] Professional professional, HttpPostedFileBase file)
{
if (ModelState.IsValid)
{
try
{
if (file != null)
{
string path = Path.Combine(Server.MapPath("~/professional_img"), Path.GetFileName(file.FileName));
file.SaveAs(path);
ViewBag.FileStatus = "File uploaded successfully.";
}
// ViewBag.FileStatus = "File uploaded successfully.";
}
catch (Exception)
{
ViewBag.FileStatus = "Error while file uploading.";
}
}
bool status = false;
string message = "";
//Model Validation
if (ModelState.IsValid)
{
#region
//Email is Already exists
var isExist = false; // isEmailExist(user.EmailID);
if (isExist)
{
ModelState.AddModelError("EmailExist", "Email is Already exist");
return(View(professional));
}
#endregion
/*
* if (file != null && file.ContentLength > 0) {
* System.Diagnostics.Debug.WriteLine("in the file name");
* string filename = Path.GetFileName(file.FileName);
* string imgpath = Path.Combine(Server.MapPath("~/professional_img/"), filename);
* professional.Prof_img = imgpath;
* file.SaveAs(imgpath);
* }
*/
#region // genrate Activation code
professional.Prof_ActivationCode = Guid.NewGuid();
#endregion
#region //Password hashing
professional.Prof_Password = Crypto.Hash(professional.Prof_Password);
professional.Prof_ConfirmPassword = Crypto.Hash(professional.Prof_ConfirmPassword);
professional.Prof_IsEmailVerified = false;
#endregion
#region
//save to database
using (EWorkDatabaseEntities dc = new EWorkDatabaseEntities())
{
System.Diagnostics.Debug.WriteLine(".........." + "file--" + (file != null) + "file path---");
dc.Professionals.Add(professional);
dc.SaveChanges();
//send Email to User
sendVerificationEmailLink(professional.Prof_EmailID, professional.Prof_ActivationCode.ToString());
message = "Registration Sucessfully Done account verification is send to your email ID" + professional.Prof_EmailID;
status = true;
}
#endregion
}
else
{
message = "Invalid Request";
}
ViewBag.Message = message;
ViewBag.Status = status;
return(View());
}
