private void SaveData()
{
GeneralDAL _dal = null;
Hashtable _ht = null;
try
{
_dal = new GeneralDAL();
_ht = new Hashtable();
MPF23.Shared.Mapper.UIToDB.Map(this.Controls, _ht);
Shared.ApplyDefaultProp(_ht);
if (Request.Params["action"].Equals("add"))
{
_dal.Insert(TABLE_NAME, _ht);
}
else
{
_dal.Update(TABLE_NAME, _ht);
}
Shared.ShowSuccessGritter(this, string.Format("masterwidget.aspx?action=edit&code={0}", txtWidgetCode.Text));
}
catch (Exception ex)
{
Shared.ShowErrorDialog(this, ex);
}
}
private void SaveData()
{
GeneralDAL _dal = null;
Hashtable _ht = null;
int iNextID = 0;
try
{
_dal = new GeneralDAL();
_ht = new Hashtable();
MPF23.Shared.Mapper.UIToDB.Map(this.Controls, _ht);
Shared.ApplyDefaultProp(_ht);
_ht["p_id"] = txtId.Text;
Shared.ApplyDefaultProp(_ht);
if (Request.Params["action"].Equals("add"))
{
_dal.Insert(TABLE_NAME, _ht, ref iNextID);
txtId.Text = iNextID.ToString() ;
}
else
_dal.Update(TABLE_NAME, _ht);
Shared.ShowSuccessGritter(this, string.Format("employeenotification.aspx?action=edit&id={0}", txtId.Text));
}
catch (Exception ex)
{
Shared.ShowErrorDialog(this, ex);
}
}
private void SaveData()
{
GeneralDAL _dal = null;
Hashtable _ht = null;
string sNextEmpCode = string.Empty;
try
{
_dal = new GeneralDAL();
_ht = new Hashtable();
MPF23.Shared.Mapper.UIToDB.Map(this.Controls, _ht);
Shared.ApplyDefaultProp(_ht);
_ht["branch_code"] = Request.Params["branch_code"];
if (Request.Params["action"].Equals("add"))
{
_dal.Insert(TABLE_NAME, _ht, ref sNextEmpCode);
txtEmployeeCode.Text = sNextEmpCode;
}
else
{
_dal.Update(TABLE_NAME, _ht);
}
Shared.ShowSuccessGritter(this, string.Format("employeebranch.aspx?action=edit&emp_code={0}&branch_code={1} ", txtEmployeeCode.Text, txtBranchCode.Text));
}
catch (Exception ex)
{
Shared.ShowErrorDialog(this, ex);
}
}
private void SaveData()
{
GeneralDAL _dal = null;
Hashtable _ht = null;
int inextId = 0;
try
{
_dal = new GeneralDAL();
_ht = new Hashtable();
MPF23.Shared.Mapper.UIToDB.Map(this.Controls, _ht);
Shared.ApplyDefaultProp(_ht);
_ht["p_code_question"] = txtCode.Text;
if (Request.Params["action"].Equals("add"))
{
_dal.Insert(TABLE_NAME, _ht, ref inextId);
txtId.Text = inextId.ToString();
}
else
{
_dal.Update(TABLE_NAME, _ht);
}
Shared.ShowSuccessGritter(this, string.Format("masterquestionchoice.aspx?action=edit&code={0}&id={1}", txtCode.Text, txtId.Text));
}
catch (Exception ex)
{
Shared.ShowErrorDialog(this, ex);
}
}
private void SaveData()
{
GeneralDAL _dal = null;
Hashtable _ht = null;
try
{
_dal = new GeneralDAL();
_ht = new Hashtable();
MPF23.Shared.Mapper.UIToDB.Map(upd.Controls, _ht);
Shared.ApplyDefaultProp(_ht);
_ht["p_application_no"] = txtApplicationNoCustomer.Text;
Shared.ApplyDefaultProp(_ht);
if (Request.Params["action"].Equals("add"))
{
_dal.Insert(TABLE_NAME, _ht);
}
else
{
_dal.Update(TABLE_NAME, _ht);
}
Shared.ShowSuccessGritter(this, string.Format("applicationcustomer.aspx?action=edit&app_no={0}", txtApplicationNoCustomer.Text));
}
catch (Exception ex)
{
Shared.ShowErrorDialog(this, ex);
}
}
private void SaveDataCollection()
{
GeneralDAL _dal = null;
Hashtable _ht = null;
try
{
_dal = new GeneralDAL();
_ht = new Hashtable();
MPF23.Shared.Mapper.UIToDB.Map(this.Controls, _ht);
Shared.ApplyDefaultProp(_ht);
_ht["p_trx_no"] = lblTrxNo.Text;
Shared.ApplyDefaultProp(_ht);
if (Request.Params["action"].Equals("add"))
{
_dal.Insert(TABLE_NAME_MAIN, _ht);
}
else
{
_dal.Update(TABLE_NAME_MAIN, _ht);
}
Shared.ShowSuccessGritter(this, string.Format("collectionmain.aspx?action=edit&trxNo={0}", lblTrxNo.Text));
}
catch (Exception ex)
{
Shared.ShowErrorDialog(this, ex);
}
}
private void SaveData()
{
GeneralDAL _dal = null;
Hashtable _ht = null;
int inextId = 0;
try
{
_dal = new GeneralDAL();
_ht = new Hashtable();
MPF23.Shared.Mapper.UIToDB.Map(this.Controls, _ht);
Shared.ApplyDefaultProp(_ht);
_ht["p_id"] = Request.Params["id"];
if (Request.Params["action"].Equals("add"))
{
_dal.Insert(TABLE_NAME_RESULTS, _ht, ref inextId);
//txtID.Text = inextId.ToString();
}
else
{
_dal.Update(TABLE_NAME_RESULTS, _ht);
}
Shared.ShowSuccessGritter(this, string.Format("collectionresults.aspx?action=edit&id={0}", int.Parse(Request.Params["id"])));
}
catch (Exception ex)
{
Shared.ShowErrorDialog(this, ex);
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
List <string> listItem = new List <string>();
string errorRow = "";
string errorCif = "";
GeneralDAL _dal = null;
Hashtable _ht = null;
if (FileUploadControl.HasFile)
{
string fileExt = System.IO.Path.GetExtension(FileUploadControl.FileName);
if (fileExt == ".etlerr" || fileExt == ".log")
{
StreamReader reader = new StreamReader(FileUploadControl.FileContent);
do
{
listItem.Add(reader.ReadLine());
} while (reader.Peek() != -1);
reader.Close();
foreach (string item in listItem)
{
if (item.Split('|')[0] == "RECORD")
{
errorRow = item.Split('|')[1];
errorCif = item.Split('|')[2];
try
{
_dal = new GeneralDAL();
_ht = new Hashtable();
//var date = Convert.ToDateTime(txtStartdate.Text);
_ht["p_row_number"] = errorRow;
_ht["p_dateMonth"] = ddlBulan.SelectedItem.Value;
_ht["p_dateYear"] = ddlTahun.SelectedItem.Value;
_ht["p_cif"] = errorCif;
_dal.Update(Request.Params["table"], _ht);
string script = Shared.GenerateLookUpClearString(ClientQueryString);
ScriptManager.RegisterStartupScript(this, GetType(), "fn2", script, true);
}
catch (Exception ex)
{
lblError.Text = ex.Message;
}
}
}
}
else
{
lblError.Text = "Only .txt files allowed!";
}
}
else
{
lblError.Text = "You have not specified a file.";
}
}
protected bool SaveData(DataTable dtParam)
{
bool issuccess = true;
string xsp = string.Empty;
DataTable dt = null;
GeneralDAL _dal = null;
Hashtable _ht = null;
SqlConnection conn = new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["ConnectionString"]);
try
{
dt = dtParam;
using (var command = new SqlCommand("xsp_" + Request.Params["table"] + "_insert")
{
CommandType = CommandType.StoredProcedure
})
{
command.Parameters.Add(new SqlParameter("@dt", dt));
command.Connection = conn;
conn.Open();
command.ExecuteNonQuery();
conn.Close();
}
_dal = new GeneralDAL();
_ht = new Hashtable();
_ht["p_tahun"] = ddlBulan.SelectedItem.Text;
_ht["p_bulan"] = ddlBulan.SelectedItem.Text;
_ht["p_code_segmen"] = Request.Params["code"]; //;
_ht["p_jumlah_data_file"] = dt.Rows.Count;
_ht["p_jumlah_data_segmen"] = dt.Rows.Count;
_ht["p_cre_ip"] = Shared.CurrentIPAddress;
_ht["p_cre_by"] = Shared.CurrentUID;
_ht["p_cre_date"] = DateTime.Now;
_ht["p_mod_date"] = DateTime.Now;
_ht["p_mod_ip"] = Shared.CurrentIPAddress;
_ht["p_mod_by"] = Shared.CurrentUID;
_dal.Update(TABLE_HEADER, _ht);
}
catch (Exception ex)
{
Message(ex.Message);
xsp = string.Empty;
issuccess = false;
conn.Close();
}
return(issuccess);
}
private void SaveData()
{
GeneralDAL _dal = null;
Hashtable _ht = null;
try
{
_dal = new GeneralDAL();
_ht = new Hashtable();
MPF23.Shared.Mapper.UIToDB.Map(this.Controls, _ht);
//Shared.ApplyDefaultProp(_ht);
_dal.Update(TABLE_NAME, _ht, "row");
Shared.ShowSuccessGritter(this, string.Format("fasilitaskredit.aspx?action=edit&cif={0}&no_akad_awal={1}&no_rekening_fasilitas={2}&date={3}", txtCIF.Text, txtNO_AKAD_AWAL.Text, txtNO_REKENING_FASILITAS.Text, lblcredate.Text));
}
catch (Exception ex)
{
Shared.ShowErrorDialog(this, ex);
}
}
private void SaveData()
{
GeneralDAL _dal = null;
Hashtable _ht = null;
try
{
_dal = new GeneralDAL();
_ht = new Hashtable();
MPF23.Shared.Mapper.UIToDB.Map(this.Controls, _ht);
//Shared.ApplyDefaultProp(_ht);
_dal.Update(TABLE_NAME, _ht, "row");
Shared.ShowSuccessGritter(this, string.Format("badanusaha.aspx?action=edit&cif={0}&nomor_identitas={1}&cre_date={2}&nama_badan_usaha={3}", txtCIF.Text, txtNOMOR_IDENTITAS.Text, lblcredate.Text, txtNAMA_BADAN_USAHA.Text));
}
catch (Exception ex)
{
Shared.ShowErrorDialog(this, ex);
}
}
private void SaveData()
{
GeneralDAL _dal = null;
Hashtable _ht = null;
try
{
_dal = new GeneralDAL();
_ht = new Hashtable();
MPF23.Shared.Mapper.UIToDB.Map(this.Controls, _ht);
//Shared.ApplyDefaultProp(_ht);
_dal.Update(TABLE_NAME, _ht, "row");
Shared.ShowSuccessGritter(this, string.Format("penjamin.aspx?action=edit&cif={0}&no_identitas_penjamin={1}&no_rekening={2}&date={3}", txtCIF.Text, txtNO_IDENTITAS_PENJAMIN.Text, txtNO_REKENING.Text, txtCRE_DATE.Text));
}
catch (Exception ex)
{
Shared.ShowErrorDialog(this, ex);
}
}
private void SaveData()
{
GeneralDAL _dal = null;
Hashtable _ht = null;
try
{
_dal = new GeneralDAL();
_ht = new Hashtable();
MPF23.Shared.Mapper.UIToDB.Map(this.Controls, _ht);
//Shared.ApplyDefaultProp(_ht);
_dal.Update(TABLE_NAME, _ht, "row");
Shared.ShowSuccessGritter(this, string.Format("individual.aspx?action=edit&cif={0}&nik={1}&nama={2}&date={3}", txtCIF.Text, txtNIK.Text, txtNama.Text, lblcredate.Text));
}
catch (Exception ex)
{
Shared.ShowErrorDialog(this, ex);
}
}
//protected void Page_Load(object sender, EventArgs e)
//{
// dataBranch();
// //LoadInit();
// if (!Page.IsPostBack)
// {
// //if (Request.Params["action"].Equals("edit"))
// // {
// //LoadData();
// // btnCancel.Text = "<i class='icon-remove'></i>Back";
// //}
// }
//}
//private void dataBranch()
//{
// try
// {
// string constr = ConfigurationManager.ConnectionStrings["Test1"].ToString(); // connection string
// SqlConnection con = new SqlConnection(constr);
// con.Open();
// SqlCommand com = new SqlCommand("select * from Branch", con); // table name
// SqlDataAdapter da = new SqlDataAdapter(com);
// DataSet ds = new DataSet();
// da.Fill(ds); // fill dataset
// txtBRANCH.DataTextField = ds.Tables[0].Columns["BranchFullName"].ToString(); // text field name of table dispalyed in dropdown
// txtBRANCH.DataValueField = ds.Tables[0].Columns["BranchID"].ToString(); // to retrive specific textfield name
// txtBRANCH.DataSource = ds.Tables[0]; //assigning datasource to the dropdownlist
// txtBRANCH.DataBind(); //binding
// con.Close();
// }
// catch (Exception err)
// {
// }
//}
protected void btnSignIn_Click(object sender, EventArgs e)
{
//HttpCookie cookie = new HttpCookie("CurrentLanguage");
//cookie.Value = ddlLanguage.SelectedValue;
//Response.SetCookie(cookie);
/*
* validate user
* if row > 0, maka ambil role user tersebut
* redirect ke main.aspx
* jika tidak, show error
*/
GeneralDAL _dal = null;
Hashtable _ht = null;
bool IsValidUser = true;
bool IsValidPassword = true;
bool IsActiveUser = true;
string UID = "";
try
{
_dal = new GeneralDAL();
_ht = new Hashtable();
_ht["p_uid"] = txtUID.Text;
_ht["p_password"] = txtPassword.Text;
DataRow dr = _dal.GetRow("", "xsp_master_user_main_validate", _ht);
//dr null jika tidak ada record, langsung lari ke catch
if (dr != null)
{
UID = dr["ID"].ToString();
if (dr["UPASS"].ToString().Equals(dr["UPASSMD5"].ToString()))
{
//Masukan Role disini
//if (dr["p_uid"].ToString() == "ADM000")
//{
// Response.Redirect("/module/finance/agunan.aspx");
//}
if (((int)dr["LAST_FAIL_COUNT"]) >= 5)
{
IsValidPassword = false;
}
else
{
if (dr["IS_ACTIVE"].ToString().Equals("1")) //artinya user aktif
{
//reset fail count
_ht["p_uid"] = UID;
_dal.Update("", "xsp_master_user_main_reset_fail_count", _ht);
//update last login
_ht["p_uid"] = UID;
_ht["p_login_date"] = DateTime.Now;
_dal.Update("", "xsp_master_user_main_update_last_login", _ht);
//save user profile ke session
Session[SessionKey.CURRENT_USER_SESSION_KEY] = dr;
//save user role ke session
Session[SessionKey.CURRENT_USER_ROLE_SESSION_KEY] = _dal.GetRows("", "xsp_master_user_main_getroles", _ht);
//save user ip address
if (Request.ServerVariables["HTTP_X_FORWARDED_FOR"] == null)
{
Session[SessionKey.CURRENT_USER_IP_ADDRESS_SESSION_KEY] = Request.ServerVariables["REMOTE_ADDR"];
}
else
{
Session[SessionKey.CURRENT_USER_IP_ADDRESS_SESSION_KEY] = Request.ServerVariables["HTTP_X_FORWARDED_FOR"];
}
//insert master user login log
_ht["p_uid"] = UID;
_ht["p_ip_address"] = Shared.CurrentIPAddress;
_ht["p_flag_code"] = "SUCCESS";
Shared.ApplyDefaultProp(_ht);
_dal.Insert("", "xsp_master_user_login_log_insert", _ht);
if (((DateTime)dr["NEXT_CHANGE_PASS"]) <= DateTime.Now)
{
ScriptManager.RegisterStartupScript(this, GetType(), "fx", "fnShowModalChangePassword();", true);;
}
else
{
//redirect ke halaman main
//Response.Redirect("main.aspx");
//Masukan Role disini
if (dr["ID"].ToString() == "ADM000")
{
Response.Redirect("branch/main_000.aspx");
}
else if (dr["ID"].ToString() == "1000000003")
{
Response.Redirect("main.aspx");
}
else if (dr["ID"].ToString() == "ADM001")
{
Response.Redirect("branch/main_001.aspx");
}
else if (dr["ID"].ToString() == "ADM002")
{
Response.Redirect("branch/main_002.aspx");
}
else if (dr["ID"].ToString() == "ADM004")
{
Response.Redirect("branch/main_004.aspx");
}
else if (dr["ID"].ToString() == "ADM005")
{
Response.Redirect("branch/main_005.aspx");
}
else if (dr["ID"].ToString() == "ADM006")
{
Response.Redirect("branch/main_006.aspx");
}
else if (dr["ID"].ToString() == "ADM007")
{
Response.Redirect("branch/main_007.aspx");
}
else if (dr["ID"].ToString() == "ADM008")
{
Response.Redirect("branch/main_008.aspx");
}
else if (dr["ID"].ToString() == "ADM009")
{
Response.Redirect("branch/main_009.aspx");
}
else if (dr["ID"].ToString() == "ADM010")
{
Response.Redirect("branch/main_010.aspx");
}
else if (dr["ID"].ToString() == "ADM011")
{
Response.Redirect("branch/main_011.aspx");
}
else if (dr["ID"].ToString() == "ADM012")
{
Response.Redirect("branch/main_012.aspx");
}
else if (dr["ID"].ToString() == "ADM013")
{
Response.Redirect("branch/main_013.aspx");
}
else if (dr["ID"].ToString() == "ADM014")
{
Response.Redirect("branch/main_014.aspx");
}
else if (dr["ID"].ToString() == "ADM015")
{
Response.Redirect("branch/main_015.aspx");
}
else if (dr["ID"].ToString() == "ADM016")
{
Response.Redirect("branch/main_016.aspx");
}
else if (dr["ID"].ToString() == "ADM017")
{
Response.Redirect("branch/main_017.aspx");
}
else if (dr["ID"].ToString() == "ADM018")
{
Response.Redirect("branch/main_018.aspx");
}
else if (dr["ID"].ToString() == "ADM019")
{
Response.Redirect("branch/main_019.aspx");
}
else if (dr["ID"].ToString() == "ADM020")
{
Response.Redirect("branch/main_020.aspx");
}
else if (dr["ID"].ToString() == "ADM021")
{
Response.Redirect("branch/main_021.aspx");
}
else if (dr["ID"].ToString() == "ADM022")
{
Response.Redirect("branch/main_022.aspx");
}
else if (dr["ID"].ToString() == "ADM023")
{
Response.Redirect("branch/main_023.aspx");
}
else if (dr["ID"].ToString() == "ADM024")
{
Response.Redirect("branch/main_024.aspx");
}
else if (dr["ID"].ToString() == "ADM025")
{
Response.Redirect("branch/main_025.aspx");
}
else if (dr["ID"].ToString() == "ADM026")
{
Response.Redirect("branch/main_026.aspx");
}
else if (dr["ID"].ToString() == "ADM027")
{
Response.Redirect("branch/main_027.aspx");
}
else if (dr["ID"].ToString() == "ADM028")
{
Response.Redirect("branch/main_028.aspx");
}
else if (dr["ID"].ToString() == "ADM029")
{
Response.Redirect("branch/main_029.aspx");
}
else if (dr["ID"].ToString() == "ADM030")
{
Response.Redirect("branch/main_030.aspx");
}
else if (dr["ID"].ToString() == "ADM031")
{
Response.Redirect("branch/main_031.aspx");
}
else if (dr["ID"].ToString() == "ADM032")
{
Response.Redirect("branch/main_032.aspx");
}
else if (dr["ID"].ToString() == "ADM033")
{
Response.Redirect("branch/main_033.aspx");
}
else if (dr["ID"].ToString() == "ADM034")
{
Response.Redirect("branch/main_034.aspx");
}
else if (dr["ID"].ToString() == "ADM035")
{
Response.Redirect("branch/main_035.aspx");
}
else if (dr["ID"].ToString() == "ADM036")
{
Response.Redirect("branch/main_036.aspx");
}
else if (dr["ID"].ToString() == "ADM037")
{
Response.Redirect("branch/main_037.aspx");
}
else if (dr["ID"].ToString() == "ADM038")
{
Response.Redirect("branch/main_038.aspx");
}
else if (dr["ID"].ToString() == "ADM039")
{
Response.Redirect("branch/main_039.aspx");
}
else if (dr["ID"].ToString() == "ADM040")
{
Response.Redirect("branch/main_040.aspx");
}
else if (dr["ID"].ToString() == "ADM041")
{
Response.Redirect("branch/main_041.aspx");
}
else if (dr["ID"].ToString() == "ADM042")
{
Response.Redirect("branch/main_042.aspx");
}
else if (dr["ID"].ToString() == "ADM043")
{
Response.Redirect("branch/main_043.aspx");
}
else if (dr["ID"].ToString() == "ADM044")
{
Response.Redirect("branch/main_044.aspx");
}
else if (dr["ID"].ToString() == "ADM045")
{
Response.Redirect("branch/main_045.aspx");
}
else if (dr["ID"].ToString() == "ADM046")
{
Response.Redirect("branch/main_046.aspx");
}
else if (dr["ID"].ToString() == "ADM047")
{
Response.Redirect("branch/main_047.aspx");
}
else if (dr["ID"].ToString() == "ADM048")
{
Response.Redirect("branch/main_048.aspx");
}
else if (dr["ID"].ToString() == "ADM049")
{
Response.Redirect("branch/main_049.aspx");
}
else if (dr["ID"].ToString() == "ADM050")
{
Response.Redirect("branch/main_050.aspx");
}
else if (dr["ID"].ToString() == "ADM051")
{
Response.Redirect("branch/main_051.aspx");
}
else if (dr["ID"].ToString() == "ADM052")
{
Response.Redirect("branch/main_052.aspx");
}
else if (dr["ID"].ToString() == "ADM053")
{
Response.Redirect("branch/main_053.aspx");
}
else if (dr["ID"].ToString() == "ADM054")
{
Response.Redirect("branch/main_054.aspx");
}
else if (dr["ID"].ToString() == "ADM055")
{
Response.Redirect("branch/main_055.aspx");
}
else if (dr["ID"].ToString() == "ADM056")
{
Response.Redirect("branch/main_056.aspx");
}
else if (dr["ID"].ToString() == "ADM057")
{
Response.Redirect("branch/main_057.aspx");
}
else if (dr["ID"].ToString() == "ADM058")
{
Response.Redirect("branch/main_058.aspx");
}
else if (dr["ID"].ToString() == "ADM059")
{
Response.Redirect("branch/main_059.aspx");
}
else if (dr["ID"].ToString() == "ADM060")
{
Response.Redirect("branch/main_060.aspx");
}
else if (dr["ID"].ToString() == "ADM061")
{
Response.Redirect("branch/main_061.aspx");
}
else if (dr["ID"].ToString() == "ADM062")
{
Response.Redirect("branch/main_062.aspx");
}
else if (dr["ID"].ToString() == "ADM063")
{
Response.Redirect("branch/main_063.aspx");
}
else if (dr["ID"].ToString() == "ADM064")
{
Response.Redirect("branch/main_064.aspx");
}
else if (dr["ID"].ToString() == "ADM065")
{
Response.Redirect("branch/main_065.aspx");
}
else if (dr["ID"].ToString() == "ADM066")
{
Response.Redirect("branch/main_066.aspx");
}
else if (dr["ID"].ToString() == "ADM067")
{
Response.Redirect("branch/main_067.aspx");
}
else if (dr["ID"].ToString() == "ADM068")
{
Response.Redirect("branch/main_068.aspx");
}
else if (dr["ID"].ToString() == "ADM069")
{
Response.Redirect("branch/main_069.aspx");
}
else if (dr["ID"].ToString() == "ADM070")
{
Response.Redirect("branch/main_070.aspx");
}
else if (dr["ID"].ToString() == "ADM071")
{
Response.Redirect("branch/main_071.aspx");
}
else if (dr["ID"].ToString() == "ADM072")
{
Response.Redirect("branch/main_072.aspx");
}
else if (dr["ID"].ToString() == "ADM073")
{
Response.Redirect("branch/main_073.aspx");
}
else if (dr["ID"].ToString() == "ADM0900")
{
Response.Redirect("branch/main_0900.aspx");
}
}
}
else
{
IsActiveUser = false;
}
}
}
else
{
IsValidPassword = false;
}
}
else
{
IsValidUser = false;
}
}
catch
{
IsValidUser = false;
}
if (!IsActiveUser)
{
//show ke user message box, jika user dia tidak aktif
ScriptManager.RegisterStartupScript(this, GetType(), "fx", "fnShowErrorNotif('User not active. Please contact your MIS/IT Department.', '');", true);
}
else if (!IsValidPassword)
{
//cek last fail count untuk uid yang login
_dal = new GeneralDAL();
_ht = new Hashtable();
_ht["p_id"] = UID;
DataRow dr = _dal.GetRow("", "xsp_master_user_main_getrow", _ht);
_ht["p_login_date"] = DateTime.Now;
_ht["p_cre_date"] = DateTime.Now;
_ht["p_cre_by"] = txtUID.Text;
_ht["p_cre_ip_address"] = "127.0.0.1";
if (Request.ServerVariables["HTTP_X_FORWARDED_FOR"] == null)
{
_ht["p_ip_address"] = Request.ServerVariables["REMOTE_ADDR"];
}
else
{
_ht["p_ip_address"] = Request.ServerVariables["HTTP_X_FORWARDED_FOR"];
}
if (((int)dr["LAST_FAIL_COUNT"]) >= 5)
{
_ht["p_flag_code"] = "FAIL MAX ATTEMPT";
_ht["p_uid"] = UID;
//insert master user login log
_dal.Insert("", "xsp_master_user_login_log_insert", _ht);
//show warning max login attempt reached
ScriptManager.RegisterStartupScript(this, GetType(), "fx", "fnShowErrorNotif('Maximum try login reached. Please contact your MIS/IT Department.', '');", true);
}
else // jika uid tersebut tidak ada berarti invalid user, langsung di catch
{
_ht["p_flag_code"] = "FAIL PASSWORD";
_ht["p_uid"] = UID;
_ht["p_mod_date"] = DateTime.Now.ToString("yyyy-MM-dd");
_ht["p_mod_by"] = txtUID.Text;
_ht["p_mod_ip_address"] = "127.0.0.1";
//insert master user login log
try
{
_dal.Insert("", "xsp_master_user_login_log_insert", _ht);
//update last fail count -> ditambahkan 1
_dal.Update("", "xsp_master_user_main_increment_fail_count", _ht);
ScriptManager.RegisterStartupScript(this, GetType(), "fx", "fnShowErrorNotif('Invalid password', '');", true);
}
catch (Exception exp)
{
string error = exp.Message;
}
}
}
else if (!IsValidUser)
{
ScriptManager.RegisterStartupScript(this, GetType(), "fx", "fnShowErrorNotif('Invalid user', '');", true);
}
}