public static List <ATTMaagFaaramHead> GetMaagFaaramHead(ATTMaagFaaramHead objMaagFaaramHead) { List <ATTMaagFaaramHead> lstMaagFaaramHead = new List <ATTMaagFaaramHead>(); foreach (DataRow row in DLLMaagFaaramHead.GetMaagFaaramHead(objMaagFaaramHead).Rows) { ATTMaagFaaramHead obj = new ATTMaagFaaramHead ( ((row["ORG_ID"] == System.DBNull.Value) ? (int?)null : int.Parse(row["ORG_ID"].ToString())), ((row["UNIT_ID"] == System.DBNull.Value) ? (int?)null : int.Parse(row["UNIT_ID"].ToString())), ((row["REQ_NO"] == System.DBNull.Value) ? (double?)null : double.Parse(row["REQ_NO"].ToString())), ((row["REQ_DATE"] == System.DBNull.Value) ? "" : (row["REQ_DATE"].ToString())), ((row["REQ_BY"] == System.DBNull.Value) ? (double?)null : double.Parse(row["REQ_BY"].ToString())), ((row["ISSUE_TYPE"] == System.DBNull.Value) ? "" : (row["ISSUE_TYPE"].ToString())) ); obj.OrgName = ((row["ORG_NAME"] == System.DBNull.Value) ? "" : (row["ORG_NAME"].ToString())); obj.UnitName = ((row["UNIT_NAME"] == System.DBNull.Value) ? "" : (row["UNIT_NAME"].ToString())); obj.ReqPerson = ((row["REQUEST_PERSON"] == System.DBNull.Value) ? "" : (row["REQUEST_PERSON"].ToString())); obj.ReqPurpose = ((row["REQ_PURPOSE"] == System.DBNull.Value) ? "" : (row["REQ_PURPOSE"].ToString())); obj.AppBy = ((row["APP_BY"] == System.DBNull.Value) ? (double?)null : double.Parse(row["APP_BY"].ToString())); obj.AppPerson = ((row["APPROVED_PERSON"] == System.DBNull.Value) ? "" : (row["APPROVED_PERSON"].ToString())); obj.AppDate = ((row["APP_DATE"] == System.DBNull.Value) ? "" : (row["APP_DATE"].ToString())); obj.AppYesNo = ((row["APP_YES_NO"] == System.DBNull.Value) ? "" : (row["APP_YES_NO"].ToString())); obj.IssueFlag = ((row["ISSUE_FLAG"] == System.DBNull.Value) ? "" : (row["ISSUE_FLAG"].ToString())); lstMaagFaaramHead.Add(obj); } return(lstMaagFaaramHead); }
public static DataTable GetMaagFaaramHead(ATTMaagFaaramHead objMaagFaaramHead) { string strSql = "SELECT * FROM VW_MAAG_FAARAM_HEAD WHERE 1=1"; List <OracleParameter> paramArray = new List <OracleParameter>(); if (objMaagFaaramHead.OrgID != null) { strSql += " AND ORG_ID = :P_ORG_ID"; paramArray.Add(Utilities.GetOraParam(":P_ORG_ID", objMaagFaaramHead.OrgID, OracleDbType.Int64, ParameterDirection.Input)); } if (objMaagFaaramHead.UnitID != null) { strSql += " AND UNIT_ID = :P_UNIT_ID"; paramArray.Add(Utilities.GetOraParam(":P_UNIT_ID", objMaagFaaramHead.UnitID, OracleDbType.Int64, ParameterDirection.Input)); } if (objMaagFaaramHead.SelectApproval == true) { if (objMaagFaaramHead.AppYesNo == null) { strSql += " AND APP_YES_NO IS NULL"; } else { strSql += " AND APP_YES_NO = :P_APP_YES_NO"; paramArray.Add(Utilities.GetOraParam(":P_APP_YES_NO", objMaagFaaramHead.AppYesNo, OracleDbType.Varchar2, ParameterDirection.Input)); } } if (objMaagFaaramHead.SelectIssue == true) { if (objMaagFaaramHead.IssueFlag == null) { strSql += " AND ISSUE_FLAG IS NULL"; } else { strSql += " AND ISSUE_FLAG = :P_ISSUE_FLAG"; paramArray.Add(Utilities.GetOraParam(":P_ISSUE_FLAG", objMaagFaaramHead.IssueFlag, OracleDbType.Varchar2, ParameterDirection.Input)); } } strSql += " ORDER BY ORG_ID,UNIT_ID,REQ_NO"; try { DataSet ds = SqlHelper.ExecuteDataset(CommandType.Text, strSql, Module.OAS, paramArray.ToArray()); return((DataTable)ds.Tables[0]); } catch (OracleException oex) { PCS.COREDL.OracleError oe = new PCS.COREDL.OracleError(); throw new ArgumentException(oe.GetOraError(oex.Number, oex.Message)); } catch (Exception ex) { throw ex; } }
public static bool ApproveIssueMaag(ATTMaagFaaramHead objMaagFaaramHead) { GetConnection GetConn = new GetConnection(); OracleConnection DBConn = GetConn.GetDbConn(Module.OAS); OracleTransaction Tran = DBConn.BeginTransaction(); string strSQL = ""; List <OracleParameter> paramArray = new List <OracleParameter>(); paramArray.Add(Utilities.GetOraParam(":P_ORG_ID", objMaagFaaramHead.OrgID, OracleDbType.Int64, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam(":P_UNIT_ID", objMaagFaaramHead.UnitID, OracleDbType.Int64, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam(":P_REQ_NO", objMaagFaaramHead.ReqNo, OracleDbType.Double, ParameterDirection.InputOutput)); paramArray.Add(Utilities.GetOraParam(":P_APP_BY", objMaagFaaramHead.AppBy, OracleDbType.Double, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam(":P_APP_DATE", objMaagFaaramHead.AppDate, OracleDbType.Varchar2, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam(":P_APP_YES_NO", objMaagFaaramHead.AppYesNo, OracleDbType.Varchar2, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam(":P_ISSUE_FLAG", objMaagFaaramHead.IssueFlag, OracleDbType.Varchar2, ParameterDirection.Input)); if (objMaagFaaramHead.Action == "APP") { strSQL = "SP_INV_APP_MAAG_FAARAM_HEAD"; } else if (objMaagFaaramHead.Action == "DELI") { strSQL = "SP_INV_DELI_MAAG_FAARAM_HEAD"; } try { SqlHelper.ExecuteNonQuery(Tran, CommandType.StoredProcedure, strSQL, paramArray.ToArray()); paramArray.Clear(); if (objMaagFaaramHead.LstMaagFaaramDetail.Count > 0) { DLLMaagFaaramDetail.UpdateMaagFaaramDetAppQty(objMaagFaaramHead.LstMaagFaaramDetail, Tran); } Tran.Commit(); return(true); } catch (OracleException oex) { Tran.Rollback(); PCS.COREDL.OracleError oe = new PCS.COREDL.OracleError(); throw new ArgumentException(oe.GetOraError(oex.Number, oex.Message)); } catch (Exception ex) { Tran.Rollback(); throw (ex); } finally { GetConn.CloseDbConn(); } }
ATTMaagFaaramHead GetFilter() { ATTMaagFaaramHead objMaagHead = new ATTMaagFaaramHead(); objMaagHead.OrgID = ((ATTUserLogin)Session["Login_User_Detail"]).OrgID; objMaagHead.UnitID = int.Parse(this.ddlOrgUnits.SelectedValue); objMaagHead.ReqDate = this.txtReqDate.Text.Trim(); objMaagHead.AppYesNo = AppYesNo; objMaagHead.IssueFlag = IssueFlag; objMaagHead.SelectApproval = SelectApproval; objMaagHead.SelectIssue = SelectIssue; return(objMaagHead); }
public static bool ApproveIssueMaag(ATTMaagFaaramHead objMaagFaaramHead) { try { if (DLLMaagFaaramHead.ApproveIssueMaag(objMaagFaaramHead)) { return(true); } else { return(false); } } catch (Exception ex) { throw ex; } }
public static bool SaveMaagFaaramHead(ATTMaagFaaramHead objMaagFaaramHead) { try { if (DLLMaagFaaramHead.SaveMaagFaaramHead(objMaagFaaramHead)) { return(true); } else { return(false); } } catch (Exception ex) { throw ex; } }
protected void btnSubmit_Click(object sender, EventArgs e) { if (this.ddlOrgUnits_Rqd.SelectedIndex == 0 || this.txtMaagDate_RDT.Text == "____/__/__") { return; } double reqNo = 0; try { if (this.txtReqNo.Text != "") { reqNo = double.Parse(this.txtReqNo.Text.Trim()); } List <ATTMaagFaaramDetail> lstMaagDet = ((List <ATTMaagFaaramDetail>) Session["MaagDetail"]).FindAll( delegate(ATTMaagFaaramDetail obj) { return(obj.Action != null); } ); ATTMaagFaaramHead objMaagHead = new ATTMaagFaaramHead(9, int.Parse(this.ddlOrgUnits_Rqd.SelectedValue), reqNo, this.txtMaagDate_RDT.Text, ((ATTUserLogin)Session["Login_User_Detail"]).PID, this.rdblstIssueType.SelectedValue); objMaagHead.ReqPurpose = this.txtPurpose.Text.Trim(); objMaagHead.EntryBy = ((ATTUserLogin)Session["Login_User_Detail"]).UserName; objMaagHead.Action = "E"; objMaagHead.LstMaagFaaramDetail = lstMaagDet; BLLMaagFaaramHead.SaveMaagFaaramHead(objMaagHead); this.lblStatusMessage.Text = "Successfully Saved."; this.programmaticModalPopup.Show(); WebForm1_BubbleClickBtn(this, e); ((GridView)appMaagHeadControl.FindControl("grdMaagHead")).SelectedIndex = -1; } catch (Exception ex) { this.lblStatusMessage.Text = ex.Message; this.programmaticModalPopup.Show(); } }
protected void btnSubmit_Click(object sender, EventArgs e) { if (this.grdApproveMaagDetails.Rows.Count < 0) { return; } try { ATTMaagFaaramHead objMaagHead = new ATTMaagFaaramHead ( int.Parse(this.grdApproveMaagDetails.Rows[0].Cells[1].Text), int.Parse(this.grdApproveMaagDetails.Rows[0].Cells[2].Text), double.Parse(this.grdApproveMaagDetails.Rows[0].Cells[3].Text), ((ATTUserLogin)Session["Login_User_Detail"]).PID, (this.txtAppDate_DT.Text == "")?null: this.txtAppDate_DT.Text.Trim(), this.rdblstAppYesNo.SelectedValue, "" ); objMaagHead.Action = "APP"; List <ATTMaagFaaramDetail> lstMaagDet = new List <ATTMaagFaaramDetail>(); foreach (GridViewRow row in this.grdApproveMaagDetails.Rows) { ATTMaagFaaramDetail objMaagDet = new ATTMaagFaaramDetail ( int.Parse(row.Cells[1].Text), int.Parse(row.Cells[2].Text), double.Parse(row.Cells[3].Text), int.Parse(row.Cells[4].Text), int.Parse(row.Cells[6].Text), int.Parse(row.Cells[8].Text) ); TextBox txt = (TextBox)row.FindControl("txtAppQty"); try { objMaagDet.AppQty = int.Parse(txt.Text.Trim()); } catch (Exception) { objMaagDet.AppQty = int.Parse(row.Cells[10].Text); } if (objMaagDet.AppQty > int.Parse(row.Cells[10].Text)) { this.lblStatusMessage.Text = "माग परिमाण भन्दा आदेश परिमाण धेरै हुन सक्दैन"; this.programmaticModalPopup.Show(); return; } lstMaagDet.Add(objMaagDet); } objMaagHead.LstMaagFaaramDetail = lstMaagDet; BLLMaagFaaramHead.ApproveIssueMaag(objMaagHead); this.lblStatusMessage.Text = "Successfully Approved"; this.programmaticModalPopup.Show(); //appMaagHeadControl.BubbleClickBtn += new EventHandler(WebForm1_BubbleClickBtn); WebForm1_BubbleClickBtn(this, e); ((GridView)appMaagHeadControl.FindControl("grdMaagHead")).SelectedIndex = -1; } catch (Exception ex) { this.lblStatusMessage.Text = ex.Message; this.programmaticModalPopup.Show(); } }