コード例 #1
0
        public ChangePasswordResponse ChangePassword(ChangePassword ul)
        {
            ChangePasswordResponse res = new ChangePasswordResponse();

            try
            {
                SqlConnection con               = new SqlConnection(ConfigurationManager.ConnectionStrings[Convert.ToString(ul.AppId)].ConnectionString);
                string        Password          = string.Empty;
                string        PasswordKey       = string.Empty;
                string        ChangePassword    = string.Empty;
                string        changePasswordKey = string.Empty;
                ChangePassword = DBsecurity.Encrypt(ul.Password, ref changePasswordKey);
                con.Open();
                string query = "Sp_WebSevice";

                SqlCommand cmd = new SqlCommand(query, con);
                cmd.CommandType = CommandType.StoredProcedure;
                cmd.Parameters.AddWithValue("@QueryType", "ChangePassword");
                cmd.Parameters.AddWithValue("@UserId", ul.UserId);
                cmd.Parameters.AddWithValue("@Password", ChangePassword);
                cmd.Parameters.AddWithValue("@PasswordKey", changePasswordKey);



                SqlDataAdapter da = new SqlDataAdapter(cmd);
                DataTable      ds = new DataTable();
                da.Fill(ds);


                if (ds != null && ds.Rows.Count > 0)
                {
                    res.status  = "Success";
                    res.message = "Password changed successfully";
                    res.userId  = ul.UserId;
                }
                else
                {
                    res.status  = "failure";
                    res.message = "Password not changed";
                    res.userId  = "";
                }


                con.Close();
            }
            catch (Exception ex)
            {
                res.status  = "failure";
                res.message = "Invalid data";
            }
            return(res);
        }
