//here is forget password uwer exist or not it valid user check with email
        public Companydetail forgetpassword(Companydetail Reg)
        {
            string connection = ConfigurationManager.ConnectionStrings["temp_transport"].ConnectionString;

            using (SqlConnection con = new SqlConnection(connection))
            {
                con.Open();
                using (SqlCommand cm = new SqlCommand("forgetpassword", con))
                {
                    cm.CommandType = System.Data.CommandType.StoredProcedure;



                    cm.Parameters.AddWithValue("@User_Email", Reg.UserEmail);


                    SqlDataReader dr = cm.ExecuteReader();
                    if (dr.Read())
                    {
                        Reg.UserFirstName    = dr["User_FirstName"].ToString();
                        Reg.UserLastName     = dr["User_LastName"].ToString();
                        Reg.User_PhoneNumber = dr["User_PhoneNumber"].ToString();
                    }
                    //else
                    //{
                    //}
                }
                return(Reg);
            }
        }
    { //here is user verified user valid or not
        public string register(Companydetail Reg)
        {
            string message    = "";
            string connection = ConfigurationManager.ConnectionStrings["temp_transport"].ConnectionString;

            using (SqlConnection con = new SqlConnection(connection))
            {
                con.Open();
                using (SqlCommand cm = new SqlCommand("validuser", con))
                {
                    cm.CommandType = System.Data.CommandType.StoredProcedure;


                    cm.Parameters.AddWithValue("@User_PhoneNumber", Reg.User_PhoneNumber);
                    cm.Parameters.AddWithValue("@User_Email", Reg.UserEmail);



                    SqlDataReader dr = cm.ExecuteReader();
                    if (dr.Read())
                    {
                        //Reg.error = "Sorry this user is already exist";
                        message = "0";
                    }
                    else
                    {
                        message = "1";

                        //     con.Close();
                    }
                }
                return(message);
            }
        }
Exemple #3
0
        //send mail method are call in customer,driver,admin
        public ActionResult sendmail()
        {
            string numbers   = "0123456789";
            Random objrandom = new Random();
            string strrandom = string.Empty;

            for (int i = 0; i < 5; i++)
            {
                int temp = objrandom.Next(0, numbers.Length);
                strrandom += temp;
            }
            ViewBag.otp = strrandom;

            TempData["code"] = strrandom;

            TempData.Keep();

            Companydetail verifiedUser = TempData["Userdata"] as Companydetail;

            //string ahsan = verifiedUser.UserFirstName;


            WebMail.Send(verifiedUser.UserEmail, "Well Come '" + verifiedUser.UserFirstName + "_" + verifiedUser.UserLastName + "'  Sindhu Online Transport Company", "Dear Sir,<br/> You are Register this mobile NO  :" + verifiedUser.User_PhoneNumber + "<br/><br/> Your are Register With Email  :" + verifiedUser.UserEmail + "<br/><br/>Your Verfy Code Is :" + strrandom
                         , null, null, null, true, null, null, null, null, null, null);


            TempData.Keep();
            return(RedirectToAction("VerfyCode", "Registration"));
        }
Exemple #4
0
        public ActionResult ForgetPassword(Companydetail Reg, string command)
        {
            if (ModelState.IsValidField("UserEmail"))
            {
                CustomerRegister cust_reg = new CustomerRegister();
                if (command == "Reset Password")
                {
                    TempData["UserData"] = cust_reg.forgetpassword(Reg);


                    Companydetail CheckedUser = TempData["Userdata"] as Companydetail;
                    string        phone       = CheckedUser.User_PhoneNumber;
                    TempData["Phone"] = phone;
                    if (phone == null) //dont get valu data base show error message
                    {
                        TempData["Error"] = "User is Not exist Plz Try Again";
                        return(RedirectToAction("ForgetPassword", "Registration"));
                    }
                    else //if user is valid then send code and redirect in verify code
                    {
                        TempData["RegistrationRole"] = command;
                        TempData.Keep();
                        sendmail();
                        return(RedirectToAction("VerfyCode", "Registration", new { id = Session["LoginId"] }));
                    }
                }
            }
            return(View());
        }
Exemple #5
0
        public async Task <IActionResult> Edit(int id, [Bind("Id,Name,Email_Id,Address,Mobile_Number,Website")] Companydetail companydetail)
        {
            if (id != companydetail.Id)
            {
                return(NotFound());
            }

            if (ModelState.IsValid)
            {
                try
                {
                    _context.Update(companydetail);
                    await _context.SaveChangesAsync();
                }
                catch (DbUpdateConcurrencyException)
                {
                    if (!CompanydetailExists(companydetail.Id))
                    {
                        return(NotFound());
                    }
                    else
                    {
                        throw;
                    }
                }
                return(RedirectToAction(nameof(Index)));
            }
            return(View(companydetail));
        }
Exemple #6
0
        public async Task <IActionResult> Create([Bind("Id,Name,Email_Id,Address,Mobile_Number,Website")] Companydetail companydetail)
        {
            if (ModelState.IsValid)
            {
                _context.Add(companydetail);
                await _context.SaveChangesAsync();

                return(RedirectToAction(nameof(Index)));
            }
            return(View(companydetail));
        }
        //here after verify Driver save in database also forgin key store
        public string Driver_Register(Companydetail verifiedUser)
        {
            string user_id    = "";
            string connection = ConfigurationManager.ConnectionStrings["temp_transport"].ConnectionString;

            using (SqlConnection con = new SqlConnection(connection))
            {
                con.Open();
                using (SqlCommand cmd = new SqlCommand("Admin_Registration", con))
                {
                    cmd.CommandType = System.Data.CommandType.StoredProcedure;


                    cmd.Parameters.AddWithValue("@User_FirstName", verifiedUser.UserFirstName);
                    cmd.Parameters.AddWithValue("@User_LastName", verifiedUser.UserLastName);
                    cmd.Parameters.AddWithValue("@User_PhoneNumber", verifiedUser.User_PhoneNumber);
                    cmd.Parameters.AddWithValue("@User_Address", verifiedUser.UserAddress);
                    cmd.Parameters.AddWithValue("@User_Cnic", verifiedUser.UserCnic);
                    cmd.Parameters.AddWithValue("@User_Email", verifiedUser.UserEmail);
                    cmd.Parameters.AddWithValue("@User_Password", verifiedUser.User_Password);
                    cmd.Parameters.AddWithValue("@User_Role_Id", 2);
                    cmd.Parameters.AddWithValue("@User_Image", verifiedUser.Image);
                    cmd.Parameters.AddWithValue("@CompanyName", verifiedUser.user_comp);
                    cmd.Parameters.AddWithValue("@CompanyType", verifiedUser.user_comp_type);
                    cmd.Parameters.AddWithValue("@UserCity", verifiedUser.user_City);


                    SqlDataReader dr = cmd.ExecuteReader();
                    if (dr.Read())
                    {
                        user_id = Convert.ToInt32(dr["UserId"]).ToString();
                    }
                    //company detail
                    con.Close();
                    con.Open();
                    using (SqlCommand cm = new SqlCommand("Driver_info", con))
                    {
                        //cm.CommandType = System.Data.CommandType.StoredProcedure;
                        //cm.Parameters.AddWithValue("@DriverSalary", verifiedUser.Driver_Salery);
                        //cm.Parameters.AddWithValue("@DriverExperience", verifiedUser.Dreiver_exprience);
                        //cm.Parameters.AddWithValue("@DriverType", verifiedUser.Driver_Type);
                        //cm.Parameters.AddWithValue("@DriverPosition", verifiedUser.Driver_position);
                        //cm.Parameters.AddWithValue("@DriverRouteCharge", verifiedUser.Driver_Routchaege);
                        cm.Parameters.AddWithValue("@DriverUserId", user_id);
                        cm.ExecuteNonQuery();
                        con.Close();

                        return(user_id);
                    }
                }
            }
        }
Exemple #8
0
        public ActionResult UpdatePassword(Companydetail Reg, string user_ph)
        {
            user_ph = (TempData["Phone"].ToString());
            CustomerRegister cust_reg = new CustomerRegister();
            string           check    = cust_reg.UpdatePassword(Reg, user_ph);

            if (check == "1")
            {
                TempData["updatemessage"] = "Password Updated Successfully";
            }
            else
            {
                TempData["updatemessage"] = "Problem";
            }

            return(RedirectToAction("Login", "Registration", new { id = Session["LoginId"] }));
        }
        public List <Companydetail> userlogin(Companydetail log, int f_key)
        {
            //encrypted password
            string enc = log.User_Password;

            byte[] encode = new byte[enc.Length];
            encode = Encoding.UTF8.GetBytes(log.User_Password);
            string enc_password          = Convert.ToBase64String(encode);
            List <Companydetail> reglist = new List <Companydetail>();
            string connection            = ConfigurationManager.ConnectionStrings["temp_transport"].ConnectionString;

            using (SqlConnection con = new SqlConnection(connection))
            {
                con.Open();
                using (SqlCommand cm = new SqlCommand("Login", con))
                {
                    cm.CommandType = System.Data.CommandType.StoredProcedure;



                    cm.Parameters.AddWithValue("@User_PhoneNumber", log.User_PhoneNumber);

                    cm.Parameters.AddWithValue("@User_Password", enc_password);
                    cm.Parameters.AddWithValue("@f_key", f_key);

                    SqlDataReader dr = cm.ExecuteReader();
                    if (dr.Read())
                    {
                        log.UserFirstName = dr["User_FirstName"].ToString();
                        log.UserLastName  = dr["User_LastName"].ToString();
                        log.UserId        = int.Parse(dr["UserId"].ToString());
                        log.Image         = dr["User_Image"].ToString();
                        log.user_comp     = dr["CompanyName"].ToString();
                    }
                    //else
                    //{
                    //}
                }
                reglist.Add(log);
                return(reglist);
            }
        }
        //here after verify customer save in database also forgin key store
        public string Customer_register(Companydetail verifiedUser)
        {
            //encrypted password
            string enc = verifiedUser.User_Password;

            byte[] encode = new byte[enc.Length];
            encode = Encoding.UTF8.GetBytes(verifiedUser.User_Password);
            string enc_password = Convert.ToBase64String(encode);

            string message    = "";
            string connection = ConfigurationManager.ConnectionStrings["temp_transport"].ConnectionString;

            using (SqlConnection con = new SqlConnection(connection))
            {
                con.Open();
                using (SqlCommand cmd = new SqlCommand("User_Registration", con))
                {
                    cmd.CommandType = System.Data.CommandType.StoredProcedure;

                    cmd.Parameters.AddWithValue("@User_FirstName", verifiedUser.UserFirstName);
                    cmd.Parameters.AddWithValue("@User_LastName", verifiedUser.UserLastName);
                    cmd.Parameters.AddWithValue("@User_PhoneNumber", verifiedUser.User_PhoneNumber);
                    cmd.Parameters.AddWithValue("@User_Address", verifiedUser.UserAddress);
                    cmd.Parameters.AddWithValue("@User_Cnic", verifiedUser.UserCnic);
                    cmd.Parameters.AddWithValue("@User_Email", verifiedUser.UserEmail);
                    cmd.Parameters.AddWithValue("@User_Password", enc_password);
                    cmd.Parameters.AddWithValue("@User_Role_Id", 4);
                    cmd.Parameters.AddWithValue("@User_Image", verifiedUser.Image);
                    cmd.Parameters.AddWithValue("@CompanyName", verifiedUser.user_comp);
                    cmd.Parameters.AddWithValue("@CompanyType", verifiedUser.user_comp_type);
                    cmd.Parameters.AddWithValue("@UserCity", verifiedUser.user_City);

                    cmd.ExecuteNonQuery();


                    con.Close();
                    message = "User sucessfully add";
                    return(message);
                }
            }
        }
Exemple #11
0
        public ActionResult AdminRegister(Companydetail Reg, string command)
        {
            if (command == "Register")
            {
                ModelState["PinCode"].Errors.Clear();
                ModelState["VehicleNumber"].Errors.Clear();
                if (ModelState.IsValid)
                {
                    CustomerRegister Admin = new CustomerRegister();



                    string userexist = Admin.register(Reg);


                    if (userexist == "0")
                    {
                        TempData["Erroruserexist"] = "User is already exist ,Plz login";
                        return(RedirectToAction("AdminRegister", "Registration"));
                    }
                    else
                    {
                        PictureSave(Reg);
                        if (TempData["extensionerror"] == null)
                        {
                            TempData["RegistrationRole"] = command;
                            TempData.Keep();
                            sendmail();
                            return(RedirectToAction("VerfyCode", "Registration"));
                        }

                        else
                        {
                            return(RedirectToAction("AdminRegister", "Registration"));
                        }
                    }
                }
            }
            return(View());
        }
Exemple #12
0
        // GET: Registration

        //here is picture method called in customer,admin and driver
        public Models.Companydetail PictureSave(Companydetail Reg)
        {
            if (Reg.image_file.FileName != "")
            {
                string filename  = Path.GetFileNameWithoutExtension(Reg.image_file.FileName);
                string extension = Path.GetExtension(Reg.image_file.FileName).ToLower();
                if (extension == ".jpg" || extension == ".png") //check file type
                {
                    filename  = filename + DateTime.Now.ToString("yymmssfff") + extension;
                    Reg.Image = "~/Pictures/Registeration/" + filename;
                    filename  = Path.Combine(Server.MapPath("~/Pictures/Registeration/"), filename);
                    Reg.image_file.SaveAs(filename);
                    TempData["UserData"] = Reg;
                }
                else
                {
                    TempData["extensionerror"] = "Plz check Your Image Type";
                }
            }

            return(Reg);
        }
        //here user reset password
        public string UpdatePassword(Companydetail reg, string user_ph)
        {
            //encrypted password
            string enc = reg.User_Password;

            byte[] encode = new byte[enc.Length];
            encode = Encoding.UTF8.GetBytes(reg.User_Password);
            string enc_password = Convert.ToBase64String(encode);

            string message    = "";
            string connection = ConfigurationManager.ConnectionStrings["temp_transport"].ConnectionString;

            using (SqlConnection con = new SqlConnection(connection))
            {
                con.Open();
                using (SqlCommand cm = new SqlCommand("UpdatePassword", con))
                {
                    cm.CommandType = System.Data.CommandType.StoredProcedure;



                    cm.Parameters.AddWithValue("@User_Password", enc_password);
                    cm.Parameters.AddWithValue("@User_PhoneNumber", user_ph);



                    //SqlDataReader dr = cm.ExecuteReader();
                    if (cm.ExecuteNonQuery() > 0)
                    {
                        message = "1";
                    }
                    con.Close();
                }


                return(message);
            }
        }
        public List <Companydetail> VehicleLogin(Companydetail log)
        {
            List <Companydetail> reglist = new List <Companydetail>();

            string connection = ConfigurationManager.ConnectionStrings["temp_transport"].ConnectionString;

            using (SqlConnection con = new SqlConnection(connection))
            {
                con.Open();
                using (SqlCommand cm = new SqlCommand("sp_Vehicle_VehicleLogin", con))
                {
                    cm.CommandType = System.Data.CommandType.StoredProcedure;



                    cm.Parameters.AddWithValue("@VehicleNumber", log.VehicleNumber); //vehicle no

                    cm.Parameters.AddWithValue("@PinCode", log.PinCode);             //PinCode

                    Companydetail company = new Companydetail();
                    SqlDataReader dr      = cm.ExecuteReader();
                    if (dr.Read())
                    {
                        company.Image         = dr["Vehicle_ImageUrl"].ToString();
                        company.VehicleNumber = dr["Vehicle_Number"].ToString();
                        //here return vehicle no
                    }
                    //else
                    //{
                    //}
                    reglist.Add(company);
                }

                return(reglist);
            }
        }
Exemple #15
0
        public ActionResult FinalyCustomerRegister(Companydetail REG, string command1)
        {
            //firstly we check a code is npot equall
            string role = (TempData["RegistrationRole"].ToString());
            string C;

            if (TempData["code"] != null)          //code recive in send mail method
            {
                C = (TempData["code"].ToString()); //code assign in varible c for if check


                if (REG.VerifyCode == C)                                                   //code match ,user enter
                {
                    Companydetail    verifiedUser = TempData["Userdata"] as Companydetail; //tempdata user(user reg form) assign in veifieduser
                    CustomerRegister cust_reg     = new CustomerRegister();
                    if (role == "Sing Up")                                                 //its for customer sing up
                    {
                        cust_reg.Customer_register(verifiedUser);

                        //PictureSave(REG);
                        return(RedirectToAction("Login", "Registration", new { id = Session["LoginId"] })); //user sucessfullly registered and goes customer home page
                    }

                    else if (role == "Register")// its for admin
                    {
                        cust_reg.Admin_Register(verifiedUser);
                        // PictureSave(REG);
                        List <Companydetail> Reg = new List <Companydetail>();
                        Reg.Add(verifiedUser);
                        Session["UserData"] = Reg;

                        return(RedirectToAction("Login", "Registration", new { id = Session["LoginId"] })); //user sucessfullly registered and goes  admin home page
                    }


                    else if (role == "Registered")
                    {
                        //PictureSave(REG);
                        cust_reg.Driver_Register(verifiedUser);
                        return(RedirectToAction("Login", "Registration", new { id = Session["LoginId"] })); //user sucessfullly registered and goes  admin home page
                    }
                    else if (role == "Reset Password")
                    {
                        return(RedirectToAction("UpdatePassword", "Registration", new { id = Session["LoginId"] })); //user sucessfullly registered and goes update  home page
                    }
                }
                else
                {
                    TempData["WrongCode"] = "Yor code is not verified <br/> Plz TRY Again"; //code is not verified
                }
            }
            else
            {
                TempData["Errormessage"] = "Enter your 5 digit code"; //code is not entered,
            }
            if (command1 == "Resend Code")                            //here is code is resend code and redirect to verify code page
            {
                string numbers   = "0123456789";
                Random objrandom = new Random();
                string strrandom = string.Empty;
                for (int i = 0; i < 5; i++)
                {
                    int temp = objrandom.Next(0, numbers.Length);
                    strrandom += temp;
                }
                ViewBag.otp = strrandom;

                TempData["code"] = strrandom;
                TempData.Keep();

                Companydetail verifiedUser = TempData["Userdata"] as Companydetail;
                string        ahsan        = verifiedUser.UserFirstName;


                WebMail.Send(verifiedUser.UserEmail, "Well Come '" + verifiedUser.UserLastName + "_" + verifiedUser.UserLastName + "'  Sindhu Online Transport Company", "Dear Sir,<br/> You are Register this mobile NO  :" + verifiedUser.User_PhoneNumber + "<br/><br/> Your are Register With Email  :" + verifiedUser.UserEmail + "<br/><br/>Your Verfy Code Is :" + strrandom
                             , null, null, null, true, null, null, null, null, null, null);


                TempData.Keep();
                TempData["ResendMessage"] = "Check Your Email You get 5 digit Verify Code"; //code is not entered,
                return(RedirectToAction("VerfyCode", "Registration", new { id = Session["LoginId"] }));
            }
            return(RedirectToAction("VerfyCode", "Registration"));
        }
        //here after verify user save in database also forgin key store
        public string Admin_Register(Companydetail verifiedUser)
        {
            //encrypted password
            string enc = verifiedUser.User_Password;

            byte[] encode = new byte[enc.Length];
            encode = Encoding.UTF8.GetBytes(verifiedUser.User_Password);
            string enc_password = Convert.ToBase64String(encode);


            string user_id    = "";
            string connection = ConfigurationManager.ConnectionStrings["temp_transport"].ConnectionString;

            using (SqlConnection con = new SqlConnection(connection))
            {
                con.Open();
                using (SqlCommand cmd = new SqlCommand("Admin_Registration", con))
                {
                    cmd.CommandType = System.Data.CommandType.StoredProcedure;

                    cmd.Parameters.AddWithValue("@User_FirstName", verifiedUser.UserFirstName);
                    cmd.Parameters.AddWithValue("@User_LastName", verifiedUser.UserLastName);
                    cmd.Parameters.AddWithValue("@User_PhoneNumber", verifiedUser.User_PhoneNumber);
                    cmd.Parameters.AddWithValue("@User_Address", verifiedUser.UserAddress);
                    cmd.Parameters.AddWithValue("@User_Cnic", verifiedUser.UserCnic);
                    cmd.Parameters.AddWithValue("@User_Email", verifiedUser.UserEmail);
                    cmd.Parameters.AddWithValue("@User_Password", enc_password);
                    cmd.Parameters.AddWithValue("@User_Role_Id", 1);
                    cmd.Parameters.AddWithValue("@User_Image", verifiedUser.Image);
                    cmd.Parameters.AddWithValue("@CompanyName", verifiedUser.user_comp);
                    cmd.Parameters.AddWithValue("@CompanyType", verifiedUser.user_comp_type);
                    cmd.Parameters.AddWithValue("@UserCity", verifiedUser.user_City);


                    SqlDataReader dr = cmd.ExecuteReader();
                    if (dr.Read())
                    {
                        verifiedUser.UserId = int.Parse(dr["UserId"].ToString());
                    }
                    //company detail
                    con.Close();
                    con.Open();
                    using (SqlCommand cm = new SqlCommand("Company_info", con))
                    {
                        cm.CommandType = System.Data.CommandType.StoredProcedure;

                        cm.Parameters.AddWithValue("@CompanyRegNum", verifiedUser.Comp_Reg_No);
                        cm.Parameters.AddWithValue("@CompanyOwner", verifiedUser.Comp__owner_name);
                        //cm.Parameters.AddWithValue("@owner_cnic", verifiedUser.owner_cnic);
                        //cm.Parameters.AddWithValue("@owner_ph", verifiedUser.owner_ph);
                        cm.Parameters.AddWithValue("@CompanyVehicleQuanitity", verifiedUser.comp_no_vehicle);
                        cm.Parameters.AddWithValue("@CompanyWorth", verifiedUser.comp_worth);
                        cm.Parameters.AddWithValue("@CompanyAddress", verifiedUser.comp_adress);
                        cm.Parameters.AddWithValue("@CompanyPhoneNumber", verifiedUser.CompanyPhoneNumber);
                        cm.Parameters.AddWithValue("@CompanyUserId", verifiedUser.UserId);
                        cm.ExecuteNonQuery();
                        con.Close();
                        return(user_id);
                    }
                }
            }
        }
Exemple #17
0
        public ActionResult Login(Companydetail log, int id)
        {
//
            if ((ModelState.IsValidField("User_PhoneNumber") && ModelState.IsValidField("User_Password")) || (ModelState.IsValidField("VehicleNumber") && ModelState.IsValidField("PinCode")))
            {
                string username = "";
                int    f_key    = id; //here we get forgin key and

                CustomerRegister login = new CustomerRegister();

                if (id == 2)
                {
                    Session["VehicleNumber"] = login.VehicleLogin(log);
                    var userdata = (List <Companydetail>)Session["VehicleNumber"];
                    foreach (var s in userdata as List <Companydetail> )
                    {
                        username = s.VehicleNumber;
                    }
                }
                else
                {
                    //TempData["Userdata"] = login.userlogin(log, f_key);
                    List <Companydetail> Reg = login.userlogin(log, f_key);
                    TempData.Keep();
                    Session["UserData"] = Reg;
                    var userdata = (List <Companydetail>)Session["Userdata"];
                    foreach (var s in userdata as List <Companydetail> )
                    {
                        username = s.UserFirstName;
                    }
                }



                if (username != null)
                {
                    //Session["loginuser"] = userdata.user_first_name;


                    //if (Session["loginuser"] != "")
                    //{
                    //here cheked id we recive in button and redirect with specfic id
                    if (id == 1)
                    {
                        return(RedirectToAction("Index", "Admin"));
                    }
                    if (id == 4)
                    {
                        //Session["user"] =userdata.user_first_name;
                        return(RedirectToAction("Index", "Customer"));
                    }
                    if (id == 2)
                    { //its goes to driver/vehicle index page
                        //Session["user"] =userdata.user_first_name;
                        return(RedirectToAction("Index", "Vehicle"));
                    }
                }
                else
                {
                    TempData["message"] = "Login failed Try Again";
                }
            }

            return(View());
        }