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); }
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); } } } }
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); }
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); }
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 })); }
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)); }
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); }
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); }
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); } }
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)); } }
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(); } } }
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); }
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)); }