コード例 #2
0
        public SendEmailResponse ForgetPassword(SendEmail Data)
        {
            SendEmailResponse pf = new SendEmailResponse();

            try
            {
                SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings[Convert.ToString(Data.AppId)].ConnectionString);
                con.Open();
                string query = "Sp_WebSevice";

                SqlCommand cmd = new SqlCommand(query, con);
                cmd.CommandType = CommandType.StoredProcedure;
                cmd.Parameters.AddWithValue("@QueryType", "ChkEmail");
                cmd.Parameters.AddWithValue("@EmailId", Data.emailId);


                SqlDataAdapter da = new SqlDataAdapter(cmd);
                DataSet        ds = new DataSet();
                da.Fill(ds);
                if (ds != null && ds.Tables[0].Rows.Count > 0)
                {
                    if (ds.Tables[0].Rows.Count > 0 && ds.Tables[0] != null && Convert.ToInt32(ds.Tables[0].Rows[0]["value"]) == 1)
                    {
                        if (ds.Tables[1].Rows.Count > 0 && ds.Tables[1] != null)
                        {
                            using (StringWriter sw = new StringWriter())
                            {
                                using (HtmlTextWriter hw = new HtmlTextWriter(sw))
                                {
                                    StringBuilder sb        = new StringBuilder();
                                    string        WebAppUrl = ConfigurationManager.AppSettings["WebAppUrl" + Data.AppId].ToString();
                                    //string SMTPHost = ConfigurationManager.AppSettings["SMTPHost"].ToString();
                                    //string UserId = ConfigurationManager.AppSettings["UserId"].ToString();
                                    //string MailPassword = ConfigurationManager.AppSettings["MailPassword"].ToString();
                                    //string SMTPPort = ConfigurationManager.AppSettings["SMTPPort"].ToString();
                                    //string SMTPEnableSsl = ConfigurationManager.AppSettings["SMTPEnableSsl"].ToString();

                                    string SMTPHost      = ConfigurationManager.AppSettings["Amazon_SMTPHost"].ToString();
                                    string UserId        = ConfigurationManager.AppSettings["Amazon_UserId"].ToString();
                                    string MailPassword  = ConfigurationManager.AppSettings["Amazon_MailPassword"].ToString();
                                    string SMTPPort      = ConfigurationManager.AppSettings["Amazon_SMTPPort"].ToString();
                                    string SMTPEnableSsl = ConfigurationManager.AppSettings["Amazon_SMTPEnableSsl"].ToString();
                                    string FromMailId    = ConfigurationManager.AppSettings["Amazon_FromMailId" + Data.AppId].ToString();

                                    sb.Append("Dear " + ds.Tables[1].Rows[0]["UserName"].ToString() + ",<br> <br>");
                                    sb.Append("Please click on the below button to set a new Password . <br> <br>");


                                    string User = DBsecurity.Encrypt(ds.Tables[1].Rows[0]["UserId"].ToString());
                                    sb.Append("<a href='" + WebAppUrl + "ChangePassword.aspx?Id=" + User + "' target='_blank'>");
                                    sb.Append("<input style='background-color: #3965a9;color: #fff;padding: 3px 10px 3px 10px;' type='button' value='Change Password' /></a> </div>");

                                    SmtpClient smtpClient = new SmtpClient();

                                    MailMessage mailmsg     = new MailMessage();
                                    MailAddress mailaddress = new MailAddress(FromMailId);

                                    mailmsg.To.Add(ds.Tables[1].Rows[0]["EmailId"].ToString());

                                    mailmsg.From = mailaddress;

                                    mailmsg.Subject    = "Recover Password";
                                    mailmsg.IsBodyHtml = true;
                                    mailmsg.Body       = sb.ToString();

                                    smtpClient.Host                  = SMTPHost;
                                    smtpClient.Port                  = Convert.ToInt32(SMTPPort);
                                    smtpClient.EnableSsl             = Convert.ToBoolean(SMTPEnableSsl);
                                    smtpClient.UseDefaultCredentials = true;
                                    smtpClient.Credentials           = new System.Net.NetworkCredential(UserId, MailPassword);
                                    smtpClient.Send(mailmsg);
                                }
                            }
                        }
                        pf.message = "Successfully Send";
                        pf.status  = "Success";
                    }
                    else if (ds.Tables[0].Rows.Count > 0 && ds.Tables[0] != null && Convert.ToInt32(ds.Tables[0].Rows[0]["value"]) == 2)
                    {
                        if (ds.Tables[1].Rows.Count > 0 && ds.Tables[1] != null)
                        {
                            using (StringWriter sw = new StringWriter())
                            {
                                using (HtmlTextWriter hw = new HtmlTextWriter(sw))
                                {
                                    string WebAppUrl     = ConfigurationManager.AppSettings["WebAppUrl"].ToString();
                                    string SMTPHost      = ConfigurationManager.AppSettings["SMTPHost"].ToString();
                                    string UserId        = ConfigurationManager.AppSettings["UserId"].ToString();
                                    string MailPassword  = ConfigurationManager.AppSettings["MailPassword"].ToString();
                                    string SMTPPort      = ConfigurationManager.AppSettings["SMTPPort"].ToString();
                                    string SMTPEnableSsl = ConfigurationManager.AppSettings["SMTPEnableSsl"].ToString();

                                    StringBuilder sb = new StringBuilder();


                                    sb.Append("Dear Sir/Mam ,<br> <br>");
                                    sb.Append(" " + ds.Tables[1].Rows[0]["Name"].ToString() + " has requested to set a new password. Please click on the below button to set a new Password. <br> <br>");

                                    string User = DBsecurity.Encrypt(ds.Tables[1].Rows[0]["UserId"].ToString());
                                    sb.Append("<a href='" + WebAppUrl + "ChangePassword.aspx?Id=" + User + "' target='_blank'>");
                                    sb.Append("<input style='background-color: #3965a9;color: #fff;padding: 3px 10px 3px 10px;' type='button' value='Change Password' /></a> </div>");



                                    SmtpClient smtpClient = new SmtpClient();

                                    MailMessage mailmsg     = new MailMessage();
                                    MailAddress mailaddress = new MailAddress(UserId);



                                    mailmsg.To.Add(ds.Tables[2].Rows[0]["EmailId"].ToString());



                                    mailmsg.From = mailaddress;

                                    mailmsg.Subject    = "Recover Password";
                                    mailmsg.IsBodyHtml = true;
                                    mailmsg.Body       = sb.ToString();



                                    smtpClient.Host                  = SMTPHost;
                                    smtpClient.Port                  = Convert.ToInt32(SMTPPort);
                                    smtpClient.EnableSsl             = Convert.ToBoolean(SMTPEnableSsl);
                                    smtpClient.UseDefaultCredentials = true;
                                    smtpClient.Credentials           = new System.Net.NetworkCredential(UserId, MailPassword);
                                    smtpClient.Send(mailmsg);
                                }
                            }
                        }
                        pf.message = "Successfully Send";
                        pf.status  = "Success";
                    }
                    else if (ds.Tables[0].Rows.Count > 0 && ds.Tables[0] != null && Convert.ToInt32(ds.Tables[0].Rows[0]["value"]) == -1)
                    {
                        pf.status  = "failure";
                        pf.message = "Not exist";
                    }
                }
                else
                {
                    pf.status  = "failure";
                    pf.message = "Not exist";
                }
            }
            catch (Exception ex)
            {
                pf.message = "Invalid data";
                pf.status  = "failure";
            }
            return(pf);
        }
