public static dbo_RevenueExpenseClass SumBySP(string User_ID)
{
dbo_RevenueExpenseClass clsdbo_RevenueExpense = new dbo_RevenueExpenseClass();
SqlConnection connection = SAMDataClass.GetConnection();
string selectProcedure = "[dbo].[RevenueExpenseSumBySP]";
SqlCommand selectCommand = new SqlCommand(selectProcedure, connection);
selectCommand.CommandType = CommandType.StoredProcedure;
selectCommand.Parameters.AddWithValue("@User_ID", User_ID);
try
{
connection.Open();
SqlDataReader reader
= selectCommand.ExecuteReader(CommandBehavior.SingleRow);
if (reader.Read())
{
clsdbo_RevenueExpense.Amount = reader["Amount"] is DBNull ? null : (Decimal?)reader["Amount"];
}
else
{
clsdbo_RevenueExpense = null;
}
reader.Close();
}
catch (SqlException)
{
return(clsdbo_RevenueExpense);
}
finally
{
connection.Close();
}
return(clsdbo_RevenueExpense);
}
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();
}
}
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();
}
}
protected void GridViewExpense_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
logger.Info(HttpContext.Current.Request.Cookies["User_ID"].Value + " " + System.Reflection.MethodBase.GetCurrentMethod().DeclaringType.ToString() + " " + System.Reflection.MethodBase.GetCurrentMethod().Name);
try
{
int RowIndex = Convert.ToInt32((e.RowIndex).ToString());
Label _Account_No = (Label)GridViewExpense.Rows[RowIndex].FindControl("lblAccount_No");
DropDownList _ddlEditDetail = (DropDownList)GridViewExpense.Rows[RowIndex].FindControl("ddlEditDetail");
TextBox _txtEditRevenue_Amount = (TextBox)GridViewExpense.Rows[RowIndex].FindControl("txtEdit_Amount");
TextBox _txtEditRemark = (TextBox)GridViewExpense.Rows[RowIndex].FindControl("txtEditRemark");
dbo_RevenueExpenseClass st = new dbo_RevenueExpenseClass();
st = dbo_RevenueExpenseDataClass.Select_Record(_Account_No.Text);
st.Amount = _txtEditRevenue_Amount.Text == "" ? 0 : Decimal.Parse(_txtEditRevenue_Amount.Text.Replace(",", string.Empty));
st.Remark = _txtEditRemark.Text;
bool success = false;
string User_ID = HttpContext.Current.Request.Cookies["User_ID"].Value;
success = dbo_RevenueExpenseDataClass.Update(st);
if (success)
{
System.Threading.Thread.Sleep(500);
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "SAMWAIT", "myApp.hidePleaseWait();", true);
Show("บันทึกสำเร็จ!");
}
InitialExpense();
System.Threading.Thread.Sleep(500);
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "SAMWAIT", "myApp.hidePleaseWait();", true);
}
catch (Exception ex)
{
logger.Error(ex.Message);
}
}
/*
* public static dbo_RevenueExpenseClass Select_Record(dbo_RevenueExpenseClass clsdbo_RevenueExpensePara)
* {
* dbo_RevenueExpenseClass clsdbo_RevenueExpense = new dbo_RevenueExpenseClass();
* SqlConnection connection = SAMDataClass.GetConnection();
* string selectProcedure = "[dbo].[RevenueExpenseSelect]";
* SqlCommand selectCommand = new SqlCommand(selectProcedure, connection);
* selectCommand.CommandType = CommandType.StoredProcedure;
* selectCommand.Parameters.AddWithValue("@Post_Date", clsdbo_RevenueExpensePara.Post_Date);
* try
* {
* connection.Open();
* SqlDataReader reader
* = selectCommand.ExecuteReader(CommandBehavior.SingleRow);
* if (reader.Read())
* {
* clsdbo_RevenueExpense.Post_Date = reader["Post_Date"] is DBNull ? null : (DateTime?)reader["Post_Date"];
* clsdbo_RevenueExpense.Post_No = reader["Post_No"] is DBNull ? null : reader["Post_No"].ToString();
* clsdbo_RevenueExpense.Account_No = reader["Account_No"] is DBNull ? null : reader["Account_No"].ToString();
* clsdbo_RevenueExpense.Account_Code = reader["Account_Code"] is DBNull ? null : reader["Account_Code"].ToString();
* clsdbo_RevenueExpense.Amount = reader["Amount"] is DBNull ? null : (Decimal?)reader["Amount"];
* clsdbo_RevenueExpense.Remark = reader["Remark"] is DBNull ? null : reader["Remark"].ToString();
* }
* else
* {
* clsdbo_RevenueExpense = null;
* }
* reader.Close();
* }
* catch (SqlException)
* {
* return clsdbo_RevenueExpense;
* }
* finally
* {
* connection.Close();
* }
* return clsdbo_RevenueExpense;
* }*/
public static dbo_RevenueExpenseClass Select_Record(string Account_No)
{
dbo_RevenueExpenseClass clsdbo_RevenueExpense = new dbo_RevenueExpenseClass();
SqlConnection connection = SAMDataClass.GetConnection();
string selectProcedure = "[dbo].[RevenueExpenseSelectbyAccountNo]";
SqlCommand selectCommand = new SqlCommand(selectProcedure, connection);
selectCommand.CommandType = CommandType.StoredProcedure;
selectCommand.Parameters.AddWithValue("@Account_No", Account_No);
try
{
connection.Open();
SqlDataReader reader
= selectCommand.ExecuteReader(CommandBehavior.SingleRow);
if (reader.Read())
{
clsdbo_RevenueExpense.Post_Date = reader["Post_Date"] is DBNull ? null : (DateTime?)reader["Post_Date"];
clsdbo_RevenueExpense.Post_No = reader["Post_No"] is DBNull ? null : reader["Post_No"].ToString();
clsdbo_RevenueExpense.Account_No = reader["Account_No"] is DBNull ? null : reader["Account_No"].ToString();
clsdbo_RevenueExpense.Account_Code = reader["Account_Code"] is DBNull ? null : reader["Account_Code"].ToString();
clsdbo_RevenueExpense.Amount = reader["Amount"] is DBNull ? null : (Decimal?)reader["Amount"];
clsdbo_RevenueExpense.Remark = reader["Remark"] is DBNull ? null : reader["Remark"].ToString();
}
else
{
clsdbo_RevenueExpense = null;
}
reader.Close();
}
catch (SqlException)
{
return(clsdbo_RevenueExpense);
}
finally
{
connection.Close();
}
return(clsdbo_RevenueExpense);
}
public static bool Update(dbo_RevenueExpenseClass newdbo_RevenueExpenseClass)
{
SqlConnection connection = SAMDataClass.GetConnection();
string updateProcedure = "[dbo].[RevenueExpenseUpdate]";
SqlCommand updateCommand = new SqlCommand(updateProcedure, connection);
updateCommand.CommandType = CommandType.StoredProcedure;
if (newdbo_RevenueExpenseClass.Post_Date.HasValue == true)
{
updateCommand.Parameters.AddWithValue("@NewPost_Date", newdbo_RevenueExpenseClass.Post_Date);
}
else
{
updateCommand.Parameters.AddWithValue("@NewPost_Date", DBNull.Value);
}
if (newdbo_RevenueExpenseClass.Post_No != null)
{
updateCommand.Parameters.AddWithValue("@NewPost_No", newdbo_RevenueExpenseClass.Post_No);
}
else
{
updateCommand.Parameters.AddWithValue("@NewPost_No", DBNull.Value);
}
if (newdbo_RevenueExpenseClass.Account_No != null)
{
updateCommand.Parameters.AddWithValue("@NewAccount_No", newdbo_RevenueExpenseClass.Account_No);
}
else
{
updateCommand.Parameters.AddWithValue("@NewAccount_No", DBNull.Value);
}
if (newdbo_RevenueExpenseClass.Account_Code != null)
{
updateCommand.Parameters.AddWithValue("@NewAccount_Code", newdbo_RevenueExpenseClass.Account_Code);
}
else
{
updateCommand.Parameters.AddWithValue("@NewAccount_Code", DBNull.Value);
}
if (newdbo_RevenueExpenseClass.Amount.HasValue == true)
{
updateCommand.Parameters.AddWithValue("@NewAmount", newdbo_RevenueExpenseClass.Amount);
}
else
{
updateCommand.Parameters.AddWithValue("@NewAmount", DBNull.Value);
}
if (newdbo_RevenueExpenseClass.Remark != null)
{
updateCommand.Parameters.AddWithValue("@NewRemark", newdbo_RevenueExpenseClass.Remark);
}
else
{
updateCommand.Parameters.AddWithValue("@NewRemark", DBNull.Value);
}
/*if (olddbo_RevenueExpenseClass.Post_Date.HasValue == true)
* {
* updateCommand.Parameters.AddWithValue("@OldPost_Date", olddbo_RevenueExpenseClass.Post_Date);
* }
* else
* {
* updateCommand.Parameters.AddWithValue("@OldPost_Date", DBNull.Value);
* }
* if (olddbo_RevenueExpenseClass.Post_No != null)
* {
* updateCommand.Parameters.AddWithValue("@OldPost_No", olddbo_RevenueExpenseClass.Post_No);
* }
* else
* {
* updateCommand.Parameters.AddWithValue("@OldPost_No", DBNull.Value);
* }
* if (olddbo_RevenueExpenseClass.Account_No != null)
* {
* updateCommand.Parameters.AddWithValue("@OldAccount_No", olddbo_RevenueExpenseClass.Account_No);
* }
* else
* {
* updateCommand.Parameters.AddWithValue("@OldAccount_No", DBNull.Value);
* }
* if (olddbo_RevenueExpenseClass.Account_Code != null)
* {
* updateCommand.Parameters.AddWithValue("@OldAccount_Code", olddbo_RevenueExpenseClass.Account_Code);
* }
* else
* {
* updateCommand.Parameters.AddWithValue("@OldAccount_Code", DBNull.Value);
* }
* if (olddbo_RevenueExpenseClass.Amount.HasValue == true)
* {
* updateCommand.Parameters.AddWithValue("@OldAmount", olddbo_RevenueExpenseClass.Amount);
* }
* else
* {
* updateCommand.Parameters.AddWithValue("@OldAmount", DBNull.Value);
* }*/
updateCommand.Parameters.Add("@ReturnValue", System.Data.SqlDbType.Int);
updateCommand.Parameters["@ReturnValue"].Direction = ParameterDirection.Output;
try
{
connection.Open();
updateCommand.ExecuteNonQuery();
int count = System.Convert.ToInt32(updateCommand.Parameters["@ReturnValue"].Value);
if (count > 0)
{
return(true);
}
else
{
return(false);
}
}
catch (SqlException)
{
return(false);
}
finally
{
connection.Close();
}
}
public static bool AddSP(dbo_RevenueExpenseClass clsdbo_RevenueExpense)
{
logger.Info(System.Web.HttpContext.Current.Request.Cookies["User_ID"].Value + " " + System.Reflection.MethodBase.GetCurrentMethod().DeclaringType.ToString() + " " + System.Reflection.MethodBase.GetCurrentMethod().Name);
SqlConnection connection = SAMDataClass.GetConnection();
string insertProcedure = "[RevenueExpenseInsertAddSP]";
SqlCommand insertCommand = new SqlCommand(insertProcedure, connection);
insertCommand.CommandType = CommandType.StoredProcedure;
if (clsdbo_RevenueExpense.Post_Date.HasValue == true)
{
insertCommand.Parameters.AddWithValue("@Post_Date", clsdbo_RevenueExpense.Post_Date);
}
else
{
insertCommand.Parameters.AddWithValue("@Post_Date", DBNull.Value);
}
if (clsdbo_RevenueExpense.Post_No != null)
{
insertCommand.Parameters.AddWithValue("@Post_No", clsdbo_RevenueExpense.Post_No);
}
else
{
insertCommand.Parameters.AddWithValue("@Post_No", DBNull.Value);
}
if (clsdbo_RevenueExpense.Account_No != null)
{
insertCommand.Parameters.AddWithValue("@Account_No", clsdbo_RevenueExpense.Account_No);
}
else
{
insertCommand.Parameters.AddWithValue("@Account_No", DBNull.Value);
}
if (clsdbo_RevenueExpense.Account_Code != null)
{
insertCommand.Parameters.AddWithValue("@Account_Code", clsdbo_RevenueExpense.Account_Code);
}
else
{
insertCommand.Parameters.AddWithValue("@Account_Code", DBNull.Value);
}
if (clsdbo_RevenueExpense.Amount.HasValue == true)
{
insertCommand.Parameters.AddWithValue("@Amount", clsdbo_RevenueExpense.Amount);
}
else
{
insertCommand.Parameters.AddWithValue("@Amount", DBNull.Value);
}
if (clsdbo_RevenueExpense.Remark != null)
{
insertCommand.Parameters.AddWithValue("@Remark", clsdbo_RevenueExpense.Remark);
}
else
{
insertCommand.Parameters.AddWithValue("@Remark", DBNull.Value);
}
if (clsdbo_RevenueExpense.CV_Code != null)
{
insertCommand.Parameters.AddWithValue("@CV_Code", clsdbo_RevenueExpense.CV_Code);
}
else
{
insertCommand.Parameters.AddWithValue("@CV_Code", DBNull.Value);
}
if (clsdbo_RevenueExpense.User_ID != null)
{
insertCommand.Parameters.AddWithValue("@User_ID", clsdbo_RevenueExpense.User_ID);
}
else
{
insertCommand.Parameters.AddWithValue("@User_ID", DBNull.Value);
}
insertCommand.Parameters.Add("@ReturnValue", System.Data.SqlDbType.Int);
insertCommand.Parameters["@ReturnValue"].Direction = ParameterDirection.Output;
try
{
connection.Open();
insertCommand.ExecuteNonQuery();
int count = System.Convert.ToInt32(insertCommand.Parameters["@ReturnValue"].Value);
if (count > 0)
{
return(true);
}
else
{
return(false);
}
}
catch (SqlException)
{
return(false);
}
finally
{
connection.Close();
}
}
protected void btnSaveSubmit_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
{
if (txtRequisition_Amount.Text == string.Empty)
{
System.Threading.Thread.Sleep(500);
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "SAMWAIT", "myApp.hidePleaseWait();", true);
Show("กรุณาระบุจำนวนเงิน");
}
//else if (Convert.ToDecimal(txtRequisition_Amount.Text) > Convert.ToDecimal(txtTotalBalanceOutstanding.Text))
//{
// System.Threading.Thread.Sleep(500);
// ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "SAMWAIT", "myApp.hidePleaseWait();", true);
// Show("ไม่สามารถเบิกค่าคอมมิชชั่นเกินยอดหนี้คงค้างได้");
//}
else
{
dbo_UserClass user_class = dbo_UserDataClass.Select_Record(HttpContext.Current.Request.Cookies["User_ID"].Value);
dbo_CommissionRequisitionClass com_req = new dbo_CommissionRequisitionClass();
com_req.Commission_requisition_no = GenerateID.Commission_requisition_no(user_class.CV_CODE);
com_req.Commission_Requisition_Date = DateTime.Now;
com_req.Requisition_Amount = decimal.Parse(string.IsNullOrEmpty(txtRequisition_Amount.Text) ? "0" : txtRequisition_Amount.Text);
// string user_id = ddl_SPName.SelectedIndex == 0 ? string.Empty : ddl_SPName.SelectedValue;
//List<dbo_DebtClass> listofdebt = dbo_DebtDataClass.Search(user_id, string.Empty);
int index = 1;
// decimal init_debt = decimal.Parse(txtTotalBalanceOutstanding.Text);
// decimal? check_init = 0;
decimal? cal_com = decimal.Parse(txtRequisition_Amount.Text);
HiddenField hdf = new HiddenField();
hdf.Value = string.Empty;
string user_id = string.Empty;
foreach (GridViewRow currentRow in grdCommissionRequisition.Rows)
{
if (cal_com > 0)
{
CheckBox chk = (CheckBox)currentRow.FindControl("chkAll");
if (chk.Checked)
{
Label lblClearing_No = (Label)currentRow.FindControl("lblClearing_No");
logger.Debug("lblClearing_No.Text " + lblClearing_No.Text);
Label lblCommissionAmount = (Label)currentRow.FindControl("lblCommissionAmount");
logger.Debug("lblCommissionAmount.Text " + lblCommissionAmount.Text);
logger.Debug("cal_com " + cal_com);
hdf = (HiddenField)currentRow.FindControl("hdfUser_ID");
if (!string.IsNullOrEmpty(lblClearing_No.Text))
{
List <dbo_RequisitionClearingClass> rc = dbo_RequisitionClearingDataClass.Search(lblClearing_No.Text, string.Empty,
string.Empty, null, null, null, null, user_class.CV_CODE);
//decimal? to_req = decimal.Parse(lblCommissionAmount.Text);
decimal?to_req = cal_com;
foreach (dbo_RequisitionClearingClass rc_ in rc)
{
logger.Debug(rc_.Requisition_No);
List <dbo_CommissionClass> com = dbo_CommissionDataClass.Select_Record(rc_.Requisition_No);
logger.Debug("** " + com[0].Commission_Balance_Outstanding + " , " + to_req + " **");
logger.Debug("com[0].Commission_Balance_Outstanding <= to_req");
if (com[0].Commission_Balance_Outstanding <= to_req)
{
dbo_CommissionRequisitionDtlClass detail = new dbo_CommissionRequisitionDtlClass();
detail.Clearing_No = lblClearing_No.Text;
detail.Commission = decimal.Parse(lblCommissionAmount.Text);
detail.Requisition_Amount = com[0].Commission_Balance_Outstanding;
detail.Commission_requisition_no = com_req.Commission_requisition_no + index.ToString("00");
index++;
dbo_CommissionRequisitionDtlDataClass.Add(detail, HttpContext.Current.Request.Cookies["User_ID"].Value);
if (com.Count > 0)
{
com[0].Commission_Requisition_Status = 3;
logger.Debug("com[0].Commission_Requisition_Status " + com[0].Commission_Requisition_Status);
to_req = to_req - com[0].Commission_Balance_Outstanding;
logger.Debug("to_req update " + to_req);
com[0].Commission_Balance_Outstanding = 0;
logger.Debug("com[0].Commission_Balance_Outstanding " + com[0].Commission_Balance_Outstanding);
dbo_CommissionDataClass.Update(com[0], HttpContext.Current.Request.Cookies["User_ID"].Value);
// break;
}
}
else
{
dbo_CommissionRequisitionDtlClass detail = new dbo_CommissionRequisitionDtlClass();
detail.Clearing_No = lblClearing_No.Text;
detail.Commission = decimal.Parse(lblCommissionAmount.Text);
detail.Requisition_Amount = to_req;
detail.Commission_requisition_no = com_req.Commission_requisition_no + index.ToString("00");
index++;
dbo_CommissionRequisitionDtlDataClass.Add(detail, HttpContext.Current.Request.Cookies["User_ID"].Value);
if (com.Count > 0)
{
com[0].Commission_Requisition_Status = 2;
logger.Debug("com[0].Commission_Requisition_Status " + com[0].Commission_Requisition_Status);
to_req = com[0].Commission_Balance_Outstanding - to_req;
logger.Debug("to_req update " + to_req);
// com[0].Commission_Balance_Outstanding = detail.Commission - detail.Requisition_Amount;
com[0].Commission_Balance_Outstanding = com[0].Commission_Balance_Outstanding - detail.Requisition_Amount;
logger.Debug("com[0].Commission_Balance_Outstanding " + com[0].Commission_Balance_Outstanding);
dbo_CommissionDataClass.Update(com[0], HttpContext.Current.Request.Cookies["User_ID"].Value);
break;
}
}
}
}
cal_com = cal_com - decimal.Parse(lblCommissionAmount.Text);
}
}
}
dbo_CommissionRequisitionClass total = dbo_ClearingDataClass.Get_Commission_Balance_Outstanding(hdf.Value);
com_req.Total_Balance_Outstanding = total.Total_Balance_Outstanding;
logger.Debug("com_req.Total_Balance_Outstanding " + com_req.Total_Balance_Outstanding);
com_req.Commission_Balance_Outstanding = total.Commission_Balance_Outstanding;
logger.Debug("com_req.Commission_Balance_Outstanding " + com_req.Commission_Balance_Outstanding);
com_req.Total_Credit_Amount = total.Total_Credit_Amount;
logger.Debug("com_req.Total_Credit_Amount " + com_req.Total_Credit_Amount);
dbo_CommissionRequisitionDataClass.Add(com_req, HttpContext.Current.Request.Cookies["User_ID"].Value);
// Show("บันทึกสำเร็จ");
string Post_No = GenerateID.Post_No(user_class.CV_CODE);
dbo_RevenueExpenseClass rev = new dbo_RevenueExpenseClass();
rev.Post_No = Post_No;
rev.CV_Code = user_class.CV_CODE;
rev.Amount = decimal.Parse(txtRequisition_Amount.Text);
rev.Account_Code = "5071";
rev.Account_No = GenerateID.EP(user_class.CV_CODE);
rev.Remark = "";
rev.Post_Date = DateTime.Now;
rev.User_ID = user_id;
dbo_RevenueExpenseDataClass.AddSP(rev);
System.Threading.Thread.Sleep(500);
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "SAMWAIT", "myApp.hidePleaseWait();", true);
string url = "../Report_From/ViewsReport.aspx?RPT=CommissionReqList&PRM=" + com_req.Commission_requisition_no;
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);
btnSearch_2_Submit_Click(null, null);
}
}
catch (Exception ex)
{
logger.Error(ex.Message);
}
}
