protected void UserGridView_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
string sqlUser = "";
if (Session["UserPrivilegeId"].ToString() == "0")
{
TextBox txtEUser = (TextBox)UserGridView.Rows[e.RowIndex].FindControl("txtEUser");
sqlUser = "******" + txtEUser.Text + "',";
}
TextBox txtEName = (TextBox)UserGridView.Rows[e.RowIndex].FindControl("txtEName");
DropDownList txtEPrivilege = (DropDownList)UserGridView.Rows[e.RowIndex].FindControl("txtEPrivilege");
TextBox txtECpoint = (TextBox)UserGridView.Rows[e.RowIndex].FindControl("txtECpoint");
string sql = "UPDATE tbl_user SET " + sqlUser + " name='" + txtEName.Text + "',level='" + txtEPrivilege.SelectedValue + "',user_cpoint='" + txtECpoint.Text + "' WHERE id = '" + UserGridView.DataKeys[e.RowIndex].Value + "'";
string script = "";
if (function.MySqlQuery(sql))
{
script = "แก้ไขข้อมูลสำเร็จ";
}
else
{
script = "Error : แก้ไขข้อมูลล้มเหลว";
}
function.Close();
ClientScript.RegisterClientScriptBlock(this.GetType(), "Alert", "alert('" + script + "')", true);
UserGridView.EditIndex = -1;
BindData();
}
protected void btnConfirmPass_Click(object sender, EventArgs e)
{
string script = "";
if (txtNewPass.Text.Trim() == txtConfirmNewPass.Text.Trim() && txtNewPass.Text.Trim() != "" && txtConfirmNewPass.Text.Trim() != "")
{
string sql = "UPDATE tbl_user SET password = '******' WHERE username='******'";
if (function.MySqlQuery(sql))
{
txtNewPass.Text = "";
txtConfirmNewPass.Text = "";
script = "เปลี่ยนรหัสผ่านสำเร็จสำเร็จ<br/>";
}
else
{
script = "เปลี่ยนรหัสผ่านสำเร็จล้มเหลว<br/>";
}
}
else
{
script = "ใส่ข้อมูลไม่ครบถ้วน หรือ รหัสผ่านใหม่ไม่ตรงกัน";
}
function.Close();
ClientScript.RegisterClientScriptBlock(this.GetType(), "Alert", "alert('" + script + "')", true);
}
protected void ComGridView_RowDeleting(object sender, System.Web.UI.WebControls.GridViewDeleteEventArgs e)
{
string sql = "DELETE FROM tbl_claim_com_working WHERE com_working_id = '" + ComGridView.DataKeys[e.RowIndex].Value + "'";
//string script = "";
function.MySqlQuery(sql);
function.Close();
//ClientScript.RegisterClientScriptBlock(this.GetType(), "Alert", "alert('" + script + "')", true);
ComGridView.EditIndex = -1;
BindCom();
}
protected void btnSubmit_Click1(object sender, EventArgs e)
{
string mess = "";
if (txtUser.Text.Trim() == "")
{
mess += "- กรุณาป้อน Username<br/>";
}
if (txtPass.Text.Trim() == "")
{
mess += "- กรุณาป้อน Password<br/>";
}
if (mess == "")
{
string sql = "SELECT * FROM tbl_user WHERE username ='******' AND PASSWORD = '******'";
MySqlDataReader rs = function.MySqlSelect(sql);
if (rs.Read())
{
if (!rs.IsDBNull(0))
{
// Storee Session
Session.Add("User", txtUser.Text);
Session.Add("UserName", rs.GetString("name"));
Session.Add("UserPrivilegeId", rs.GetString("level"));
Session.Add("UserPrivilege", function.GetLevel(int.Parse(rs.GetString("level"))));
Session.Add("UserCpoint", rs.GetString("user_cpoint"));
Session.Timeout = 60 * 24;
//Page.ClientScript.RegisterStartupScript(Page.GetType(), "Message Box", "<script language = 'javascript'>alert('dd')</script>");
Response.Redirect("/");
}
else
{
mess += "- Username หรือ Password ไม่ถูกต้อง";
}
}
else
{
mess += "- Username หรือ Password ไม่ถูกต้อง";
}
rs.Close();
function.Close();
}
if (mess != "")
{
MsgBox(mess);
}
else
{
msgBox.Text = "";
}
}
protected void DeviceGridView_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
TextBox txtEDevice = (TextBox)DeviceGridView.Rows[e.RowIndex].FindControl("txtEDevice");
string sql = "UPDATE tbl_device SET device_name='" + txtEDevice.Text + "' WHERE device_id = '" + DeviceGridView.DataKeys[e.RowIndex].Value + "'";
string script = "";
if (function.MySqlQuery(sql))
{
script = "แก้ไขข้อมูลสำเร็จ";
}
else
{
script = "Error : แก้ไขข้อมูลล้มเหลว";
}
function.Close();
ClientScript.RegisterClientScriptBlock(this.GetType(), "Alert", "alert('" + script + "')", true);
DeviceGridView.EditIndex = -1;
BindData("");
}
protected void btnStatusUpdate_Command(object sender, CommandEventArgs e)
{
cm_id = e.CommandName;
Label1.Text = "#" + cm_id;
string sql = "SELECT * FROM tbl_cm_detail cm JOIN tbl_device d ON cm.cm_detail_driver_id = d.device_id JOIN tbl_cpoint c ON c.cpoint_id=cm.cm_cpoint WHERE cm.cm_detail_id = '" + cm_id + "'";
MySqlDataReader rs = function.MySqlSelect(sql);
if (rs.Read())
{
Label5.Text = rs.GetString("cpoint_name") + " " + rs.GetString("cm_point");
Label2.Text = rs.GetString("cm_detail_channel");
Label3.Text = rs.GetString("device_name");
Label4.Text = rs.GetString("cm_detail_problem");
if (!rs.IsDBNull(8))
{
txtEDate.Text = rs.GetString("cm_detail_edate");
}
else
{
txtEDate.Text = "";
}
if (!rs.IsDBNull(9))
{
txtETime.Text = rs.GetString("cm_detail_etime");
}
else
{
txtETime.Text = DateTime.Now.ToString("HH.mm");
}
if (!rs.IsDBNull(11))
{
txtMethod.Text = rs.GetString("cm_detail_method");
}
else
{
txtMethod.Text = "";
}
if (!rs.IsDBNull(12))
{
txtNote.Text = rs.GetString("cm_detail_note");
}
else
{
txtNote.Text = "";
}
}
rs.Close();
function.Close();
}
private void getStatusAmount(Label label, int status, string year)
{
string sql = "SELECT COUNT(*) AS count_num FROM tbl_claim c JOIN tbl_cpoint ON claim_cpoint = cpoint_id JOIN tbl_status ON status_id = claim_status LEFT JOIN tbl_user ON username = claim_user_start_claim JOIN tbl_status_detail sd ON sd.detail_claim_id = c.claim_id AND sd.detail_status_id = c.claim_status WHERE claim_delete = '0' AND c.claim_status = '" + status + "' AND c.claim_budget_year = '" + year + "'";
MySqlDataReader rs = function.MySqlSelect(sql);
if (rs.Read())
{
label.Text = rs.GetString("count_num") + " รายการ";
}
else
{
label.Text = "0 รายการ";
}
rs.Close();
function.Close();
function.conn.Close();
}
protected void ClaimGridView_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
DropDownList txtStatusEdit = (DropDownList)ClaimGridView.Rows[e.RowIndex].FindControl("txtStatusEdit");
string sql = "UPDATE tbl_claim SET claim_status = '" + txtStatusEdit.SelectedValue + "' WHERE claim_id = '" + ClaimGridView.DataKeys[e.RowIndex].Value + "'";
string script = "";
if (function.MySqlQuery(sql))
{
script = "แก้ไขข้อมูลสำเร็จ";
}
else
{
script = "Error : แก้ไขข้อมูลล้มเหลว";
}
function.Close();
ClientScript.RegisterClientScriptBlock(this.GetType(), "Alert", "alert('" + script + "')", true);
ClaimGridView.EditIndex = -1;
BindData("");
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["user"] == null)
{
Response.Redirect("/");
}
if (!this.IsPostBack)
{
string sql = "";
if (function.CheckLevel("Department", Session["UserPrivilegeId"].ToString()))
{
sql = "SELECT * FROM tbl_cpoint ORDER BY cpoint_id";
function.getListItem(txtCpoint, sql, "cpoint_name", "cpoint_id");
function.getListItem(txtCpointSearch, sql, "cpoint_name", "cpoint_id");
txtCpointSearch.Items.Insert(0, new ListItem("ทั้งหมด", ""));
}
else
{
sql = "SELECT * FROM tbl_cpoint WHERE cpoint_id = '" + Session["UserCpoint"].ToString() + "'";
function.getListItem(txtCpoint, sql, "cpoint_name", "cpoint_id");
function.getListItem(txtCpointSearch, sql, "cpoint_name", "cpoint_id");
//txtCpointSearch.Items.Insert(0, new ListItem("ทั้งหมด", ""));
}
string sql_Device = "SELECT * FROM tbl_device ORDER BY device_name";
function.getListItem(txtDeviceAdd, sql_Device, "device_name", "device_id");
txtDeviceAdd.Items.Insert(0, new ListItem("", ""));
txtSTime.Text = DateTime.Now.ToString("HH.mm");
BindData("");
if (Request["ref"] != null)
{
txtRef.Value = Request["ref"].ToString();
sql = "SELECT * FROM tbl_cm_detail WHERE cm_detail_id = '" + txtRef.Value + "'";
MySqlDataReader rs = function.MySqlSelect(sql);
if (rs.Read())
{
txtCpoint.SelectedValue = rs.GetString("cm_cpoint");
txtPoint.Text = rs.GetString("cm_point");
txtChannel.Text = rs.GetString("cm_detail_channel");
txtSDate.Text = rs.GetString("cm_detail_sdate");
txtSTime.Text = rs.GetString("cm_detail_stime");
txtDeviceAdd.SelectedValue = rs.GetString("cm_detail_driver_id");
txtProblem.Text = rs.GetString("cm_detail_problem");
txtNote.Text = rs.GetString("cm_detail_note");
}
rs.Close();
function.Close();
btnSaveCM.Visible = false;
btnEditCM.Visible = true;
btnCancelCM.Visible = true;
if (function.CheckLevel("Techno", Session["UserPrivilegeId"].ToString()))
{
btnDeleteCM.Visible = true;
}
else
{
btnDeleteCM.Visible = false;
}
}
else
{
btnSaveCM.Visible = true;
btnEditCM.Visible = false;
btnCancelCM.Visible = false;
btnDeleteCM.Visible = false;
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["User"] != null)
{
if (Session["UserCpoint"].ToString() != "0")
{
Response.Redirect("/Claim/claimForm");
}
if (!this.IsPostBack)
{
if (txtDateOrder.Text == "")
{
txtDateOrder.Text = DateTime.Now.ToString("dd-MM-") + (DateTime.Now.Year + 543);
}
if (txtDateSendOrder.Text == "")
{
txtDateSendOrder.Text = DateTime.Now.ToString("dd-MM-") + (DateTime.Now.Year + 543);
txtDateSendOrder_TextChanged(null, null);
}
PageLoadData();
string sql = "SELECT * FROM tbl_company ORDER BY company_name";
function.getListItem(txtCompany, sql, "company_name", "company_id");
//lbTitle.Text = Session["codePK"].ToString();
sql = "SELECT * FROM tbl_quotations q JOIN tbl_company c ON q.quotations_company_id = c.company_id WHERE q.quotations_claim_id = '" + Session["codePK"].ToString() + "' AND quotations_delete = '0'";
function.getListItem(txtCompanyOrder, sql, "company_name", "company_id");
}
if (int.Parse(Session["status_id"].ToString()) >= 3)
{
if (int.Parse(Session["status_id"].ToString()) != 3)
{
btnSaveNoteTo.Visible = false;
}
string[] readText = File.ReadAllLines(HostingEnvironment.MapPath("/Config/") + "ListDocTechno.txt");
int num = 1;
foreach (string s in readText)
{
if (num != 7)
{
AddControls(num, num + ". " + s + " จำนวน", Panel1);
}
else
{
AddControls(num, num + ". " + s + " " + function.GetSelectValue("tbl_claim_com", "claim_id='" + Session["codePK"].ToString() + "'", "claim_detail_insurer") + " จำนวน", Panel1);
}
num++;
}
string sql_doc = "SELECT * FROM tbl_quotations q JOIN tbl_company c ON c.company_id = q.quotations_company_id WHERE q.quotations_claim_id = '" + Session["codePK"].ToString() + "'";
MySqlDataReader rs = function.MySqlSelect(sql_doc);
while (rs.Read())
{
AddControls(num, num + ". ใบประเมินราคาค่าเสียหาย ของ " + rs.GetString("company_name") + " จำนวน", Panel1);
num++;
}
rs.Close();
function.Close();
if (!this.IsPostBack)
{
getDataStatus3();
}
}
if (int.Parse(Session["status_id"].ToString()) >= 4)
{
getDataStatus4();
}
if (int.Parse(Session["status_id"].ToString()) >= 5)
{
getDataStatus5();
}
}
}