コード例 #3
0
        public UserLogin ChangePassword(UserLoginRequest ul)
        {
            try
            {
                if (ul.UserPin.Trim() == "")
                {
                    res.Message           = "User cannot be blank";
                    res.Status            = "Failure";
                    res.UserLoginResponse = ListView;
                    Ulr.UserId            = "";
                    Ulr.UserPin           = "";
                    ListView.Add(Ulr);
                    return(res);
                }
                else
                {
                    if (ul.Password.Trim() != "")
                    {
                        string pass    = string.Empty;
                        string passkey = string.Empty;

                        pass = DBsecurity.Encrypt(ul.Password.Trim(), ref passkey);

                        query     = "SP_Login";
                        dbcommand = new SqlCommand(query, conn);
                        dbcommand.Connection.Open();
                        dbcommand.CommandType = CommandType.StoredProcedure;
                        dbcommand.Parameters.AddWithValue("@QueryType", "APIUpdatePassword");
                        dbcommand.Parameters.AddWithValue("@UserPin", ul.UserPin);
                        dbcommand.Parameters.AddWithValue("@Password", pass);
                        dbcommand.Parameters.AddWithValue("@PasswordKey", passkey);
                        SqlDataAdapter da = new SqlDataAdapter(dbcommand);
                        DataTable      dt = new DataTable();
                        da.Fill(dt);
                        conn.Close();



                        if (dt.Rows.Count > 0)
                        {
                            res.Message           = "Password has been changed";
                            res.Status            = "success";
                            res.UserLoginResponse = ListView;
                            Ulr.UserId            = "";
                            Ulr.UserPin           = "";
                            ListView.Add(Ulr);
                        }
                    }
                    else
                    {
                        res.Message           = "Password cannot be blank";
                        res.Status            = "Failure";
                        res.UserLoginResponse = ListView;
                        Ulr.UserId            = "";
                        Ulr.UserPin           = "";
                        ListView.Add(Ulr);
                    }
                }
            }
            catch (Exception ex)
            {
                res.Status  = "Failure";
                res.Message = ex.Message;
            }
            finally
            {
                dbcommand.Connection.Close();
            }
            return(res);
        }
コード例 #4
0
        public LoginResponsee Logindata(Login ul)
        {
            LoginResponsee res = new LoginResponsee();

            try
            {
                SqlConnection con      = new SqlConnection(ConfigurationManager.ConnectionStrings[Convert.ToString(ul.AppId)].ConnectionString);
                string        Message  = "";
                string        userId   = "";
                string        Username = "";

                con.Open();
                string query = "Sp_WebSevice";

                SqlCommand cmd = new SqlCommand(query, con);
                cmd.CommandType = CommandType.StoredProcedure;
                cmd.Parameters.AddWithValue("@QueryType", "GetUser");
                cmd.Parameters.AddWithValue("@UserName", ul.emailId);


                SqlDataAdapter da = new SqlDataAdapter(cmd);
                DataSet        dt = new DataSet();
                da.Fill(dt);

                // bool isFound = false;

                int i = 0;
                if (dt != null)
                {
                    foreach (DataRow row in dt.Tables[0].Rows)
                    {
                        string pin   = dt.Tables[0].Rows[i]["UserName"].ToString();
                        string Passw = DBsecurity.Decrypt(dt.Tables[0].Rows[i]["Password"].ToString(), dt.Tables[0].Rows[i]["PasswordKey"].ToString());
                        if (Passw == ul.password.Trim())
                        {
                            Username     = Convert.ToString(dt.Tables[0].Rows[i]["UserName"]);
                            res.userName = Username;
                            userId       = Convert.ToString(dt.Tables[0].Rows[i]["UserId"]);
                            res.userId   = userId;
                            Message      = "Login successfully";
                            res.message  = Message;
                            res.status   = "success";
                            break;
                        }
                        else
                        {
                            res.status = "failure";
                            Message    = "Invalid Credentials";
                        }
                        i++;
                    }
                }
                else
                {
                    res.status   = "failure";
                    res.message  = "Invalid Credentials";
                    res.userName = "";
                    res.userId   = "";
                }


                con.Close();
            }

            catch (Exception ex)
            {
                res.status  = "server error";
                res.message = "Invalid data";
            }
            return(res);
        }
