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