示例#1
0
        public passwordModels GetPassword(string pNoAnggota)
        {
            var    dPass  = new passwordModels();
            var    dPass2 = new passwordModels();
            string ePass  = "";

            try
            {
                dPass = _repoUser.GetPassword(pNoAnggota);

                ePass = mString.Decrypt(dPass.password, ConfigModels.eKeyStr);

                //Log.Debug(DateTime.Now + " GetPasswordService ===>>> No Anggota : " + pNoAnggota + " Password User: "******" Password Descrypt: " + ePass);

                dPass2.id           = dPass.id;
                dPass2.no_anggota   = dPass.no_anggota;
                dPass2.nama_anggota = dPass.nama_anggota;
                dPass2.password     = ePass;
                dPass2.keterangan   = dPass.keterangan;
                dPass2.sektor       = dPass.sektor;
                dPass2.as_admin     = dPass.as_admin;
            }
            catch (Exception ex)
            {
                Log.Error(DateTime.Now + " GetPassword Error ====>>>>>> ", ex);
            }
            return(dPass2);
        }
示例#2
0
        public void InsertPassword(passwordModels pModel)
        {
            Log.Debug(DateTime.Now + " REPO INSERT Pass 111 ====>>>>>> No Anggota : " + pModel.no_anggota + " Pass : "******"INSERT INTO mpassword (no_anggota,[password],keterangan)
                                            VALUES (?,?,?)";

            string ConnStr = ManageString.GetConnStr();

            using (OleDbConnection conn = new OleDbConnection(ConnStr))
            {
                conn.Open();
                using (OleDbCommand cmd = new OleDbCommand(SqlString, conn))
                {
                    cmd.CommandType = CommandType.Text;

                    cmd.Parameters.AddWithValue("no_anggota", pModel.no_anggota);
                    cmd.Parameters.AddWithValue("pass", pModel.password);
                    cmd.Parameters.AddWithValue("keterangan", " ");


                    try
                    {
                        var status = cmd.ExecuteNonQuery();
                        Log.Debug(DateTime.Now + " REPO INSERT Pass ====>>>>>> No Anggota : " + pModel.no_anggota + " Pass : "******" REPO INSERT Pass ERR ====>>>>>> No Anggota : " +
                                  pModel.no_anggota + " Pass : "******" err : " + ex.Message);
                    }
                }
            }
        }
示例#3
0
        public passwordModels UpdatePassword(passwordModels pModel)
        {
            string ePass = mString.Encrypt(pModel.password, ConfigModels.eKeyStr);

            passwordModels respModel = new passwordModels();

            //respModel.isValid = true;
            //respModel.message = "OK";
            //respModel.objResult = null;

            try
            {
                var vModel = new passwordModels();
                vModel.no_anggota = pModel.no_anggota;
                vModel.password   = ePass;
                vModel.keterangan = pModel.keterangan;

                _repoUser.UpdatePassword(vModel);
            }
            catch (Exception ex)
            {
                //respModel.isValid = false;
                //respModel.message = "Update Master Password Tidak Berhasil...\nPesan Error : " + ex.Message;
            }
            return(respModel);
        }
示例#4
0
        public ResponseModel InsertPassword(passwordModels pModel)
        {
            string ePass = mString.Encrypt(pModel.password, ConfigModels.eKeyStr);

            ResponseModel respModel = new ResponseModel();

            respModel.isValid   = true;
            respModel.message   = "OK";
            respModel.objResult = null;

            try
            {
                var vModel = new passwordModels();
                vModel.no_anggota = pModel.no_anggota;
                vModel.password   = ePass;
                vModel.keterangan = pModel.keterangan;

                //Log.Debug(DateTime.Now + " INSERT Pass SERVICE 1 ==>>> No Anggota : " + pModel.no_anggota + " Pass : "******" INSERT Pass SERVICE 2 ==>>> No Anggota : " + pModel.no_anggota + " Pass : "******"Insert Master Password Tidak Berhasil...\nPesan Error : " + ex.Message;
            }
            return(respModel);
        }
示例#5
0
        public dynamic UpdatePassword(passwordModels pModel)
        {
            string message = "";

            bool   isValid  = true;
            object objHasil = null;

            try
            {
                // Update
                //ResponseModel respModel = _userService.UpdatePassword(pModel);
                //isValid = respModel.isValid;
                //message = respModel.message;
            }
            catch (Exception ex)
            {
                Log.Error("Update Data Failed, No Anggota: " + pModel.no_anggota, ex);
                isValid = false;
                message = "Update Data Failed..!!" + "\r" + "Error Message: " + ex.Message;
            }

            return(Json(new
            {
                isValid,
                message,
                objHasil
            }));
        }
示例#6
0
        public ActionResult Index(passwordModels pModel)
        {
            var            newPass = new passwordModels();
            passwordModels objResult;


            try
            {
                //TODO: validate user password, save to session, etc

                string vPassLama = pModel.password.Trim().ToUpper();
                string vPassBaru = pModel.password2.Trim().ToUpper();
                string vKonfPass = pModel.keterangan.Trim().ToUpper();

                newPass.no_anggota = ConfigModels.GetNoAnggota();
                newPass.password   = vPassBaru;
                newPass.keterangan = vKonfPass;

                objResult = _userService.GetPassword(newPass.no_anggota);

                Log.Debug(DateTime.Now + "  ===>>>> USER CONTROLLER No Anggota : " + newPass.no_anggota +
                          ", Pass Lama dari DataBase : " + objResult.password + ", Pass Lama : " + vPassLama + ", Pass Baru : " + vPassBaru + ", Konfirmasi Pass : "******"2", "**Password Lama Yang Dimasukkan Salah...");
                }
                else
                {
                    if (vPassBaru != vKonfPass)
                    {
                        ModelState.AddModelError("3", "**Password Baru Tidak Sama...");
                    }
                    else
                    {
                        objResult = _userService.UpdatePassword(newPass);
                    }
                }

                if (ModelState.IsValid)
                {
                    Log.Info(DateTime.Now + " ===>>>> Change Password Success, UserCode: " + newPass.no_anggota);
                    ModelState.AddModelError("1", "CHANGE PASSWORD SUCCESS...");

                    // Redirect to requested URL, or homepage if no previous page requested
                    //string returnUrl = Request.QueryString["ReturnUrl"];
                    //if (!String.IsNullOrEmpty(returnUrl))
                    //    return Redirect(returnUrl);

                    //return RedirectToAction("Index", "Login");
                }
            }
            catch (Exception ex)
            {
                Log.Error(DateTime.Now + " =====>>>> Change Password Failed, No Anggota:" + pModel.no_anggota, ex);
                ModelState.AddModelError("1", "Change Password Failed, Please try Again or Contact Your Administrator.");
            }

            return(View(pModel));
        }
