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();
}
}