コード例 #5
0
        public UserLogin Login(UserLoginRequest ul)
        {
            if (ul.UserPin.Trim() != "" && Validation.ValidateUserPin(ul.UserPin.Trim()) != true)
            {
                res.Message           = "UserPin Must be 4 digit";
                res.Status            = "Failure";
                res.UserLoginResponse = ListView;
                Ulr.UserId            = "";
                Ulr.UserPin           = "";
                ListView.Add(Ulr);
                return(res);
            }

            else
            {
                //bool Flag = true;

                try
                {
                    query     = "SP_LoginWebApi";
                    dbcommand = new SqlCommand(query, conn);
                    dbcommand.Connection.Open();
                    dbcommand.CommandType = CommandType.StoredProcedure;
                    dbcommand.Parameters.AddWithValue("@QueryType", "UserAccess");
                    dbcommand.Parameters.AddWithValue("@UserPin", ul.UserPin);
                    SqlDataAdapter da = new SqlDataAdapter(dbcommand);
                    DataSet        ds = new DataSet();
                    da.Fill(ds);

                    if (ul.UserPin.Trim() != "" && ul.Password != "")
                    {
                        //if (Convert.ToString(ds.Tables[0].Rows[0]["UserPin"]) == "0")
                        //{

                        //    res.Message = "User has been disabled, please contact administrator!";
                        //    res.Status = "Failure";
                        //    res.UserLoginResponse = ListView;
                        //    Ulr.UserId = "";
                        //    Ulr.UserPin = "";
                        //    ListView.Add(Ulr);
                        //    return res;

                        //}
                        //else if (Convert.ToString(ds.Tables[0].Rows[0]["UserPin"]) == "-1")
                        //{

                        //    res.Message = "Invalid User Pin!";
                        //    res.Status = "Failure";
                        //    res.UserLoginResponse = ListView;
                        //    Ulr.UserId = "";
                        //    Ulr.UserPin = "";
                        //    ListView.Add(Ulr);
                        //    return res;

                        //}
                        //else
                        //{

                        if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
                        {
                            //bool IsLoginfirsttime = Convert.ToBoolean(ds.Tables[0].Rows[0]["LoginFlag"]);
                            string UserType = Convert.ToString(ds.Tables[0].Rows[0]["UserRoleID"]);

                            if (UserType == "1")
                            {
                                #region For Admin
                                string strDbPassword = DBsecurity.Decrypt(Convert.ToString(ds.Tables[0].Rows[0]["Password"]), Convert.ToString(ds.Tables[0].Rows[0]["PasswordKey"]));
                                if (strDbPassword.Trim() != ul.Password.Trim())
                                {
                                    res.Message           = "Wrong Password.";
                                    res.Status            = "Failure";
                                    res.UserLoginResponse = ListView;
                                    Ulr.UserPin           = "";
                                    Ulr.UserId            = "";
                                    ListView.Add(Ulr);
                                    return(res);
                                }
                                //
                                else
                                {
                                    res.Message           = "Valid User.";
                                    res.Status            = "success";
                                    res.UserLoginResponse = ListView;
                                    Ulr.UserId            = Convert.ToString(ds.Tables[0].Rows[0]["UserID"]);
                                    Ulr.UserPin           = "";
                                    ListView.Add(Ulr);
                                    return(res);
                                }
                                #endregion
                            }
                            else
                            {
                                //if (IsLoginfirsttime == true)
                                //{
                                //    #region For First Time User Login
                                //    string strDbPassword = DBsecurity.Decrypt(Convert.ToString(ds.Tables[0].Rows[0]["Password"]), Convert.ToString(ds.Tables[0].Rows[0]["PasswordKey"]));
                                //    if (strDbPassword.Trim() != ul.Password.Trim())
                                //    {


                                //        res.Message = "Wrong Password.";
                                //        res.Status = "Failure";
                                //        res.UserLoginResponse = ListView;
                                //        Ulr.UserId ="";
                                //        Ulr.UserPin = "";
                                //        ListView.Add(Ulr);
                                //        return res;
                                //    }
                                //    else
                                //    {
                                //        res.Message = "Valid User.";
                                //        res.Status = "success";
                                //        res.UserLoginResponse = ListView;
                                //        Ulr.UserId = Convert.ToString(ds.Tables[0].Rows[0]["UserID"]);
                                //        Ulr.UserPin = "";
                                //        ListView.Add(Ulr);
                                //        return res;


                                //    }
                                //    #endregion
                                //}
                                //else
                                //{
                                #region For Current user
                                //if (Convert.ToString(ConfigurationManager.AppSettings["DefaultPassword"]) == ul.Password.Trim())
                                //{
                                res.Message      = "Valid User.";
                                res.Status       = "Success";
                                res.UserSiteInfo = UserMultipleSiteInfo;
                                foreach (DataRow row in ds.Tables[0].Rows)
                                {
                                    UserMultipleSiteInfo UserMultipleSite = new UserMultipleSiteInfo();
                                    UserMultipleSite.Site      = row["AXSiteId"].ToString();
                                    UserMultipleSite.WareHouse = row["WareHouseAX"].ToString();
                                    UserMultipleSiteInfo.Add(UserMultipleSite);
                                }
                                res.UserLoginResponse             = ListView;
                                Ulr.UserId                        = Convert.ToString(ds.Tables[0].Rows[0]["UserID"]);
                                Ulr.UserPin                       = ul.UserPin;
                                Ulr.IsMove                        = Convert.ToByte(ds.Tables[0].Rows[0]["IsMove"]);
                                Ulr.IsReportAsFinished            = Convert.ToByte(ds.Tables[0].Rows[0]["IsReportAsFinished"]);
                                Ulr.IsQualityCheck                = Convert.ToByte(ds.Tables[0].Rows[0]["IsQualityCheck"]);
                                Ulr.IsAssignedPlannedAndUnplanned = Convert.ToByte(ds.Tables[0].Rows[0]["IsAssignedPlannedAndUnplanned"]);
                                Ulr.IsPickAndCount                = Convert.ToByte(ds.Tables[0].Rows[0]["IsPickAndCount"]);
                                Ulr.IsMergeStillage               = Convert.ToByte(ds.Tables[0].Rows[0]["IsMergeStillage"]);
                                Ulr.IsReturnStillage              = Convert.ToByte(ds.Tables[0].Rows[0]["IsReturnStillage"]);
                                Ulr.IsRecieveReturnStillage       = Convert.ToByte(ds.Tables[0].Rows[0]["IsRecieveReturnStillage"]);
                                Ulr.IsLookUp                      = Convert.ToByte(ds.Tables[0].Rows[0]["IsLookUp"]);
                                Ulr.IsUpdateQty                   = Convert.ToByte(ds.Tables[0].Rows[0]["IsUpdateQty"]);
                                Ulr.IsProductionJournal           = Convert.ToByte(ds.Tables[0].Rows[0]["IsProductionJournal"]);
                                Ulr.IsWorkOrderStartEnd           = Convert.ToByte(ds.Tables[0].Rows[0]["IsWorkOrderStartEnd"]);
                                Ulr.UserName                      = Convert.ToString(ds.Tables[0].Rows[0]["UserName"]);
                                Ulr.EmailId                       = Convert.ToString(ds.Tables[0].Rows[0]["EmailId"]);
                                ListView.Add(Ulr);
                                return(res);


                                //}
                                //else
                                //{

                                //    res.Message = "Wrong Password.";
                                //    res.Status = "Failure";
                                //    res.UserLoginResponse = ListView;
                                //    Ulr.UserId = "";
                                //    Ulr.UserPin = "";
                                //    ListView.Add(Ulr);
                                //    return res;


                                //}
                                #endregion
                                //}
                            }
                        }
                        else
                        {
                            res.Message           = "Invalid User.";
                            res.Status            = "Failure";
                            res.UserLoginResponse = ListView;
                            Ulr.UserId            = "";
                            Ulr.UserPin           = "";
                            ListView.Add(Ulr);
                            return(res);
                        }
                        // }
                    }
                    else
                    {
                        res.Message           = "Wrong User Pin or Password.";
                        res.Status            = "Failure";
                        res.UserLoginResponse = ListView;
                        Ulr.UserId            = "";
                        Ulr.UserPin           = "";
                        ListView.Add(Ulr);
                        return(res);
                    }
                }
                catch (Exception ex)
                {
                    res.Status  = "Failure";
                    res.Message = ex.Message;
                }
                finally
                {
                    dbcommand.Connection.Close();
                }


                return(res);
            }
        }