示例#7
0
        public passwordModels InitiateLoginForm(passwordModels model)
        {
            //model.ListCompany = (from b in _companyService.GetCompanies("", "", "")
            //                     where b.Deleted == false
            //                     select new SelectListItem
            //                     {
            //                         Text = b.CompanyName,
            //                         Value = b.Id.ToString()
            //                     }).ToList();
            //model.ListCompany.Insert(0, new SelectListItem { Value = "0", Text = "-- Please Select Company --" });

            return(model);
        }
示例#8
0
        public passwordModels GetPassword(string pNoAnggota)
        {
            var    dPass     = new passwordModels();
            string SqlString = @"Select mp.no_anggota,an.nama as nama_anggota, mp.[password], mp.keterangan,
                                        IIF (mp.no_anggota = 'SBY-HLD0025' , 'SSD IT' , an.sektor ) as sektor,
                                        mp.[as_admin],mp.id
                                FROM mPassword as mp INNER JOIN anggota AS an ON mp.no_anggota = an.NoAng
                                where mp.no_anggota = ?";

            string ConnStr = ManageString.GetConnStr();

            try
            {
                using (OleDbConnection conn = new OleDbConnection(ConnStr))
                {
                    conn.Open();
                    using (OleDbCommand cmd = new OleDbCommand(SqlString, conn))
                    {
                        cmd.CommandType = CommandType.Text;
                        cmd.Parameters.AddWithValue("noanggota", pNoAnggota);

                        using (OleDbDataReader aa = cmd.ExecuteReader())
                        {
                            if (aa.HasRows)
                            {
                                //Log.Debug(DateTime.Now + " MASUK HAS ROWS, ID Type : " + aa.GetFieldType(6).ToString());
                                while (aa.Read())
                                {
                                    dPass.no_anggota   = aa.GetString(0);
                                    dPass.nama_anggota = aa.GetString(1);
                                    dPass.password     = aa.GetString(2);
                                    dPass.keterangan   = aa.GetString(3);
                                    dPass.sektor       = aa.GetString(4);
                                    dPass.as_admin     = aa.GetInt16(5);
                                    dPass.id           = aa.GetInt32(6);

                                    //Log.Debug(DateTime.Now + " NO Anggota : " + aa["no_anggota"].ToString() + " ID : " + aa.GetInt32(6));
                                }
                            }
                        }
                    }
                }
            }
            catch (Exception ex)
            {
                Log.Error(DateTime.Now + " GetPasswordREPO ====>>>>>> Kode : " + pNoAnggota, ex);
            }
            return(dPass);
        }
