/*******************************************************************************************************************************************************************************
**************************************************** Check Data Function ********************************************************
**************************************************** ********************************************************
*******************************************************************************************************************************************************************************/
private void _CheckAgent()
{
Agents cag = new Agents_Manager().getAgentByIdCard(Agent_idcard_TBx.Text);
if (cag.Agent_id != null)
{
_GetAgent(cag);
Session["chk_agent"] = cag;
Alert_Warning_Panel.Visible = false;
Alert_Success_Panel.Visible = false;
}
else
{
Session.Remove("chk_agent");
Alert_Warning_Panel.Visible = true;
Alert_Success_Panel.Visible = false;
Alert_Id_Card_Lbl.Text = "ไม่พบเลขบัตรประชาชน " + Agent_idcard_TBx.Text + " นี้ในระบบข้อมูลนายหน้า";
Agent_idcard_TBx.Focus();
_ClearAgent();
}
}
private void _GetAgent()
{
string idcard = Agent_Idcard_TBx.Text;
string fname = Agent_Fname_TBx.Text;
string lname = Agent_Lname_TBx.Text;
dlr_mng = new Agents_Manager();
if (!string.IsNullOrEmpty(idcard) || !string.IsNullOrEmpty(fname) || !string.IsNullOrEmpty(lname))
{
List <Agents> list_dlr_all = dlr_mng.getAgents(idcard, fname, lname, 0, 0);
int row = list_dlr_all.Count;
_pageCount(row);
List <Agents> list_dlr = dlr_mng.getAgents(idcard, fname, lname, 0, 20);
Session["idcard"] = idcard;
Session["fname"] = fname;
Session["lname"] = lname;
Session["row_str"] = 0;
Session["List_Agents"] = list_dlr;
}
}
/*******************************************************************************************************************************************************************************
**************************************************** Check Data Function ********************************************************
**************************************************** ********************************************************
*******************************************************************************************************************************************************************************/
private void _CheckAgent()
{
Agents cag = new Agents_Manager().getAgentByIdCard(Agent_idcard_TBx.Text);
Customers ctm = (Customers)Session["Customer_Leasing"];
if (ctm.Cust_Idcard == Agent_idcard_TBx.Text)
{
Session.Remove("chk_agent_leasing");
Alert_Danger_Panel.Visible = true;
alert_header_danger_Lbl.Text = "เลขบัตรประชาชนซ้ำ";
alert_danger_Lbl.Text = "เลขบัตรประชาชน " + Agent_idcard_TBx.Text + " ของนายหน้านี้ ไม่สามารถใช้งานได้ เนื่องจากตรงกับผู้ทำสัญญา";
Agent_Add_Save_Btn.Visible = false;
}
else
{
Alert_Danger_Panel.Visible = false;
Agent_Add_Save_Btn.Visible = true;
if (cag.Agent_id != null)
{
_GetAgent(cag);
Session["chk_agent_leasing"] = cag;
Alert_Warning_Panel.Visible = false;
}
else
{
Session.Remove("chk_agent_leasing");
Alert_Danger_Panel.Visible = false;
Alert_Id_Card_Lbl.Text = "ไม่พบเลขบัตรประชาชน " + Agent_idcard_TBx.Text + " นี้ในระบบข้อมูลนายหน้า";
Agent_idcard_TBx.Focus();
_ClearAgent();
}
}
}
private void _getMoreAgent(int current_page)
{
string idcard = (string)Session["idcard"];
string fname = (string)Session["fname"];
string lname = (string)Session["lname"];
if (current_page > 1)
{
int row_str = (current_page - 1) * 20;
link_Previous.Enabled = true;
dlr_mng = new Agents_Manager();
List <Agents> list_dlr = dlr_mng.getAgents(idcard, fname, lname, row_str, 20);
Session["row_str"] = row_str;
Session["List_Agents"] = list_dlr;
}
else
{
link_Previous.Enabled = false;
List <Agents> list_dlr = dlr_mng.getAgents(idcard, fname, lname, 0, 20);
Session["row_str"] = 0;
Session["List_Agents"] = list_dlr;
}
int max_page = (int)Session["max_page"];
if (current_page == max_page)
{
link_Next.Enabled = false;
}
}
/*******************************************************************************************************************************************************************************
**************************************************** Add Data Function ********************************************************
**************************************************** ********************************************************
*******************************************************************************************************************************************************************************/
private void _AddAgent()
{
Agents_Manager cag_mng = new Agents_Manager();
Agents cag = new Agents();
bool past_page = false;
if (Session["chk_agent"] != null)
{
Agents cag_tmp = (Agents)Session["chk_agent"];
cag.Agent_id = cag_mng.generateAgentID();
cag.Agent_Fname = string.IsNullOrEmpty(Agent_fname_TBx.Text) ? "" : Agent_fname_TBx.Text;
cag.Agent_Lname = string.IsNullOrEmpty(Agent_lname_TBx.Text) ? "" : Agent_lname_TBx.Text;
cag.Agent_Idcard = string.IsNullOrEmpty(Agent_idcard_TBx.Text) ? "" : Agent_idcard_TBx.Text;
cag.Agent_Address_no = string.IsNullOrEmpty(Agent_address_no_TBx.Text) ? "" : Agent_address_no_TBx.Text;
cag.Agent_Vilage = string.IsNullOrEmpty(Agent_vilage_TBx.Text) ? "บ.-" : "บ." + Agent_vilage_TBx.Text;
cag.Agent_Vilage_no = string.IsNullOrEmpty(Agent_vilage_no_TBx.Text) ? "ม.-" : "ม." + Agent_vilage_no_TBx.Text;
cag.Agent_Alley = string.IsNullOrEmpty(Agent_alley_TBx.Text) ? "ซ.-" : "ซ." + Agent_alley_TBx.Text;
cag.Agent_Road = string.IsNullOrEmpty(Agent_road_TBx.Text) ? "ถ.-" : "ถ." + Agent_road_TBx.Text;
cag.Agent_Subdistrict = string.IsNullOrEmpty(Agent_subdistrict_TBx.Text) ? "ต.-" : "ต." + Agent_subdistrict_TBx.Text;
cag.Agent_District = string.IsNullOrEmpty(Agent_district_TBx.Text) ? "อ.-" : "อ." + Agent_district_TBx.Text;
cag.Agent_Province = Agent_province_DDL.SelectedIndex <= 0 ? "จ.-" : "จ." + Agent_province_DDL.SelectedItem.Text;
cag.Agent_Country = string.IsNullOrEmpty(Agent_country_TBx.Text) ? "" : Agent_country_TBx.Text;
cag.Agent_Zipcode = string.IsNullOrEmpty(Agent_zipcode_TBx.Text) ? "" : Agent_zipcode_TBx.Text;
past_page = cag_mng.editAgent(cag);
}
else
{
cag.Agent_id = cag_mng.generateAgentID();
cag.Agent_Fname = string.IsNullOrEmpty(Agent_fname_TBx.Text) ? "" : Agent_fname_TBx.Text;
cag.Agent_Lname = string.IsNullOrEmpty(Agent_lname_TBx.Text) ? "" : Agent_lname_TBx.Text;
cag.Agent_Idcard = string.IsNullOrEmpty(Agent_idcard_TBx.Text) ? "" : Agent_idcard_TBx.Text;
cag.Agent_Address_no = string.IsNullOrEmpty(Agent_address_no_TBx.Text) ? "" : Agent_address_no_TBx.Text;
cag.Agent_Vilage = string.IsNullOrEmpty(Agent_vilage_TBx.Text) ? "บ.-" : "บ." + Agent_vilage_TBx.Text;
cag.Agent_Vilage_no = string.IsNullOrEmpty(Agent_vilage_no_TBx.Text) ? "ม.-" : "ม." + Agent_vilage_no_TBx.Text;
cag.Agent_Alley = string.IsNullOrEmpty(Agent_alley_TBx.Text) ? "ซ.-" : "ซ." + Agent_alley_TBx.Text;
cag.Agent_Road = string.IsNullOrEmpty(Agent_road_TBx.Text) ? "ถ.-" : "ถ." + Agent_road_TBx.Text;
cag.Agent_Subdistrict = string.IsNullOrEmpty(Agent_subdistrict_TBx.Text) ? "ต.-" : "ต." + Agent_subdistrict_TBx.Text;
cag.Agent_District = string.IsNullOrEmpty(Agent_district_TBx.Text) ? "อ.-" : "อ." + Agent_district_TBx.Text;
cag.Agent_Province = Agent_province_DDL.SelectedIndex <= 0 ? "จ.-" : "จ." + Agent_province_DDL.SelectedItem.Text;
cag.Agent_Country = string.IsNullOrEmpty(Agent_country_TBx.Text) ? "" : Agent_country_TBx.Text;
cag.Agent_Zipcode = string.IsNullOrEmpty(Agent_zipcode_TBx.Text) ? "" : Agent_zipcode_TBx.Text;
past_page = cag_mng.addAgent(cag);
}
if (past_page)
{
Session.Remove("chk_agent");
Alert_Success_Panel.Visible = true;
/// Acticity Logs System
///
package_login = (Base_Companys)Session["Package"];
acc_lgn = (Account_Login)Session["Login"];
string message = Messages_Logs._messageLogsNormal(acc_lgn.Account_F_name, " เพิ่มข้อมูลนายหน้า ", acc_lgn.resu, package_login.Company_N_name);
new Activity_Log_Manager().addActivityLogs(message, acc_lgn.Account_id, package_login.Company_id);
/// Acticity Logs System
}
else
{
Alert_Danger_Panel.Visible = true;
alert_header_danger_Lbl.Text = "แจ้งเตือน!!";
alert_danger_Lbl.Text = "กรุณาตรวจสอบ ข้อมูลอีกครั้ง";
Alert_Danger_Panel.Focus();
}
}
/*******************************************************************************************************************************************************************************
**************************************************** Add Data Function ********************************************************
**************************************************** ********************************************************
*******************************************************************************************************************************************************************************/
private void _EditAgent()
{
Agents_Manager cag_mng = new Agents_Manager();
Agents cag = new Agents();
bool past_page = false;
if (Session["chk_agent_leasing"] != null)
{
Agents cag_tmp = (Agents)Session["chk_agent_leasing"];
cag.Agent_id = cag_tmp.Agent_id;
cag.Agent_Fname = string.IsNullOrEmpty(Agent_fname_TBx.Text) ? "" : Agent_fname_TBx.Text;
cag.Agent_Lname = string.IsNullOrEmpty(Agent_lname_TBx.Text) ? "" : Agent_lname_TBx.Text;
cag.Agent_Idcard = string.IsNullOrEmpty(Agent_idcard_TBx.Text) ? "" : Agent_idcard_TBx.Text;
cag.Agent_Address_no = string.IsNullOrEmpty(Agent_address_no_TBx.Text) ? "" : Agent_address_no_TBx.Text;
cag.Agent_Vilage = string.IsNullOrEmpty(Agent_vilage_TBx.Text) ? "บ.-" : "บ." + Agent_vilage_TBx.Text;
cag.Agent_Vilage_no = string.IsNullOrEmpty(Agent_vilage_no_TBx.Text) ? "ม.-" : "ม." + Agent_vilage_no_TBx.Text;
cag.Agent_Alley = string.IsNullOrEmpty(Agent_alley_TBx.Text) ? "ซ.-" : "ซ." + Agent_alley_TBx.Text;
cag.Agent_Road = string.IsNullOrEmpty(Agent_road_TBx.Text) ? "ถ.-" : "ถ." + Agent_road_TBx.Text;
cag.Agent_Subdistrict = string.IsNullOrEmpty(Agent_subdistrict_TBx.Text) ? "ต.-" : "ต." + Agent_subdistrict_TBx.Text;
cag.Agent_District = string.IsNullOrEmpty(Agent_district_TBx.Text) ? "อ.-" : "อ." + Agent_district_TBx.Text;
cag.Agent_Province = Agent_province_DDL.SelectedIndex <= 0 ? "จ.-" : "จ." + Agent_province_DDL.SelectedItem.Text;
cag.Agent_Country = string.IsNullOrEmpty(Agent_country_TBx.Text) ? "" : Agent_country_TBx.Text;
cag.Agent_Zipcode = string.IsNullOrEmpty(Agent_zipcode_TBx.Text) ? "" : Agent_zipcode_TBx.Text;
past_page = cag_mng.editAgent(cag);
}
else
{
cag.Agent_id = cag_mng.generateAgentID();
cag.Agent_Fname = string.IsNullOrEmpty(Agent_fname_TBx.Text) ? "" : Agent_fname_TBx.Text;
cag.Agent_Lname = string.IsNullOrEmpty(Agent_lname_TBx.Text) ? "" : Agent_lname_TBx.Text;
cag.Agent_Idcard = string.IsNullOrEmpty(Agent_idcard_TBx.Text) ? "" : Agent_idcard_TBx.Text;
cag.Agent_Address_no = string.IsNullOrEmpty(Agent_address_no_TBx.Text) ? "" : Agent_address_no_TBx.Text;
cag.Agent_Vilage = string.IsNullOrEmpty(Agent_vilage_TBx.Text) ? "บ.-" : "บ." + Agent_vilage_TBx.Text;
cag.Agent_Vilage_no = string.IsNullOrEmpty(Agent_vilage_no_TBx.Text) ? "ม.-" : "ม." + Agent_vilage_no_TBx.Text;
cag.Agent_Alley = string.IsNullOrEmpty(Agent_alley_TBx.Text) ? "ซ.-" : "ซ." + Agent_alley_TBx.Text;
cag.Agent_Road = string.IsNullOrEmpty(Agent_road_TBx.Text) ? "ถ.-" : "ถ." + Agent_road_TBx.Text;
cag.Agent_Subdistrict = string.IsNullOrEmpty(Agent_subdistrict_TBx.Text) ? "ต.-" : "ต." + Agent_subdistrict_TBx.Text;
cag.Agent_District = string.IsNullOrEmpty(Agent_district_TBx.Text) ? "อ.-" : "อ." + Agent_district_TBx.Text;
cag.Agent_Province = Agent_province_DDL.SelectedIndex <= 0 ? "จ.-" : "จ." + Agent_province_DDL.SelectedItem.Text;
cag.Agent_Country = string.IsNullOrEmpty(Agent_country_TBx.Text) ? "" : Agent_country_TBx.Text;
cag.Agent_Zipcode = string.IsNullOrEmpty(Agent_zipcode_TBx.Text) ? "" : Agent_zipcode_TBx.Text;
past_page = cag_mng.addAgent(cag);
}
Car_Leasings cls_tmp = (Car_Leasings)Session["Leasings"];
Agents_Commission cag_com = new Agents_Commission();
cag_com.Leasing_id = cls_tmp.Leasing_id;
cag_com.cag = new Agents();
cag_com.cag = cag;
cag_com.Agent_commission = string.IsNullOrEmpty(Agent_commission_TBx.Text) ? 0 : Convert.ToDouble(Agent_commission_TBx.Text);
cag_com.Agent_percen = string.IsNullOrEmpty(Agent_percen_TBx.Text) ? 0 : Convert.ToDouble(Agent_percen_TBx.Text);
cag_com.Agent_cash = string.IsNullOrEmpty(Agent_cash_TBx.Text) ? 0 : Convert.ToDouble(Agent_cash_TBx.Text);
cag_com.Agent_net_com = string.IsNullOrEmpty(Agent_net_com_TBx.Text) ? 0 : Convert.ToDouble(Agent_net_com_TBx.Text);
cag_com.Agent_num_code = string.IsNullOrEmpty(Agent_com_code_TBx.Text) ? "" : Agent_com_code_TBx.Text;
cag_com.Agent_book_code = string.IsNullOrEmpty(Agent_bookcode_TBx.Text) ? "" : Agent_bookcode_TBx.Text;
cag_com.Agent_date_print = string.IsNullOrEmpty(Agent_date_print_TBx.Text) ? DateTimeUtility._dateNOWForServer() : DateTimeUtility.convertDateToMYSQL(Agent_date_print_TBx.Text);
if (cag_mng.editAgentCommission(cag_com) && past_page)
{
cag_com = cag_mng.getAgentCommission(cag_com.cag.Agent_id, cls_tmp.Leasing_id);
Session["Agents_Leasing"] = string.IsNullOrEmpty(cag_com.cag.Agent_id) ? null : cag_com;
/// Acticity Logs System
///
package_login = (Base_Companys)Session["Package"];
acc_lgn = (Account_Login)Session["Login"];
string message = Messages_Logs._messageLogsNormal(acc_lgn.Account_F_name, " แก้ไขข้อมูลนายหน้า ในสัญญา : " + cls_tmp.Leasing_no + " เลขที่ฝาก : " + cls_tmp.Deps_no, acc_lgn.resu, package_login.Company_N_name);
new Activity_Log_Manager().addActivityLogs(message, acc_lgn.Account_id, package_login.Company_id);
/// Acticity Logs System
///
Session.Remove("chk_agent_leasing");
Session["Class_Active"] = 4;
Session["Number_Of_Guarantor"] = "1";
if (Session["Guarantor_1"] == null)
{
Response.Redirect("/Form_Leasings/Leasing_Add_Guarantor");
}
else
{
Response.Redirect("/Form_Leasings/Leasing_Edit_Guarantor");
}
}
else
{
Alert_Danger_Panel.Visible = true;
alert_header_danger_Lbl.Text = "แจ้งเตือน!!";
alert_danger_Lbl.Text = "กรุณาตรวจสอบ ข้อมูลอีกครั้ง";
Alert_Danger_Panel.Focus();
}
}
