public static dbo_CommissionRequisitionClass Select_Record(dbo_CommissionRequisitionClass clsdbo_CommissionRequisitionPara) { dbo_CommissionRequisitionClass clsdbo_CommissionRequisition = new dbo_CommissionRequisitionClass(); SqlConnection connection = SAMDataClass.GetConnection(); string selectProcedure = "[dbo].[CommissionRequisitionSelect]"; SqlCommand selectCommand = new SqlCommand(selectProcedure, connection); selectCommand.CommandType = CommandType.StoredProcedure; selectCommand.Parameters.AddWithValue("@Commission_requisition_no", clsdbo_CommissionRequisitionPara.Commission_requisition_no); try { connection.Open(); SqlDataReader reader = selectCommand.ExecuteReader(CommandBehavior.SingleRow); if (reader.Read()) { clsdbo_CommissionRequisition.Commission_requisition_no = reader["Commission_requisition_no"] is DBNull ? null : reader["Commission_requisition_no"].ToString(); clsdbo_CommissionRequisition.Commission_Requisition_Date = reader["Commission_Requisition_Date"] is DBNull ? null : (DateTime?)reader["Commission_Requisition_Date"]; clsdbo_CommissionRequisition.Last_Modified_By = reader["Last_Modified_By"] is DBNull ? null : reader["Last_Modified_By"].ToString(); clsdbo_CommissionRequisition.Requisition_Amount = reader["Requisition_Amount"] is DBNull ? null : (Decimal?)reader["Requisition_Amount"]; clsdbo_CommissionRequisition.Commission_Balance_Outstanding = reader["Commission_Balance_Outstanding"] is DBNull ? null : (Decimal?)reader["Commission_Balance_Outstanding"]; clsdbo_CommissionRequisition.Total_Balance_Outstanding = reader["Total_Balance_Outstanding"] is DBNull ? null : (Decimal?)reader["Total_Balance_Outstanding"]; clsdbo_CommissionRequisition.Total_Credit_Amount = reader["Total_Credit_Amount"] is DBNull ? null : (Decimal?)reader["Total_Credit_Amount"]; clsdbo_CommissionRequisition.Created_Date = reader["Created_Date"] is DBNull ? null : (DateTime?)reader["Created_Date"]; clsdbo_CommissionRequisition.Last_Modified_Date = reader["Last_Modified_Date"] is DBNull ? null : (DateTime?)reader["Last_Modified_Date"]; clsdbo_CommissionRequisition.Created_By = reader["Created_By"] is DBNull ? null : reader["Created_By"].ToString(); } else { clsdbo_CommissionRequisition = null; } reader.Close(); } catch (SqlException) { return(clsdbo_CommissionRequisition); } finally { connection.Close(); } return(clsdbo_CommissionRequisition); }
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); } }
public static bool Delete(dbo_CommissionRequisitionClass clsdbo_CommissionRequisition) { SqlConnection connection = SAMDataClass.GetConnection(); string deleteProcedure = "[dbo].[CommissionRequisitionDelete]"; SqlCommand deleteCommand = new SqlCommand(deleteProcedure, connection); deleteCommand.CommandType = CommandType.StoredProcedure; if (clsdbo_CommissionRequisition.Commission_requisition_no != null) { deleteCommand.Parameters.AddWithValue("@OldCommission_requisition_no", clsdbo_CommissionRequisition.Commission_requisition_no); } else { deleteCommand.Parameters.AddWithValue("@OldCommission_requisition_no", DBNull.Value); } if (clsdbo_CommissionRequisition.Commission_Requisition_Date.HasValue == true) { deleteCommand.Parameters.AddWithValue("@OldCommission_Requisition_Date", clsdbo_CommissionRequisition.Commission_Requisition_Date); } else { deleteCommand.Parameters.AddWithValue("@OldCommission_Requisition_Date", DBNull.Value); } if (clsdbo_CommissionRequisition.Last_Modified_By != null) { deleteCommand.Parameters.AddWithValue("@OldLast_Modified_By", clsdbo_CommissionRequisition.Last_Modified_By); } else { deleteCommand.Parameters.AddWithValue("@OldLast_Modified_By", DBNull.Value); } if (clsdbo_CommissionRequisition.Requisition_Amount.HasValue == true) { deleteCommand.Parameters.AddWithValue("@OldRequisition_Amount", clsdbo_CommissionRequisition.Requisition_Amount); } else { deleteCommand.Parameters.AddWithValue("@OldRequisition_Amount", DBNull.Value); } if (clsdbo_CommissionRequisition.Commission_Balance_Outstanding.HasValue == true) { deleteCommand.Parameters.AddWithValue("@OldCommission_Balance_Outstanding", clsdbo_CommissionRequisition.Commission_Balance_Outstanding); } else { deleteCommand.Parameters.AddWithValue("@OldCommission_Balance_Outstanding", DBNull.Value); } if (clsdbo_CommissionRequisition.Total_Balance_Outstanding.HasValue == true) { deleteCommand.Parameters.AddWithValue("@OldTotal_Balance_Outstanding", clsdbo_CommissionRequisition.Total_Balance_Outstanding); } else { deleteCommand.Parameters.AddWithValue("@OldTotal_Balance_Outstanding", DBNull.Value); } if (clsdbo_CommissionRequisition.Total_Credit_Amount.HasValue == true) { deleteCommand.Parameters.AddWithValue("@OldTotal_Credit_Amount", clsdbo_CommissionRequisition.Total_Credit_Amount); } else { deleteCommand.Parameters.AddWithValue("@OldTotal_Credit_Amount", DBNull.Value); } if (clsdbo_CommissionRequisition.Created_Date.HasValue == true) { deleteCommand.Parameters.AddWithValue("@OldCreated_Date", clsdbo_CommissionRequisition.Created_Date); } else { deleteCommand.Parameters.AddWithValue("@OldCreated_Date", DBNull.Value); } if (clsdbo_CommissionRequisition.Last_Modified_Date.HasValue == true) { deleteCommand.Parameters.AddWithValue("@OldLast_Modified_Date", clsdbo_CommissionRequisition.Last_Modified_Date); } else { deleteCommand.Parameters.AddWithValue("@OldLast_Modified_Date", DBNull.Value); } if (clsdbo_CommissionRequisition.Created_By != null) { deleteCommand.Parameters.AddWithValue("@OldCreated_By", clsdbo_CommissionRequisition.Created_By); } else { deleteCommand.Parameters.AddWithValue("@OldCreated_By", DBNull.Value); } deleteCommand.Parameters.Add("@ReturnValue", System.Data.SqlDbType.Int); deleteCommand.Parameters["@ReturnValue"].Direction = ParameterDirection.Output; try { connection.Open(); deleteCommand.ExecuteNonQuery(); int count = System.Convert.ToInt32(deleteCommand.Parameters["@ReturnValue"].Value); if (count > 0) { return(true); } else { return(false); } } catch (SqlException) { return(false); } finally { connection.Close(); } }
public static bool Add(dbo_CommissionRequisitionClass clsdbo_CommissionRequisition, String Created_By) { logger.Info(HttpContext.Current.Request.Cookies["User_ID"].Value + " " + System.Reflection.MethodBase.GetCurrentMethod().DeclaringType.ToString() + " " + System.Reflection.MethodBase.GetCurrentMethod().Name); SqlConnection connection = SAMDataClass.GetConnection(); string insertProcedure = "[CommissionRequisitionInsert]"; SqlCommand insertCommand = new SqlCommand(insertProcedure, connection); insertCommand.CommandType = CommandType.StoredProcedure; if (clsdbo_CommissionRequisition.Commission_requisition_no != null) { insertCommand.Parameters.AddWithValue("@Commission_requisition_no", clsdbo_CommissionRequisition.Commission_requisition_no); } else { insertCommand.Parameters.AddWithValue("@Commission_requisition_no", DBNull.Value); } if (clsdbo_CommissionRequisition.Commission_Requisition_Date.HasValue == true) { insertCommand.Parameters.AddWithValue("@Commission_Requisition_Date", clsdbo_CommissionRequisition.Commission_Requisition_Date); } else { insertCommand.Parameters.AddWithValue("@Commission_Requisition_Date", DBNull.Value); } if (clsdbo_CommissionRequisition.Requisition_Amount.HasValue == true) { insertCommand.Parameters.AddWithValue("@Requisition_Amount", clsdbo_CommissionRequisition.Requisition_Amount); } else { insertCommand.Parameters.AddWithValue("@Requisition_Amount", DBNull.Value); } if (clsdbo_CommissionRequisition.Commission_Balance_Outstanding.HasValue == true) { insertCommand.Parameters.AddWithValue("@Commission_Balance_Outstanding", clsdbo_CommissionRequisition.Commission_Balance_Outstanding); } else { insertCommand.Parameters.AddWithValue("@Commission_Balance_Outstanding", DBNull.Value); } if (clsdbo_CommissionRequisition.Total_Balance_Outstanding.HasValue == true) { insertCommand.Parameters.AddWithValue("@Total_Balance_Outstanding", clsdbo_CommissionRequisition.Total_Balance_Outstanding); } else { insertCommand.Parameters.AddWithValue("@Total_Balance_Outstanding", DBNull.Value); } if (clsdbo_CommissionRequisition.Total_Credit_Amount.HasValue == true) { insertCommand.Parameters.AddWithValue("@Total_Credit_Amount", clsdbo_CommissionRequisition.Total_Credit_Amount); } else { insertCommand.Parameters.AddWithValue("@Total_Credit_Amount", DBNull.Value); } if (!string.IsNullOrEmpty(Created_By)) { insertCommand.Parameters.AddWithValue("@Created_By", Created_By); } else { insertCommand.Parameters.AddWithValue("@Created_By", DBNull.Value); } /* * * if (clsdbo_CommissionRequisition.Created_Date.HasValue == true) * { * insertCommand.Parameters.AddWithValue("@Created_Date", clsdbo_CommissionRequisition.Created_Date); * } * else * { * insertCommand.Parameters.AddWithValue("@Created_Date", DBNull.Value); * } * if (clsdbo_CommissionRequisition.Last_Modified_Date.HasValue == true) * { * insertCommand.Parameters.AddWithValue("@Last_Modified_Date", clsdbo_CommissionRequisition.Last_Modified_Date); * } * else * { * insertCommand.Parameters.AddWithValue("@Last_Modified_Date", DBNull.Value); * } * if (clsdbo_CommissionRequisition.Created_By != null) * { * insertCommand.Parameters.AddWithValue("@Created_By", clsdbo_CommissionRequisition.Created_By); * } * else * { * insertCommand.Parameters.AddWithValue("@Created_By", DBNull.Value); * } * if (clsdbo_CommissionRequisition.Last_Modified_By != null) * { * insertCommand.Parameters.AddWithValue("@Last_Modified_By", clsdbo_CommissionRequisition.Last_Modified_By); * } * else * { * insertCommand.Parameters.AddWithValue("@Last_Modified_By", 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 ex) { logger.Error(ex.Message); return(false); } finally { connection.Close(); } }