示例#9
0
        public void InsertAllPassword()
        {
            var vListAng = _repoUser.getAllAnggotaList();

            Log.Debug(DateTime.Now + " Get ALL ANGGOTA LIST ====>>>>>> JML: " + vListAng.Count());

            foreach (var item in vListAng)
            {
                var m = new passwordModels();

                m.no_anggota = item.no_anggota;
                m.password   = item.no_anggota.Trim().ToUpper();
                m.keterangan = item.keterangan;

                InsertPassword(m);

                Log.Debug(DateTime.Now + " INSERT Pass SERVICE ==>>> No Anggota : " + item.no_anggota + " Pass : " + item.password);
            }
        }
示例#10
0
        public ActionResult Index()
        {
            if (Request.IsAuthenticated)
            {
                // Redirect to requested URL, or homepage if no previous page requested
                string returnUrl = Request.QueryString["ReturnUrl"];
                if (!String.IsNullOrEmpty(returnUrl))
                {
                    return(Redirect(returnUrl));
                }

                return(RedirectToAction("Index", "Pelanggan"));
            }
            else
            {
                var model = new passwordModels();
                //model = InitiateLoginForm(model);

                return(View(model));
            }
        }
示例#11
0
        public void UpdatePassword(passwordModels pModel)
        {
            string SqlString = @"UPDATE mpassword SET [password] = ?,keterangan = ?
                                 WHERE no_anggota = ?";

            Log.Debug(DateTime.Now + " ======>>>> UPDATE PASS, SQLstr = " + SqlString);

            string ConnStr = ManageString.GetConnStr();

            using (OleDbConnection conn = new OleDbConnection(ConnStr))
            {
                using (OleDbCommand cmd = new OleDbCommand(SqlString, conn))
                {
                    cmd.CommandType = CommandType.Text;
                    cmd.Parameters.AddWithValue("password", pModel.password);
                    cmd.Parameters.AddWithValue("keterangan", pModel.keterangan);
                    cmd.Parameters.AddWithValue("no_anggota", pModel.no_anggota);

                    conn.Open();
                    cmd.ExecuteNonQuery();
                }
            }
        }
