internal bool ChangeChequeStatusForOutFlow(LumexDBPlayer db, chequeInventoryBLL chequeInventoryBLL, string statusType) { bool status = false; try { db.AddParameters("@Serial", chequeInventoryBLL.chequeSerial.Trim()); db.AddParameters("@CreatedBy", LumexSessionManager.Get("ActiveUserId").ToString().Trim()); db.AddParameters("@CreatedFrom", LumexLibraryManager.GetTerminal()); db.AddParameters("@Trandate",chequeInventoryBLL.Finaldate.Trim()); db.AddParameters("@Naration", chequeInventoryBLL.naration.Trim()); if (statusType == "R") { status = Convert.ToBoolean(db.ExecuteNonQuery("UPDATE_CHEQUE_INVENTORY_WHEN_REJECT", true)); } if (statusType == "A") { status = Convert.ToBoolean(db.ExecuteNonQuery("[UPDATE_CHEQUE_INVENTORY_FOR_OUT_WHEN_APPROVE]", true)); } if (statusType == "AC") { status = Convert.ToBoolean(db.ExecuteNonQuery("[UPDATE_CHEQUE_INVENTORY_FOR_OUT_WHEN_APPROVE_BY_CASH]", true)); } } catch (Exception ex) { throw; } return status; }
protected void getChequeInventoryDetails() { chequeInventoryBLL chekQueInventoryBll = new chequeInventoryBLL(); DataTable dt = new DataTable(); try { if (ddlStatus.SelectedValue != "P") { gridChequeInventory.Columns[8].Visible = false; gridChequeInventory.Columns[10].Visible = false; } else { gridChequeInventory.Columns[8].Visible = true; } chekQueInventoryBll.folowType = ddlType.SelectedValue.ToString().Trim(); chekQueInventoryBll.status = ddlStatus.SelectedValue.ToString().Trim(); chekQueInventoryBll.branchId = salesCenterDropDownList.SelectedValue.ToString().Trim(); dt = chekQueInventoryBll.getChequeInventory(); gridChequeInventory.DataSource = dt; gridChequeInventory.DataBind(); if (gridChequeInventory.Rows.Count > 0) { gridChequeInventory.UseAccessibleHeader = true; gridChequeInventory.HeaderRow.TableSection = TableRowSection.TableHeader; } else { msgTitleLabel.Text = "Warning !!!"; msgDetailLabel.Text = "No data Found On the cheque Inventory"; msgbox.Visible = true; } } catch (Exception ex) { string message = ex.Message; if (ex.InnerException != null) { message += " --> " + ex.InnerException.Message; } MyAlertBox("ErrorAlert(\"" + ex.GetType() + "\", \"" + message + "\", \"\");"); } }
public DataTable getChequeInventoryList(LumexDBPlayer db, chequeInventoryBLL chequeInventoryBLL) { DataTable dt = new DataTable(); try { db.AddParameters("@IsInflow", chequeInventoryBLL.folowType.Trim()); db.AddParameters("@ChequeStatus", chequeInventoryBLL.status.Trim()); db.AddParameters("@BranchId", chequeInventoryBLL.branchId.Trim()); dt = db.ExecuteDataTable("GET_CHEQUE_INVENTORY_BY_FLOWSTATUS_Cheque_Status", true); return dt; } catch (Exception) { throw; } }
protected void ddlStatusInGrid_SelectedIndexChanged(object sender, EventArgs e) { try { bool status = false; DropDownList drpDownList = (DropDownList)sender; GridViewRow gridRow = (GridViewRow)drpDownList.NamingContainer; chequeInventoryBLL chqInventoryBll = new chequeInventoryBLL(); chqInventoryBll.chequeSerial = gridChequeInventory.Rows[gridRow.RowIndex].Cells[0].Text.ToString(); TextBox txtbxNaration= (TextBox)gridChequeInventory.Rows[gridRow.RowIndex].FindControl("txtchqNaration"); chqInventoryBll.naration = txtbxNaration.Text; TextBox txtbxFinalDate = (TextBox)gridChequeInventory.Rows[gridRow.RowIndex].FindControl("txtFinalDate"); string finalDate = txtbxFinalDate.Text.Trim(); if(!string.IsNullOrEmpty(finalDate)) { chqInventoryBll.Finaldate =LumexLibraryManager.ParseAppDate(txtbxFinalDate.Text); } DropDownList ddlStatusInGrid = (DropDownList)gridChequeInventory.Rows[gridRow.RowIndex].FindControl("ddlStatusInGrid"); string statusType = ddlStatusInGrid.SelectedValue.ToString(); if (!string.IsNullOrEmpty(txtbxFinalDate.Text)&&statusType!="0") { if (ddlType.SelectedValue == "Y") { status = chqInventoryBll.ChangeChequeStatus(statusType); getChequeInventoryDetails(); if (statusType == "R") { if (status) { string message = "Sales <span class='actionTopic'>Cheque</span> Successfully Rejected</span>."; MyAlertBox( "var callbackOk = function () { MyOverlayStart(); window.location = \"/UI/SalesReturn/SalesReturnList.aspx\"; }; SuccessAlert(\"" + "Process Succeed" + "\", \"" + message + "\", \"\");"); } else { string message = "Sales <span class='actionTopic'>Cheque</span> does not Rejected</span>."; MyAlertBox( "var callbackOk = function () { MyOverlayStart(); window.location = \"/UI/SalesReturn/SalesReturnList.aspx\"; }; WarningAlert(\"" + "Process Succeed" + "\", \"" + message + "\", \"\");"); } } if (ddlStatusInGrid.SelectedValue == "A") { // status = chekInventoryBll.ChangeChequeStatus(statusType); if (status) { string message = " <span class='actionTopic'>Cheque</span> Successfully Approved</span>."; MyAlertBox( "var callbackOk = function () { MyOverlayStart(); window.location = \"/UI/SalesReturn/SalesReturnList.aspx\"; }; SuccessAlert(\"" + "Process Succeed" + "\", \"" + message + "\", \"\");"); // getChequeInventoryDetails(); } else { string message = " <span class='actionTopic'>Cheque</span> Does Not Approved</span>."; MyAlertBox( "var callbackOk = function () { MyOverlayStart(); window.location = \"/UI/SalesReturn/SalesReturnList.aspx\"; }; WarningAlert(\"" + "Process Succeed" + "\", \"" + message + "\", \"\");"); // getChequeInventoryDetails(); } } if (ddlStatusInGrid.SelectedValue == "AC") { // status = chekInventoryBll.ChangeChequeStatus(statusType); if (status) { string message = "<span class='actionTopic'>Cheque</span> Successfully Approved by Cash</span>."; MyAlertBox( "var callbackOk = function () { MyOverlayStart(); window.location = \"/UI/SalesReturn/SalesReturnList.aspx\"; }; SuccessAlert(\"" + "Process Succeed" + "\", \"" + message + "\", \"\");"); // getChequeInventoryDetails(); } else { string message = "<span class='actionTopic'>Cheque</span> Does Not Approved by Cash</span>."; MyAlertBox( "var callbackOk = function () { MyOverlayStart(); window.location = \"/UI/SalesReturn/SalesReturnList.aspx\"; }; WarningAlert(\"" + "Process Succeed" + "\", \"" + message + "\", \"\");"); // getChequeInventoryDetails(); } } } else { status = chqInventoryBll.ChangeChequeStatusForOutFlow(statusType); getChequeInventoryDetails(); if (statusType == "R") { if (status) { string message = " <span class='actionTopic'>Cheque</span> Successfully Rejected</span>."; MyAlertBox( "var callbackOk = function () { MyOverlayStart(); window.location = \"/UI/SalesReturn/SalesReturnList.aspx\"; }; SuccessAlert(\"" + "Process Succeed" + "\", \"" + message + "\", \"\");"); } else { string message = " <span class='actionTopic'>Cheque</span> doesw not Rejected</span>."; MyAlertBox( "var callbackOk = function () { MyOverlayStart(); window.location = \"/UI/SalesReturn/SalesReturnList.aspx\"; }; WarningAlert(\"" + "Process Succeed" + "\", \"" + message + "\", \"\");"); } } if (ddlStatusInGrid.SelectedValue == "A") { // status = chekInventoryBll.ChangeChequeStatus(statusType); if (status) { string message = " <span class='actionTopic'>Cheque</span> Successfully Approved</span>."; MyAlertBox( "var callbackOk = function () { MyOverlayStart(); window.location = \"/UI/SalesReturn/SalesReturnList.aspx\"; }; SuccessAlert(\"" + "Process Succeed" + "\", \"" + message + "\", \"\");"); // getChequeInventoryDetails(); } else { string message = " <span class='actionTopic'>Cheque</span> Does Not Approved</span>."; MyAlertBox( "var callbackOk = function () { MyOverlayStart(); window.location = \"/UI/SalesReturn/SalesReturnList.aspx\"; }; WarningAlert(\"" + "Process Succeed" + "\", \"" + message + "\", \"\");"); // getChequeInventoryDetails(); } } if (ddlStatusInGrid.SelectedValue == "AC") { // status = chekInventoryBll.ChangeChequeStatus(statusType); if (status) { string message = " <span class='actionTopic'>Cheque</span> Successfully Approved by Cash</span>."; MyAlertBox( "var callbackOk = function () { MyOverlayStart(); window.location = \"/UI/SalesReturn/SalesReturnList.aspx\"; }; SuccessAlert(\"" + "Process Succeed" + "\", \"" + message + "\", \"\");"); // getChequeInventoryDetails(); } else { string message = " <span class='actionTopic'>Cheque</span> Does Not Approved by cash</span>."; MyAlertBox( "var callbackOk = function () { MyOverlayStart(); window.location = \"/UI/SalesReturn/SalesReturnList.aspx\"; }; WarningAlert(\"" + "Process Succeed" + "\", \"" + message + "\", \"\");"); // getChequeInventoryDetails(); } } } } else { string message = "Please <span class='actionTopic'>Select</span> The Final Date. or select correct Action</span>."; MyAlertBox("var callbackOk = function () { MyOverlayStart(); window.location = \"/UI/SalesReturn/SalesReturnList.aspx\"; }; WarningAlert(\"" +"Warning" + "\", \"" + message + "\", \"\");"); ddlStatusInGrid.ClearSelection(); } } catch (Exception ex) { string message = ex.Message; if (ex.InnerException != null) { message += " --> " + ex.InnerException.Message; } MyAlertBox("ErrorAlert(\"" + ex.GetType() + "\", \"" + message + "\", \"\");"); } }