protected void GridViewExpense_RowCommand(object sender, GridViewCommandEventArgs e)
{
logger.Info(HttpContext.Current.Request.Cookies["User_ID"].Value + " " + System.Reflection.MethodBase.GetCurrentMethod().DeclaringType.ToString() + " " + System.Reflection.MethodBase.GetCurrentMethod().Name);
if (e.CommandName == "AddNew")
{
string User_ID = HttpContext.Current.Request.Cookies["User_ID"].Value;
dbo_UserClass user_class = dbo_UserDataClass.Select_Record(User_ID);
try
{
dbo_RevenueExpenseClass rev = new dbo_RevenueExpenseClass();
rev.Post_No = txtPost_No.Text;// GenerateID.Post_No(user_class.CV_CODE);
rev.CV_Code = user_class.CV_CODE;
rev.Post_Date = DateTime.Now;
TextBox txtFooterRevenue_Amount = (TextBox)GridViewExpense.FooterRow.FindControl("txtFooter_Amount");
rev.Amount = txtFooterRevenue_Amount.Text == "" ? 0 : decimal.Parse(txtFooterRevenue_Amount.Text);
DropDownList _ddlFooterDetail = (DropDownList)GridViewExpense.FooterRow.FindControl("ddlFooterDetail");
rev.Account_Code = _ddlFooterDetail.SelectedValue;
rev.Account_No = GenerateID.EP(user_class.CV_CODE);
TextBox txtFooterRemark = (TextBox)GridViewExpense.FooterRow.FindControl("txtFooterRemark");
rev.Remark = txtFooterRemark.Text;
bool succes = false;
succes = dbo_RevenueExpenseDataClass.Add(rev);
if (succes)
{
System.Threading.Thread.Sleep(500);
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "SAMWAIT", "myApp.hidePleaseWait();", true);
Show("บันทึกสำเร็จ!");
}
GridViewExpense.ShowFooter = false;
InitialExpense();
System.Threading.Thread.Sleep(500);
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "SAMWAIT", "myApp.hidePleaseWait();", true);
}
catch (Exception ex)
{
logger.Error(ex.Message);
}
}
else if (e.CommandName == "_Delete")
{
LinkButton lnkView = (LinkButton)e.CommandSource;
string Account_No = lnkView.CommandArgument;
dbo_RevenueExpenseDataClass.Delete(Account_No);
System.Threading.Thread.Sleep(500);
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "SAMWAIT", "myApp.hidePleaseWait();", true);
Show("ลบข้อมูลสำเร็จ");
InitialExpense();
}
}
private void InitialRevenue()
{
try
{
logger.Info(HttpContext.Current.Request.Cookies["User_ID"].Value + " " + System.Reflection.MethodBase.GetCurrentMethod().DeclaringType.ToString() + " " + System.Reflection.MethodBase.GetCurrentMethod().Name);
GridViewRevenue.EditIndex = -1;
GridViewRevenue.ShowFooter = false;
string User_ID = HttpContext.Current.Request.Cookies["User_ID"].Value;
dbo_UserClass user_class = dbo_UserDataClass.Select_Record(User_ID);
DateTime?Begin = null;
if (!string.IsNullOrEmpty(txtPost_Date.Text))
{
Begin = DateTime.Parse(txtPost_Date.Text);
}
List <dbo_RevenueExpenseClass> item = dbo_RevenueExpenseDataClass.Search(txtPost_No.Text, Begin, null, user_class.CV_CODE);
item = item.Where(f => f.Account_No.Substring(6, 2) == "RV").ToList();
GridViewRevenue.DataSource = item;
GridViewRevenue.DataBind();
Textbox1.Text = item.Sum(f => f.Amount).Value.ToString("#,##0.##");
}
catch (Exception ex)
{
logger.Error(ex.Message);
}
}
private void DisplayReportCustomerBirthday()
{
List <RPT_Customer_BIRTH_DATE_41213> rt_RPT_BIRTH_DATE = new List <RPT_Customer_BIRTH_DATE_41213>();
rt_RPT_BIRTH_DATE = Reports.RPT_Customer_BIRTH_DATE_41213(Region, AgentName, MonthGroup, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty);
foreach (var d in rt_RPT_BIRTH_DATE)
{
d.paramRegion_Name = Request.QueryString["Region"];
if (d.paramRegion_Name == "")
{
d.paramRegion_Name = "เลือกทั้งหมด";
}
d.paramCV_Name = Request.QueryString["AgentName"];
if (d.paramCV_Name != "")
{
user_class = dbo_UserDataClass.Select_Record(d.paramCV_Name);
d.paramCV_Name = user_class.AgentName;
}
d.paramBirth_Month = Request.QueryString["MonthGroup"];
}
cryRpt.Load(Server.MapPath("~/Report/RT_ReportCustomerBirthday.rpt"));
cryRpt.SetDataSource(rt_RPT_BIRTH_DATE);
BinaryReader stream = new BinaryReader(cryRpt.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat));
Response.ClearContent();
Response.ClearHeaders();
Response.ContentType = "application/pdf";
Response.BinaryWrite(stream.ReadBytes(Convert.ToInt32(stream.BaseStream.Length)));
Response.Flush();
Response.Close();
}
protected void ddlSearchRegion_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
string User_ID = Request.Cookies["User_ID"].Value;
dbo_UserClass user_class = dbo_UserDataClass.Select_Record(User_ID);
if (ddlSearchRegion.SelectedValue.ToString() != null)
{
if (ddlSearchRegion.SelectedIndex == 0)
{
List <dbo_AgentClass> agent = dbo_AgentDataClass.Search(string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, "Active", string.Empty);
List <dbo_AgentClass> cv_code1 = new List <dbo_AgentClass>(agent.Where(f => f.DM_ID == User_ID || f.GM_ID == User_ID.Trim() || f.SD_ID == User_ID.Trim() || f.SM_ID == User_ID.Trim() || f.APV_ID == User_ID.Trim()).Select(f => f));
if (cv_code1.Count > 0)
{
ddlAgentName.DataSource = cv_code1;
ddlAgentName.DataBind();
ddlAgentName.Items.Insert(0, "เลือกทั้งหมด");
}
else
{
String strString = user_class.Region;
String[] myArr = strString.Split(',');
Dictionary <string, string> region = dbo_ItemDataClass.GetDropDown_Report("07");
String[] region_tmp = region.Where(f => myArr.Contains(f.Value)).Select(f => f.Value).ToArray();
//ddlAgentName
//List<dbo_AgentClass> agent = dbo_AgentDataClass.Search(string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, "Active", string.Empty);
ddlAgentName.DataSource = agent.Where(f => region_tmp.Contains(f.Location_Region)).OrderBy(f => f.CV_AgentName);
ddlAgentName.DataBind();
ddlAgentName.Items.Insert(0, "เลือกทั้งหมด");
}
}
else
{
//ddlAgentName
List <dbo_AgentClass> agent = dbo_AgentDataClass.Search(string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, ddlSearchRegion.SelectedValue.ToString(), "Active", string.Empty);
List <dbo_AgentClass> cv_code1 = new List <dbo_AgentClass>(agent.Where(f => f.DM_ID == User_ID || f.GM_ID == User_ID.Trim() || f.SD_ID == User_ID.Trim() || f.SM_ID == User_ID.Trim() || f.APV_ID == User_ID.Trim()).Select(f => f));
if (cv_code1.Count > 0)
{
ddlAgentName.DataSource = cv_code1;
ddlAgentName.DataBind();
ddlAgentName.Items.Insert(0, "เลือกทั้งหมด");
}
else
{
ddlAgentName.DataSource = agent.OrderBy(f => f.CV_AgentName);
ddlAgentName.DataBind();
ddlAgentName.Items.Insert(0, "เลือกทั้งหมด");
}
}
}
}
catch (Exception ex)
{
logger.Error(ex);
}
}
private void UpdateRecord()
{
try
{
dbo_UserClass oclsdbo_User = new dbo_UserClass();
dbo_UserClass clsdbo_User = new dbo_UserClass();
oclsdbo_User.User_ID = System.Convert.ToString(Session["User_ID"]);
oclsdbo_User = dbo_UserDataClass.Select_Record(CommonDataClass.User_ID);
clsdbo_User.Password = txtConfirmPassword.Text;
string User_ID = HttpContext.Current.Request.Cookies["User_ID"].Value;
bool success = false;
success = dbo_UserDataClass.Update(oclsdbo_User, User_ID);
if (success)
{
System.Threading.Thread.Sleep(500);
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "SAMWAIT", "myApp.hidePleaseWait();", true);
Show("เปลี่ยนรหัสผ่านสำเร็จ");
//string script = @"swal(""เปลี่ยนรหัสผ่านสำเร็จ"");";
//ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "SAM", script, true);
}
}
catch (Exception ex)
{
logger.Error(ex.Message);
}
}
protected void GridViewExpense_RowEditing(object sender, GridViewEditEventArgs e)
{
logger.Info(HttpContext.Current.Request.Cookies["User_ID"].Value + " " + System.Reflection.MethodBase.GetCurrentMethod().DeclaringType.ToString() + " " + System.Reflection.MethodBase.GetCurrentMethod().Name);
try
{
string User_ID = HttpContext.Current.Request.Cookies["User_ID"].Value;
dbo_UserClass user_class = dbo_UserDataClass.Select_Record(User_ID);
DateTime?Begin = null;
if (!string.IsNullOrEmpty(txtPost_Date.Text))
{
Begin = DateTime.Parse(txtPost_Date.Text);
}
List <dbo_RevenueExpenseClass> item = dbo_RevenueExpenseDataClass.Search(txtPost_No.Text, Begin, null, user_class.CV_CODE);
item = item.Where(f => f.Account_No.Substring(6, 2) == "EP").ToList();
GridViewExpense.ShowFooter = false;
GridViewExpense.EditIndex = e.NewEditIndex;
GridViewExpense.DataSource = item;
GridViewExpense.DataBind();
}
catch (Exception ex)
{
logger.Error(ex.Message);
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
if (!IsPostBack)
{
// string id = GenerateID.Commission_requisition_no("201567");
txtRequisition_Amount.Attributes.Add("onkeypress", "javascript:return validateFloatKeyPress(this, event);");
txtRequisition_Amount.Attributes.Add("ondrop", "javascript:return false;");
txtRequisition_Amount.Attributes.Add("onpaste", "javascript:return false;");
string User_ID = HttpContext.Current.Request.Cookies["User_ID"].Value;
dbo_UserClass user_class = dbo_UserDataClass.Select_Record(User_ID);
if (user_class.User_Group_ID != "Agent")
{
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "SAM", "history.back();", true);
}
else
{
SetUpDrowDownList();
//
btnSearchSubmit_Click(sender, e);
}
}
txtSearchClearing_Date_Begin.Text = DateTime.Now.ToShortDateString();
txtSearchClearing_Date_End.Text = DateTime.Now.ToShortDateString();
txtRequistionStart.Text = DateTime.Now.ToShortDateString();
txtRequistionEnd.Text = DateTime.Now.ToShortDateString();
}
catch (Exception ex)
{
logger.Error(ex.Message);
}
}
protected void btnCreateNew_Click(object sender, EventArgs e)
{
logger.Info(HttpContext.Current.Request.Cookies["User_ID"].Value + " " + System.Reflection.MethodBase.GetCurrentMethod().DeclaringType.ToString() + " " + System.Reflection.MethodBase.GetCurrentMethod().Name);
try
{
string User_ID = HttpContext.Current.Request.Cookies["User_ID"].Value;
dbo_UserClass user_class = dbo_UserDataClass.Select_Record(User_ID);
DateTime?Begin = null;
DateTime?End = null;
if (!string.IsNullOrEmpty(txtStartDate.Text))
{
Begin = DateTime.Parse(txtStartDate.Text);
}
if (!string.IsNullOrEmpty(txtEndDate.Text))
{
End = DateTime.Parse(txtEndDate.Text);
}
GridViewRevenue.ShowFooter = true;
List <dbo_RevenueExpenseClass> item = dbo_RevenueExpenseDataClass.Search(txtPost_No.Text, Begin, End, user_class.CV_CODE);
item = item.Where(f => f.Account_No.Substring(6, 2) == "RV").ToList();
if (item.Count == 0)
{
item.Add(new dbo_RevenueExpenseClass());
GridViewRevenue.DataSource = item;
GridViewRevenue.DataBind();
GridViewRevenue.Rows[0].Visible = false;
}
else
{
GridViewRevenue.DataSource = item;
GridViewRevenue.DataBind();
}
DropDownList ddl = (DropDownList)GridViewRevenue.FooterRow.FindControl("ddlFooterDetail");
List <dbo_AccountCodeClass> account = dbo_AccountTypeDataClass.GetAccountRevenue();
ddl.DataSource = account;
ddl.DataTextField = "Account_Name";
ddl.DataValueField = "Account_Code";
ddl.DataBind();
TextBox txtFooterRevenue_Amount = (TextBox)GridViewRevenue.FooterRow.FindControl("txtFooterRevenue_Amount");
txtFooterRevenue_Amount.Attributes.Add("onkeypress", "javascript:return validateFloatKeyPress(this, event);");
System.Threading.Thread.Sleep(500);
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "SAMWAIT", "myApp.hidePleaseWait();", true);
}
catch (Exception ex)
{
logger.Error(ex.Message);
}
}
protected void btnPrint_Click(object sender, EventArgs e)
{
try
{
if (IsValidForm())
{
System.Threading.Thread.Sleep(500);
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "SAMWAIT", "myApp.hidePleaseWait();", true);
string User_ID = Request.Cookies["User_ID"].Value;
dbo_UserClass user_class = dbo_UserDataClass.Select_Record(User_ID);
string Region = ddlSearchRegion.SelectedItem.ToString();
string AgentName = ddlAgentName.SelectedValue;
string MonthGroup = ddlMonthGroup.SelectedValue;
if (Region == "เลือกทั้งหมด")
{
Region = string.Empty;
}
if (AgentName == "เลือกทั้งหมด")
{
AgentName = string.Empty;
}
if (MonthGroup == "เลือกทั้งหมด")
{
MonthGroup = string.Empty;
}
List <RPT_Customer_BIRTH_DATE_41213> rt_RPT_BIRTH_DATE = new List <RPT_Customer_BIRTH_DATE_41213>();
rt_RPT_BIRTH_DATE = Reports.RPT_Customer_BIRTH_DATE_41213(Region, AgentName, MonthGroup, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty);
//rt_RPT_BIRTH_DATE = Reports.RPT_Customer_BIRTH_DATE_41213(Region, AgentName, MonthGroup, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty);
if (rt_RPT_BIRTH_DATE.Count > 0)
{
//string User_ID = Request.Cookies["User_ID"].Value;
string url = "../Report/ReportViewer.aspx?RPT=ReportCustomerBirthday&Region=" + ddlSearchRegion.SelectedItem.ToString()
+ "&RegionName=" + ddlAgentName.SelectedItem.ToString()
+ "&AgentName=" + ddlAgentName.SelectedValue
+ "&AgentFullName=" + ddlAgentName.SelectedItem.ToString()
+ "&MonthGroup=" + ddlMonthGroup.SelectedValue;
string s = "window.open('" + url + "', 'popup_window', 'width=1024,height=768,left=100,top=100,resizable=yes');";
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "SAM", s, true);
}
else
{
Messages.Show("ไม่พบข้อมูล กรุณาเลือกเงื่อนไขอีกครั้ง", this.Page);
}
}
}
catch (Exception ex)
{
logger.Error(ex.Message);
}
}
private void SetUpDrowDownList()
{
logger.Info(HttpContext.Current.Request.Cookies["User_ID"].Value + " " + System.Reflection.MethodBase.GetCurrentMethod().DeclaringType.ToString() + " " + System.Reflection.MethodBase.GetCurrentMethod().Name);
// Dictionary<string, string> role = dbo_ItemDataClass.GetRoleDropDown();
//Dictionary<string, string> role = dbo_ItemDataClass.GetDropDown("09");
List <dbo_RoleClass> role = dbo_RoleDataClass.Search(string.Empty, string.Empty, "CP Meiji");
role.Insert(0, new dbo_RoleClass {
Role_ID = string.Empty, Role_Name = "==ระบุ=="
});
ddlSearchRole.DataSource = role;
ddlSearchRole.DataBind();
Dictionary <string, string> positon = dbo_ItemDataClass.GetDropDown("04");
ddlSearchPosition.DataSource = positon;
ddlSearchPosition.DataBind();
List <dbo_UserClass> user = dbo_UserDataClass.Search("", "", "", "", "", "CP Meiji", "", "", null, string.Empty, string.Empty);
dbo_UserClass u = new dbo_UserClass();
u.First_Name = "==ระบุ==";
u.User_ID = string.Empty;
user.Insert(0, u);
ddlSearchFirst_Name.DataSource = user;
ddlSearchFirst_Name.DataBind();
ddlSearchState.ClearSelection();
ddlSearchStatus.ClearSelection();
Dictionary <string, string> title = dbo_ItemDataClass.GetDropDown("03");
Dictionary <string, string> UserGroup = dbo_ItemDataClass.GetDropDown("1601");
Dictionary <string, string> approve = dbo_ItemDataClass.GetDropDown("1801");
Dictionary <string, string> showdashboard = dbo_ItemDataClass.GetDropDown("1901");
ddlCP_TitleID.DataSource = title;
ddlCP_TitleID.DataBind();
ddlCP_Position.DataSource = positon;
ddlCP_Position.DataBind();
ddlCP_UserRole.DataSource = role;
ddlCP_UserRole.DataBind();
Dictionary <string, string> region = dbo_ItemDataClass.GetDropDown("07");
//ddlSearchState.DataSource = region.Where(f => f.Key != string.Empty);
ddlSearchState.DataSource = region;
ddlSearchState.DataBind();
//ddlLocation_Region.DataSource = region;
ddlLocation_Region.DataSource = region.Where(f => f.Key != string.Empty);
ddlLocation_Region.DataBind();
}
protected void btnPrint_Click(object sender, EventArgs e)
{
try
{
System.Threading.Thread.Sleep(500);
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "SAMWAIT", "myApp.hidePleaseWait();", true);
List <RPT_REV_EXP_DAILY_41220> rt_RPT_EXP_DAILY = new List <RPT_REV_EXP_DAILY_41220>();
string User_ID = HttpContext.Current.Request.Cookies["User_ID"].Value;
dbo_UserClass user_class = dbo_UserDataClass.Select_Record(User_ID);
List <dbo_AgentClass> agent = dbo_AgentDataClass.Search(string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, "Active", string.Empty);
if (user_class.User_Group_ID == "CP Meiji")
{
string region = user_class.Region;
string[] regions = region.Split(',');
List <dbo_AgentClass> cv_code_ = new List <dbo_AgentClass>();
foreach (string in_region in regions)
{
List <dbo_AgentClass> cv_code2 = new List <dbo_AgentClass>(agent.Where(f => f.Location_Region == in_region).Select(f => f));
foreach (dbo_AgentClass _cv in cv_code2)
{
List <RPT_REV_EXP_DAILY_41220> _inrpt = Reports.RPT_REV_EXP_DAILY_41220(string.Empty, user_class.CV_CODE, InvoiceDate.Text, InvoiceDateTo.Text, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty);
foreach (RPT_REV_EXP_DAILY_41220 rpt in _inrpt)
{
rt_RPT_EXP_DAILY.Add(rpt);
}
}
}
}
else
{
rt_RPT_EXP_DAILY = Reports.RPT_REV_EXP_DAILY_41220(string.Empty, user_class.CV_CODE, InvoiceDate.Text, InvoiceDateTo.Text, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty);
}
if (rt_RPT_EXP_DAILY.Count > 0)
{
//string User_ID = Request.Cookies["User_ID"].Value;
string url = "../Report/ReportViewer_01.aspx?RPT=ReportFinanceClerk&InvoiceDate=" + InvoiceDate.Text
+ "&InvoiceDateTo=" + InvoiceDateTo.Text
+ "&CV_Code=" + user_class.CV_CODE;
string s = "window.open('" + url + "', 'popup_window', 'width=1024,height=768,left=100,top=100,resizable=yes');";
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "SAM", s, true);
}
else
{
Messages.Show("ไม่พบข้อมูล กรุณาเลือกเงื่อนไขอีกครั้ง", this.Page);
}
}
catch (Exception ex)
{
}
}
protected void btnOK_Click(object sender, EventArgs e)
{
string user_id = txtUserName.Text;
dbo_UserClass user = dbo_UserDataClass.Select_Record(user_id);
//dbo_UserDataClass.Search()
// ScriptManager.RegisterStartupScript(this, this.GetType(), "ลืมรหัสผ่าน", "openModal();", true);
}
protected void btnSearch_2_Submit_Click(object sender, EventArgs e)
{
logger.Info(HttpContext.Current.Request.Cookies["User_ID"].Value + " " + System.Reflection.MethodBase.GetCurrentMethod().DeclaringType.ToString() + " " + System.Reflection.MethodBase.GetCurrentMethod().Name);
try
{
DateTime?begin = null;
DateTime?end = null;
if (!string.IsNullOrEmpty(txtClearing_Begin.Text))
{
begin = DateTime.Parse(txtClearing_Begin.Text);
}
if (!string.IsNullOrEmpty(txtClearing_End.Text))
{
end = DateTime.Parse(txtClearing_End.Text);
}
string user_id = ddl_SPName.SelectedIndex == 0 ? "" : ddl_SPName.SelectedValue;
List <dbo_DebtClass> listofdebt = dbo_DebtDataClass.Search(user_id == string.Empty ? "--" : user_id, string.Empty);
decimal?debt = 0;
foreach (dbo_DebtClass debt_item in listofdebt)
{
debt += debt_item.Balance_Outstanding_Amount;
}
txtTotalBalanceOutstanding.Text = (debt == 0 ? string.Empty : debt.Value.ToString("#,##0.#0"));
txtTotalAmount.Text = string.Empty;
txtRequisition_Amount.Text = string.Empty;
string User_ID = HttpContext.Current.Request.Cookies["User_ID"].Value;
dbo_UserClass user_class = dbo_UserDataClass.Select_Record(User_ID);
List <dbo_ClearingClass> item = dbo_ClearingDataClass.Get_Commission(txtClearing_No.Text, begin, end, user_id, user_class.CV_CODE);
Session["item_commission"] = item;
grdCommissionRequisition.DataSource = item;
grdCommissionRequisition.DataBind();
System.Threading.Thread.Sleep(500);
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "SAMWAIT", "myApp.hidePleaseWait();", true);
}
catch (Exception ex)
{
logger.Error(ex.Message);
}
}
protected void ButtonAddNew_Click(object sender, EventArgs e)
{
logger.Info(HttpContext.Current.Request.Cookies["User_ID"].Value + " " + System.Reflection.MethodBase.GetCurrentMethod().DeclaringType.ToString() + " " + System.Reflection.MethodBase.GetCurrentMethod().Name);
try
{
string User_ID = HttpContext.Current.Request.Cookies["User_ID"].Value;
dbo_UserClass user_class = dbo_UserDataClass.Select_Record(User_ID);
string Post_No = GenerateID.Post_No(user_class.CV_CODE);
List <dbo_RevenueExpenseClass> item_rev = dbo_RevenueExpenseDataClass.Search(Post_No, null, null, user_class.CV_CODE);
if (item_rev.Count == 0)
{
pnlForm.Visible = true;
pnlGrid.Visible = false;
Textbox1.Text = "0";
Textbox2.Text = "0";
txtPost_Date.Text = DateTime.Now.ToShortDateString();
txtPost_No.Text = GenerateID.Post_No(user_class.CV_CODE);
List <dbo_RevenueExpenseClass> item = dbo_RevenueExpenseDataClass.Search(txtPost_No.Text, null, null, user_class.CV_CODE);
List <dbo_RevenueExpenseClass> item_rv = item.Where(f => f.Account_No.Substring(6, 2) == "RV").ToList(); //รายรับ
List <dbo_RevenueExpenseClass> item_ep = item.Where(f => f.Account_No.Substring(6, 2) == "EP").ToList(); //รายจ่าย
GridViewRevenue.DataSource = item_rv;
GridViewRevenue.DataBind();
GridViewExpense.DataSource = item_ep;
GridViewExpense.DataBind();
System.Threading.Thread.Sleep(500);
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "SAMWAIT", "myApp.hidePleaseWait();", true);
}
else
{
System.Threading.Thread.Sleep(500);
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "SAMWAIT", "myApp.hidePleaseWait();", true);
Show("คุณได้ทำการบันทึกรายรับรายจ่ายของวันนี้แล้ว กรุณากลับไปแก้ไขรายการเดิม");
}
}
catch (Exception ex)
{
logger.Error(ex.Message);
}
}
private void SetUpDrowDownList()
{
logger.Info(HttpContext.Current.Request.Cookies["User_ID"].Value + " " + System.Reflection.MethodBase.GetCurrentMethod().DeclaringType.ToString() + " " + System.Reflection.MethodBase.GetCurrentMethod().Name);
try
{
string User_ID = Request.Cookies["User_ID"].Value;
dbo_UserClass user_class = dbo_UserDataClass.Select_Record(User_ID);
if (user_class.User_Group_ID == "CP Meiji")
{
String strString = user_class.Region;
String[] myArr = strString.Split(',');
//ddlAgentName
List <dbo_AgentClass> agent = dbo_AgentDataClass.Search(string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, "Active", string.Empty);
String[] agent_tmp = agent.Where(f => myArr.Contains(f.Location_Region) && f.Status == true).OrderBy(f => f.AgentName).Select(f => f.CV_Code).ToArray();
List <dbo_UserClass> users = dbo_UserDataClass.Search(string.Empty, string.Empty, string.Empty, string.Empty
, string.Empty, string.Empty, string.Empty, string.Empty, null, string.Empty, string.Empty);
//users.Where(f => f.User_Group_ID == "Agent" && f.Status == "Active" && f.Position == "สาวส่งนม" || f.Position == "ซุปเปอร์ไวซ์เซอร์").OrderBy(f => f.AgentName);
List <dbo_UserClass> user2 = new List <dbo_UserClass>(users.Where(f => f.User_Group_ID == "Agent" && f.Status == "Active" && (f.Position == "สาวส่งนม" || f.Position == "ซุปเปอร์ไวซ์เซอร์")).OrderBy(f => f.AgentName).Select(f => f));
ddl_SPName.DataSource = user2.Where(f => agent_tmp.Contains(f.CV_CODE)).OrderBy(f => f.FullName_ddl);
ddl_SPName.DataBind();
ddl_SPName.Items.Insert(0, "เลือกทั้งหมด");
}
else
{
//ddl_SPName
List <dbo_UserClass> users = dbo_UserDataClass.Search(string.Empty, string.Empty, string.Empty, string.Empty
, string.Empty, string.Empty, string.Empty, user_class.CV_CODE.Trim(), null, string.Empty, string.Empty);
//users.Where(f => f.User_Group_ID == "Agent" && f.Status == "Active" && (f.Position == "สาวส่งนม" || f.Position == "ซุปเปอร์ไวซ์เซอร์")).OrderBy(f => f.AgentName);
List <dbo_UserClass> user2 = new List <dbo_UserClass>(users.Where(f => f.User_Group_ID == "Agent" && f.Status == "Active" && (f.Position == "สาวส่งนม" || f.Position == "ซุปเปอร์ไวซ์เซอร์")).OrderBy(f => f.AgentName).Select(f => f));
ddl_SPName.DataSource = user2.OrderBy(f => f.FullName_ddl);
ddl_SPName.DataBind();
ddl_SPName.Items.Insert(0, "เลือกทั้งหมด");
}
txt_Clearing_Date_From.Text = DateTime.Now.ToShortDateString();
txt_Clearing_Date_TO.Text = DateTime.Now.ToShortDateString();
txt_Requisition_Date_From.Text = DateTime.Now.ToShortDateString();
txt_Requisition_Date_To.Text = DateTime.Now.ToShortDateString();
}
catch (Exception ex)
{
logger.Error(ex.Message);
}
}
private void SetUpDrowDownList()
{
try
{
logger.Info(HttpContext.Current.Request.Cookies["User_ID"].Value + " " + System.Reflection.MethodBase.GetCurrentMethod().DeclaringType.ToString() + " " + System.Reflection.MethodBase.GetCurrentMethod().Name);
string User_ID = HttpContext.Current.Request.Cookies["User_ID"].Value;
dbo_UserClass user_class = dbo_UserDataClass.Select_Record(User_ID);
dbo_AgentClass clsdbo_Agent = dbo_AgentDataClass.Select_Record(user_class.CV_CODE);
ViewState["CV_Code"] = clsdbo_Agent == null ? string.Empty : clsdbo_Agent.CV_Code;
pnlForm.Visible = false;
pnlGrid.Visible = true;
List <dbo_UserClass> users = dbo_UserDataClass.Search(string.Empty, string.Empty, string.Empty, string.Empty
, string.Empty, string.Empty, string.Empty, clsdbo_Agent == null ? string.Empty : clsdbo_Agent.CV_Code, null, string.Empty, string.Empty)
.Where(f => f.Status == "Active")
.Where(f => f.Position == "ซุปเปอร์ไวซ์เซอร์" || f.Position == "สาวส่งนม").ToList();
users.Insert(0, new dbo_UserClass()
{
FullName = "==ระบุ==", User_ID = string.Empty
});
ddlSearchSP.DataSource = users;
ddlSearchSP.DataBind();
txtSum.Text = string.Empty;
if (grdCommission.Rows.Count > 0)
{
List <dbo_ClearingClass> item = new List <dbo_ClearingClass>();
grdCommission.DataSource = item;
grdCommission.DataBind();
}
ddlStatus.SelectedIndex = 0;
txtClearing_No.Text = string.Empty;
txtRequisition_No.Text = string.Empty;
txtSearchClearing_Date_Begin.Text = DateTime.Now.ToShortDateString();
txtSearchClearing_Date_End.Text = DateTime.Now.ToShortDateString();
txtRequistionStart.Text = DateTime.Now.ToShortDateString();
txtRequistionEnd.Text = DateTime.Now.ToShortDateString();
}
catch (Exception ex)
{
logger.Error(ex.Message);
}
}
protected void ddlAgentName_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
String User_ID = Request.Cookies["User_ID"].Value;
dbo_UserClass user_class = dbo_UserDataClass.Select_Record(User_ID);
if (ddlAgentName.SelectedIndex == 0)
{
String strString = user_class.Region;
String[] myArr = strString.Split(',');
//ddlAgentName
List <dbo_AgentClass> agent = dbo_AgentDataClass.Search(string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, "Active", string.Empty);
String[] agent_tmp = agent.Where(f => myArr.Contains(f.Location_Region)).OrderBy(f => f.AgentName).Select(f => f.CV_Code).ToArray();
String[] agent_tmp1 = agent.Where(f => f.DM_ID == User_ID || f.GM_ID == User_ID.Trim() || f.SD_ID == User_ID.Trim() || f.SM_ID == User_ID.Trim() || f.APV_ID == User_ID.Trim()).Select(f => f.CV_Code).ToArray();
List <dbo_UserClass> users = dbo_UserDataClass.Search(string.Empty, string.Empty, string.Empty, string.Empty
, string.Empty, string.Empty, string.Empty, string.Empty, null, string.Empty, string.Empty);
users.Where(f => f.User_Group_ID == "Agent" && f.Status == "Active" && f.Position == "สาวส่งนม" || f.Position == "ซุปเปอร์ไวซ์เซอร์").OrderBy(f => f.AgentName);
if (agent_tmp1.Length > 0)
{
ddl_SPName.DataSource = users.Where(f => agent_tmp1.Contains(f.CV_CODE)).OrderBy(f => f.FullName_ddl);
ddl_SPName.DataBind();
ddl_SPName.Items.Insert(0, "เลือกทั้งหมด");
}
else
{
ddl_SPName.DataSource = users.Where(f => agent_tmp.Contains(f.CV_CODE)).OrderBy(f => f.FullName_ddl);
ddl_SPName.DataBind();
ddl_SPName.Items.Insert(0, "เลือกทั้งหมด");
}
}
else
{
List <dbo_UserClass> users = dbo_UserDataClass.Search(string.Empty, string.Empty, string.Empty, string.Empty
, string.Empty, string.Empty, string.Empty, ddlAgentName.SelectedValue, null, string.Empty, string.Empty);
users.Where(f => f.User_Group_ID == "Agent" && f.Status == "Active" && f.Position == "สาวส่งนม" || f.Position == "ซุปเปอร์ไวซ์เซอร์").OrderBy(f => f.AgentName);
ddl_SPName.DataSource = users.OrderBy(f => f.FullName_ddl);
ddl_SPName.DataBind();
ddl_SPName.Items.Insert(0, "เลือกทั้งหมด");
}
}
catch (Exception ex)
{
logger.Error(ex);
}
}
protected void GridViewRevenue_Expense_RowCommand(object sender, GridViewCommandEventArgs e)
{
logger.Info(HttpContext.Current.Request.Cookies["User_ID"].Value + " " + System.Reflection.MethodBase.GetCurrentMethod().DeclaringType.ToString() + " " + System.Reflection.MethodBase.GetCurrentMethod().Name);
if (e.CommandName == "_Delete")
{
LinkButton lnkView = (LinkButton)e.CommandSource;
string Post_No = lnkView.CommandArgument;
dbo_RevenueExpenseDataClass.DeletebyPostNo(Post_No);
System.Threading.Thread.Sleep(500);
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "SAMWAIT", "myApp.hidePleaseWait();", true);
Show("ลบข้อมูลสำเร็จ");
btnSearchSubmit_Click(null, null);
}
else if (e.CommandName == "View")
{
LinkButton lnkView = (LinkButton)e.CommandSource;
string Post_No = lnkView.CommandArgument;
pnlForm.Visible = true;
pnlGrid.Visible = false;
string User_ID = HttpContext.Current.Request.Cookies["User_ID"].Value;
dbo_UserClass user_class = dbo_UserDataClass.Select_Record(User_ID);
List <dbo_RevenueExpenseClass> item = dbo_RevenueExpenseDataClass.Search(Post_No, null, null, user_class.CV_CODE);
List <dbo_RevenueExpenseClass> item_rv = item.Where(f => f.Account_No.Substring(6, 2) == "RV").ToList();
List <dbo_RevenueExpenseClass> item_ep = item.Where(f => f.Account_No.Substring(6, 2) == "EP").ToList();
dbo_RevenueExpenseClass it = item.FirstOrDefault();
txtPost_Date.Text = Convert.ToDateTime(it.Post_Date).ToString("dd/MM/yyyy");
//txtPost_Date.Text = Convert.ToString(it.Post_Date);
txtPost_No.Text = Post_No;
Textbox1.Text = item_rv.Sum(f => f.Amount).Value.ToString("#,##0.##");
Textbox2.Text = item_ep.Sum(f => f.Amount).Value.ToString("#,##0.##");
GridViewRevenue.DataSource = item_rv;
GridViewRevenue.DataBind();
GridViewExpense.DataSource = item_ep;
GridViewExpense.DataBind();
}
}
private void SearchSubmit()
{
try
{
string User_ID = HttpContext.Current.Request.Cookies["User_ID"].Value;
dbo_UserClass user_class = dbo_UserDataClass.Select_Record(User_ID);
List <dbo_RoleClass> item = new List <dbo_RoleClass>();
if (user_class.User_Group_ID == "Agent")
{
item = dbo_RoleDataClass.Search(string.Empty, string.Empty, "Agent");
}
else
{
item = dbo_RoleDataClass.Search(string.Empty, string.Empty, string.Empty);
}
//List<dbo_RoleClass> item = new List<dbo_RoleClass>();
//if (ddlRoleType.SelectedIndex == 0)
//{
// item = dbo_RoleDataClass.Search(string.Empty, string.Empty, string.Empty);
//}
//else
//{
// item = dbo_RoleDataClass.Search(string.Empty, string.Empty, ddlRoleType.Text);
//}
//GridViewRole.ShowFooter = false;
if (item.Count == 0)
{
item.Add(new dbo_RoleClass());
GridViewRole.DataSource = item;
GridViewRole.DataBind();
GridViewRole.Rows[0].Visible = false;
}
else
{
GridViewRole.DataSource = item;
GridViewRole.DataBind();
}
}
catch (Exception)
{
}
}
protected void btnAddNew_Click(object sender, EventArgs e)
{
try
{
ddl_SPName.ClearSelection();
txtClearing_Begin.Text = string.Empty;
txtClearing_End.Text = string.Empty;
logger.Info(HttpContext.Current.Request.Cookies["User_ID"].Value + " " + System.Reflection.MethodBase.GetCurrentMethod().DeclaringType.ToString() + " " + System.Reflection.MethodBase.GetCurrentMethod().Name);
pnlForm.Visible = true;
pnlGrid.Visible = false;
string User_ID = HttpContext.Current.Request.Cookies["User_ID"].Value;
dbo_UserClass user_class = dbo_UserDataClass.Select_Record(User_ID);
List <dbo_UserClass> users = dbo_UserDataClass.Search(string.Empty, string.Empty, string.Empty, string.Empty
, string.Empty, string.Empty, string.Empty, user_class.CV_CODE, null, string.Empty, string.Empty)
.Where(f => f.Status == "Active")
.Where(f => f.Position == "ซุปเปอร์ไวซ์เซอร์" || f.Position == "สาวส่งนม").ToList();
ddl_SPName.DataSource = users;
ddl_SPName.DataBind();
ddl_SPName.Items.Insert(0, new ListItem("==ระบุ==", "0"));
ddl_SPName.ClearSelection();
txtClearing_Begin.Text = string.Empty;
txtClearing_End.Text = string.Empty;
txtTotalBalanceOutstanding.Text = string.Empty;
txtTotalAmount.Text = string.Empty;
txtRequisition_Amount.Text = string.Empty;
List <dbo_ClearingClass> item = new List <dbo_ClearingClass>();
grdCommissionRequisition.DataSource = item;
grdCommissionRequisition.DataBind();
System.Threading.Thread.Sleep(500);
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "SAMWAIT", "myApp.hidePleaseWait();", true);
}
catch (Exception ex)
{
logger.Error(ex.Message);
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
string User_ID = HttpContext.Current.Request.Cookies["User_ID"].Value;
dbo_UserClass user_class = dbo_UserDataClass.Select_Record(User_ID);
dbo_AgentClass clsdbo_Agent = dbo_AgentDataClass.Select_Record(user_class.CV_CODE);
if (user_class.User_Group_ID != "Agent")
{
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "SAM", "history.back();", true);
}
btnSearchSubmit_Click(sender, e);
}
txtStartDate.Text = DateTime.Now.ToShortDateString();
txtEndDate.Text = DateTime.Now.ToShortDateString();
}
private void InsertRecord()
{
logger.Info(HttpContext.Current.Request.Cookies["User_ID"].Value + " " + System.Reflection.MethodBase.GetCurrentMethod().DeclaringType.ToString() + " " + System.Reflection.MethodBase.GetCurrentMethod().Name);
dbo_UserClass clsdbo_User = new dbo_UserClass();
string User_ID = HttpContext.Current.Request.Cookies["User_ID"].Value;
SetDataCP(clsdbo_User);
bool success = false;
success = dbo_UserDataClass.Add(clsdbo_User, User_ID);
if (success)
{
Show("บันทึกสำเร็จ!");
}
}
protected void btnSearchSubmit_Click(object sender, EventArgs e)
{
logger.Info(HttpContext.Current.Request.Cookies["User_ID"].Value + " " + System.Reflection.MethodBase.GetCurrentMethod().DeclaringType.ToString() + " " + System.Reflection.MethodBase.GetCurrentMethod().Name);
string User_ID = HttpContext.Current.Request.Cookies["User_ID"].Value;
dbo_UserClass user_class = dbo_UserDataClass.Select_Record(User_ID);
try
{
DateTime?Post_Date_Begin = null;
DateTime?Post_Date_End = null;
if (!string.IsNullOrEmpty(txtStartDate.Text))
{
Post_Date_Begin = DateTime.Parse(txtStartDate.Text);
}
if (!string.IsNullOrEmpty(txtEndDate.Text))
{
Post_Date_End = DateTime.Parse(txtEndDate.Text);
}
List <dbo_RevenueExpenseClass> item = dbo_RevenueExpenseDataClass.GetRevenueExpense(Post_Date_Begin, Post_Date_End, user_class.CV_CODE);
if (item.Count > 0)
{
GridViewRevenue_Expense.DataSource = item;
GridViewRevenue_Expense.DataBind();
GridViewRevenue_Expense.Visible = true;
pnlNoRec.Visible = false;
}
else
{
GridViewRevenue_Expense.Visible = false;
pnlNoRec.Visible = true;
}
System.Threading.Thread.Sleep(500);
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "SAMWAIT", "myApp.hidePleaseWait();", true);
}
catch (Exception ex)
{
logger.Error(ex.Message);
}
}
protected void Page_Load(object sender, EventArgs e)
{
bool flag = false;
try
{
if (!IsPostBack)
{
string User_ID = HttpContext.Current.Request.Cookies["User_ID"].Value;
dbo_UserClass user = dbo_UserDataClass.Select_Record(User_ID);
txtUserName.Value = user.Username;
}
}
catch (Exception ex)
{
logger.Error(ex.Message);
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
dbo_UserClass user_class = dbo_UserDataClass.Select_Record(Request.Cookies["User_ID"].Value);
if (user_class.User_Group_ID != "Agent")
{
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "SAM", "history.back();", true);
}
else
{
dbo_AgentClass agent = dbo_AgentDataClass.Select_Record(user_class.CV_CODE);
label_agent_name.Text = agent.AgentName;
show_grid(user_class.CV_CODE);
lblValue.Text = System.Convert.ToString(string.Format("{0:#,##0.00}", Grand_Total));
}
}
}
protected void btnPrint_Click(object sender, EventArgs e)
{
string User_ID = Request.Cookies["User_ID"].Value;
dbo_UserClass user_class = dbo_UserDataClass.Select_Record(User_ID);
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "SAMWAIT", "myApp.hidePleaseWait();", true);
System.Threading.Thread.Sleep(500);
string AgentName = ddlAgentName.SelectedValue;
string Region = ddlSearchRegion.SelectedItem.ToString();
if (Region == "เลือกทั้งหมด")
{
Region = string.Empty;
}
if (AgentName == "เลือกทั้งหมด")
{
AgentName = string.Empty;
}
List <RPT_SUMM_MEMBER__41210> rt_RPT_SUMM_MEMBER = new List <RPT_SUMM_MEMBER__41210>();
rt_RPT_SUMM_MEMBER = Reports.RPT_SUMM_MEMBER__41210(Region, AgentName, string.Empty, string.Empty
, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, User_ID);
if (rt_RPT_SUMM_MEMBER.Count > 0)
{
string url = "../Report/ReportViewer.aspx?RPT=ReportCustomerType&Region="
+ ddlSearchRegion.SelectedItem.ToString() + "&User_ID=" + User_ID + "&AgentName=" + ddlAgentName.SelectedValue;
string s = "window.open('" + url + "', 'popup_window', 'width=1024,height=768,left=100,top=100,resizable=yes');";
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "SAM", s, true);
}
else
{
Messages.Show("ไม่พบข้อมูล กรุณาเลือกเงื่อนไขอีกครั้ง", this.Page);
}
}
private void DisplayReportCustomerPayoutType()
{
List <RPT_Customer_PAY_TYPE_41212> rt_RPT_PAY_TYPE = new List <RPT_Customer_PAY_TYPE_41212>();
rt_RPT_PAY_TYPE = Reports.RPT_Customer_PAY_TYPE_41212(Region, AgentName, CustomerID, CustomerName, SPName, string.Empty, Status, PaymentType, string.Empty, string.Empty, string.Empty);
foreach (var d in rt_RPT_PAY_TYPE)
{
d.paramRegion_Name = Request.QueryString["Region"];
if (d.paramRegion_Name == "")
{
d.paramRegion_Name = "เลือกทั้งหมด";
}
d.paramCV_Name = Request.QueryString["AgentName"];
if (d.paramCV_Name != "")
{
user_class = dbo_UserDataClass.Select_Record(d.paramCV_Name);
d.paramCV_Name = user_class.AgentName;
}
d.Customer_Name = Request.QueryString["CustomerName"];
d.paramSP_Name = Request.QueryString["SPName"];
d.paramStatus = Request.QueryString["Status"];
d.paramCustomer_ID = Request.QueryString["CustomerID"];
d.paramPayType = Request.QueryString["PaymentType"];
}
cryRpt.Load(Server.MapPath("~/Report/RT_ReportCustomerPayoutType.rpt"));
cryRpt.SetDataSource(rt_RPT_PAY_TYPE);
BinaryReader stream = new BinaryReader(cryRpt.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat));
Response.ClearContent();
Response.ClearHeaders();
Response.ContentType = "application/pdf";
Response.BinaryWrite(stream.ReadBytes(Convert.ToInt32(stream.BaseStream.Length)));
Response.Flush();
Response.Close();
}
private void SetUpDrowDownList()
{
logger.Info(HttpContext.Current.Request.Cookies["User_ID"].Value + " " + System.Reflection.MethodBase.GetCurrentMethod().DeclaringType.ToString() + " " + System.Reflection.MethodBase.GetCurrentMethod().Name);
try
{
string User_ID = Request.Cookies["User_ID"].Value;
dbo_UserClass user_class = dbo_UserDataClass.Select_Record(User_ID);
if (user_class.User_Group_ID == "CP Meiji")
{
//ddlSearchRegion
String strString = user_class.Region;
String[] myArr = strString.Split(',');
Dictionary <string, string> region = dbo_ItemDataClass.GetDropDown_Report("07");
ddlSearchRegion.DataSource = region.Where(f => myArr.Contains(f.Value));
ddlSearchRegion.DataBind();
ddlSearchRegion.Items.Insert(0, "เลือกทั้งหมด");
if (ddlSearchRegion.SelectedIndex == 0)
{
String[] region_tmp = region.Where(f => myArr.Contains(f.Value)).Select(f => f.Value).ToArray();
//ddlAgentName
List <dbo_AgentClass> agent = dbo_AgentDataClass.Search(string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, "Active", string.Empty);
List <dbo_AgentClass> cv_code1 = new List <dbo_AgentClass>(agent.Where(f => f.DM_ID == User_ID || f.GM_ID == User_ID.Trim() || f.SD_ID == User_ID.Trim() || f.SM_ID == User_ID.Trim() || f.APV_ID == User_ID.Trim()).Select(f => f));
if (cv_code1.Count > 0)
{
ddlAgentName.DataSource = cv_code1;
ddlAgentName.DataBind();
ddlAgentName.Items.Insert(0, "เลือกทั้งหมด");
}
else
{
ddlAgentName.DataSource = agent.Where(f => region_tmp.Contains(f.Location_Region)).OrderBy(f => f.CV_AgentName);
ddlAgentName.DataBind();
ddlAgentName.Items.Insert(0, "เลือกทั้งหมด");
}
}
}
else
{
//ddlSearchRegion
List <dbo_AgentClass> agent = dbo_AgentDataClass.Search(string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, "Active", string.Empty);
String[] rg = agent.Where(f => f.CV_Code == user_class.CV_CODE.Trim()).Select(f => f.Location_Region).ToArray();
Dictionary <string, string> region = dbo_ItemDataClass.GetDropDown_Report("07");
ddlSearchRegion.DataSource = region.Where(f => rg.Contains(f.Value));
ddlSearchRegion.DataBind();
ddlSearchRegion.Enabled = false;
//ddlAgentName
//List<dbo_AgentClass> agent = dbo_AgentDataClass.Search(string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, "Active", string.Empty);
ddlAgentName.DataSource = agent.Where(f => f.CV_Code == user_class.CV_CODE.Trim());
ddlAgentName.DataBind();
ddlAgentName.Enabled = false;
}
//ddl_ProductGroup
List <dbo_ProductClass> ProductGroup = dbo_ProductDataClass.Search(string.Empty, string.Empty, string.Empty, null, string.Empty).GroupBy(f => f.Product_group_ID).Select(grb => grb.First()).ToList();
dbo_ProductClass b = new dbo_ProductClass();
dbo_ProductClass c1 = new dbo_ProductClass();
b.Product_group_ID = "เลือกทั้งหมด";
c1.Product_group_ID = "อื่นๆ";
ProductGroup.Insert(0, b);
ProductGroup.Insert(ProductGroup.Count, c1);
ddl_ProductGroup.DataSource = ProductGroup;
ddl_ProductGroup.DataBind();
ddl_ProductGroup.SelectedIndex = 0;
ddl_Size.Items.Insert(0, "เลือกทั้งหมด");
ddl_Size.SelectedIndex = 0;
ddlProductName.Items.Insert(0, "เลือกทั้งหมด");
ddlProductName.SelectedIndex = 0;
txtInvoiceDateFrom.Text = DateTime.Now.ToShortDateString();
txtInvoiceDateTo.Text = DateTime.Now.ToShortDateString();
}
catch (Exception ex)
{
logger.Error(ex);
}
}
private void SetUpDrowDownList()
{
logger.Info(HttpContext.Current.Request.Cookies["User_ID"].Value + " " + System.Reflection.MethodBase.GetCurrentMethod().DeclaringType.ToString() + " " + System.Reflection.MethodBase.GetCurrentMethod().Name);
try
{
string User_ID = Request.Cookies["User_ID"].Value;
dbo_UserClass user_class = dbo_UserDataClass.Select_Record(User_ID);
if (user_class.User_Group_ID == "CP Meiji")
{
//ddlSearchRegion
String strString = user_class.Region;
String[] myArr = strString.Split(',');
Dictionary <string, string> region = dbo_ItemDataClass.GetDropDown("07");
ddlSearchRegion.DataSource = region.Where(f => myArr.Contains(f.Value));
ddlSearchRegion.DataBind();
ddlSearchRegion.Items.Insert(0, "เลือกทั้งหมด");
if (ddlSearchRegion.SelectedIndex == 0)
{
String[] region_tmp = region.Where(f => myArr.Contains(f.Value)).Select(f => f.Value).ToArray();
//ddlAgentName
List <dbo_AgentClass> agent = dbo_AgentDataClass.Search(string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, "Active", string.Empty);
List <dbo_AgentClass> cv_code1 = new List <dbo_AgentClass>(agent.Where(f => f.DM_ID == User_ID || f.GM_ID == User_ID.Trim() || f.SD_ID == User_ID.Trim() || f.SM_ID == User_ID.Trim() || f.APV_ID == User_ID.Trim()).Select(f => f));
if (cv_code1.Count > 0)
{
ddlAgentName.DataSource = cv_code1;
ddlAgentName.DataBind();
ddlAgentName.Items.Insert(0, "เลือกทั้งหมด");
}
else
{
ddlAgentName.DataSource = agent.Where(f => region_tmp.Contains(f.Location_Region)).OrderBy(f => f.CV_AgentName);
ddlAgentName.DataBind();
ddlAgentName.Items.Insert(0, "เลือกทั้งหมด");
}
ddl_SPName.Items.Insert(0, "เลือกทั้งหมด");
}
}
else
{
//ddlSearchRegion
List <dbo_AgentClass> agent = dbo_AgentDataClass.Search(string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, "Active", string.Empty);
String[] rg = agent.Where(f => f.CV_Code == user_class.CV_CODE.Trim()).Select(f => f.Location_Region).ToArray();
Dictionary <string, string> region = dbo_ItemDataClass.GetDropDown_Report("07");
ddlSearchRegion.DataSource = region.Where(f => rg.Contains(f.Value));
ddlSearchRegion.DataBind();
ddlSearchRegion.Enabled = false;
//ddlAgentName
//List<dbo_AgentClass> agent = dbo_AgentDataClass.Search(string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, "Active", string.Empty);
ddlAgentName.DataSource = agent.Where(f => f.CV_Code == user_class.CV_CODE.Trim());
ddlAgentName.DataBind();
ddlAgentName.Enabled = false;
//ddl_SPName
List <dbo_UserClass> users = dbo_UserDataClass.Search(string.Empty, string.Empty, string.Empty, string.Empty
, string.Empty, string.Empty, string.Empty, ddlAgentName.SelectedValue, null, string.Empty, string.Empty);
users.Where(f => f.User_Group_ID == "Agent" && f.Status == "Active" && f.Position == "สาวส่งนม" || f.Position == "ซุปเปอร์ไวซ์เซอร์").OrderBy(f => f.AgentName);
ddl_SPName.DataSource = users.OrderBy(f => f.FullName_ddl);
ddl_SPName.DataBind();
ddl_SPName.Items.Insert(0, "เลือกทั้งหมด");
}
//ddl_Status
List <dbo_CustomerClass> CustomerStatus = dbo_CustomerDataClass.Search(string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty);
ddl_Status.DataSource = CustomerStatus.Where(f => f.Status != null).GroupBy(f => f.Status).Select(f => f.First()).OrderBy(f => f.Status);
ddl_Status.DataBind();
ddl_Status.Items.Insert(0, "เลือกทั้งหมด");
ddl_SPName.SelectedIndex = 0;
ddlPaymentType.SelectedIndex = 0;
}
catch (Exception ex)
{
logger.Error(ex.Message);
}
}
private void SetUpDrowDownList()
{
logger.Info(HttpContext.Current.Request.Cookies["User_ID"].Value + " " + System.Reflection.MethodBase.GetCurrentMethod().DeclaringType.ToString() + " " + System.Reflection.MethodBase.GetCurrentMethod().Name);
try
{
string User_ID = Request.Cookies["User_ID"].Value;
dbo_UserClass user_class = dbo_UserDataClass.Select_Record(User_ID);
if (user_class.User_Group_ID == "CP Meiji")
{
//ddlSearchRegion
String strString = user_class.Region;
String[] myArr = strString.Split(',');
Dictionary <string, string> region = dbo_ItemDataClass.GetDropDown("07");
ddlSearchRegion.DataSource = region.Where(f => myArr.Contains(f.Value));
ddlSearchRegion.DataBind();
ddlSearchRegion.Items.Insert(0, "เลือกทั้งหมด");
if (ddlSearchRegion.SelectedIndex == 0)
{
//ddlAgentName
List <dbo_AgentClass> agent = dbo_AgentDataClass.Search(string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, "Active", string.Empty);
String[] region_tmp = region.Where(f => myArr.Contains(f.Value)).Select(f => f.Value).ToArray();
String[] agent_tmp1 = agent.Where(f => f.DM_ID == User_ID || f.GM_ID == User_ID.Trim() || f.SD_ID == User_ID.Trim() || f.SM_ID == User_ID.Trim() || f.APV_ID == User_ID.Trim()).Select(f => f.CV_Code).ToArray();
if (agent_tmp1.Length > 0)
{
ddlAgentName.DataSource = agent.Where(f => agent_tmp1.Contains(f.CV_Code)).OrderBy(f => f.CV_AgentName);
ddlAgentName.DataBind();
ddlAgentName.Items.Insert(0, "เลือกทั้งหมด");
}
else
{
ddlAgentName.DataSource = agent.Where(f => region_tmp.Contains(f.Location_Region)).OrderBy(f => f.CV_AgentName);
ddlAgentName.DataBind();
ddlAgentName.Items.Insert(0, "เลือกทั้งหมด");
}
}
}
else
{
//ddlSearchRegion
List <dbo_AgentClass> agent = dbo_AgentDataClass.Search(string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, "Active", string.Empty);
String[] rg = agent.Where(f => f.CV_Code == user_class.CV_CODE.Trim()).Select(f => f.Location_Region).ToArray();
Dictionary <string, string> region = dbo_ItemDataClass.GetDropDown_Report("07");
ddlSearchRegion.DataSource = region.Where(f => rg.Contains(f.Value));
ddlSearchRegion.DataBind();
ddlSearchRegion.Enabled = false;
//ddlAgentName
//List<dbo_AgentClass> agent = dbo_AgentDataClass.Search(string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, "Active", string.Empty);
ddlAgentName.DataSource = agent.Where(f => f.CV_Code == user_class.CV_CODE.Trim());
ddlAgentName.DataBind();
ddlAgentName.Enabled = false;
}
CultureInfo ThaiCulture = new CultureInfo("th-TH");
DateTime DtNow = new DateTime();
DtNow = DateTime.Now;
txt_Year.Text = (DtNow.ToString("yyyy", ThaiCulture));
}
catch (Exception ex)
{
logger.Error(ex);
}
}