示例#12
0
        public List <passwordModels> getAllAnggotaList()
        {
            var    vListUser = new List <passwordModels>();
            string sqlUser   = @"SELECT NoAng,Nama 
                                FROM Anggota as an LEFT JOIN mpassword as mp on an.noang = mp.no_anggota
                                WHERE mp.no_anggota is null";

            string ConnStr = ManageString.GetConnStr();

            using (OleDbConnection conn = new OleDbConnection(ConnStr))
            {
                using (OleDbCommand cmd = new OleDbCommand(sqlUser, conn))
                {
                    cmd.CommandType = CommandType.Text;
                    conn.Open();

                    using (OleDbDataReader aa = cmd.ExecuteReader())
                    {
                        if (aa.HasRows)
                        {
                            while (aa.Read())
                            {
                                //Log.Debug(DateTime.Now + " NO Anggota ====>>>>>> " + aa["NoAng"].ToString());
                                var m = new passwordModels
                                {
                                    no_anggota   = aa.GetString(0),
                                    nama_anggota = aa.GetString(1)
                                };
                                vListUser.Add(m);
                            }
                            //Log.Debug(DateTime.Now + " GetPasswordREPO ====>>>>>> Jumlah Data : " + aa.Count());
                        }
                    }
                }
            }
            return(vListUser);
        }
示例#13
0
        public ActionResult Index(passwordModels model)
        {
            //string message = "";

            //bool isValid = false;
            //object objHasil = null;

            var objResp = new passwordModels();

            try
            {
                //TODO: validate user password, save to session, etc
                string vPassword  = model.password.Trim().ToUpper();
                string no_anggota = model.no_anggota.Trim().ToUpper();

                //Log.Debug(DateTime.Now + "LOGIN CONTROLLER No Anggota : " + no_anggota + ", Password : "******"LOGIN CONTROLLER ==>> ID : " + objResp.id);

                if (objResp.id > 0)
                {
                    var dataLogin = objResp.no_anggota + "#" + objResp.nama_anggota + "#" + objResp.sektor + "#" + objResp.as_admin;

                    Log.Debug(DateTime.Now + " LOGIN No Anggota : " + objResp.id + "/" + no_anggota + ", nama_anggota : " + objResp.nama_anggota + ", Pass User : "******", Pass Data : " + objResp.password + ", As Admin : " + objResp.as_admin);

                    if (vPassword != objResp.password.Trim().ToUpper())
                    {
                        ModelState.AddModelError("", "Password Yang dimasukkan Salah...");
                    }
                }
                else
                {
                    Log.Error("Login Failed, username:"******" Password : "******"", "Login Failed, Invalid Nomer Anggota...");
                }

                if (ModelState.IsValid)
                {
                    int    SessionTime    = 120;
                    string strSessionTime = System.Configuration.ConfigurationManager.AppSettings["SessionTime"];
                    if (!String.IsNullOrEmpty(strSessionTime))
                    {
                        if (!int.TryParse(strSessionTime, out SessionTime))
                        {
                            SessionTime = 120;
                        }
                    }

                    FormsAuthenticationTicket tkt;
                    string     cookiestr;
                    HttpCookie ck;
                    tkt = new FormsAuthenticationTicket(1,
                                                        objResp.no_anggota,
                                                        DateTime.Now,
                                                        DateTime.Now.AddMinutes(SessionTime),
                                                        false,
                                                        objResp.no_anggota + "#" + objResp.nama_anggota + "#" + objResp.sektor + "#" + objResp.as_admin);

                    cookiestr = FormsAuthentication.Encrypt(tkt);

                    ck = new HttpCookie(FormsAuthentication.FormsCookieName, cookiestr);

                    //if (model.RememberMe)
                    //    ck.Expires = tkt.Expiration;

                    ck.Path = FormsAuthentication.FormsCookiePath;
                    Response.Cookies.Add(ck);

                    // Log
                    Log.Info("Login Success, UserCode: " + model.no_anggota);

                    // Redirect to requested URL, or homepage if no previous page requested
                    string returnUrl = Request.QueryString["ReturnUrl"];
                    if (!String.IsNullOrEmpty(returnUrl))
                    {
                        return(Redirect(returnUrl));
                    }

                    return(RedirectToAction("Index", "Pelanggan"));
                }
            }
            catch (Exception ex)
            {
                Log.Error("Login Failed, username:"******"", "Login Failed, Please try Again or Contact Your Administrator.");
            }


            // Re-Initiate
            //model = InitiateLoginForm(model);

            return(View(model));
        }