public static bool SaveMaagIssueHead(ATTMaagIssueHead objMaagIssueHead)
{
try
{
if (DLLMaagIssueHead.SaveMaagIssueHead(objMaagIssueHead))
{
return(true);
}
else
{
return(false);
}
}
catch (Exception ex)
{
throw ex;
}
}
public static bool SaveMaagIssueHead(ATTMaagIssueHead objMaagIssueHead)
{
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", objMaagIssueHead.OrgID, OracleDbType.Int64, ParameterDirection.Input));
paramArray.Add(Utilities.GetOraParam(":P_UNIT_ID", objMaagIssueHead.UnitID, OracleDbType.Int64, ParameterDirection.Input));
paramArray.Add(Utilities.GetOraParam(":P_REQ_NO", objMaagIssueHead.ReqNo, OracleDbType.Double, ParameterDirection.Input));
paramArray.Add(Utilities.GetOraParam(":P_ISSUE_SEQ", objMaagIssueHead.IssueSeq, OracleDbType.Int64, ParameterDirection.InputOutput));
if (objMaagIssueHead.Action == "D")
{
strSQL = "SP_INV_DEL_MAAG_ISSUE_HEAD";
}
else
{
paramArray.Add(Utilities.GetOraParam(":P_ISSUE_DATE", objMaagIssueHead.IssueDate, OracleDbType.Varchar2, ParameterDirection.Input));
paramArray.Add(Utilities.GetOraParam(":P_ISSUE_BY", objMaagIssueHead.IssueBy, OracleDbType.Double, ParameterDirection.Input));
paramArray.Add(Utilities.GetOraParam(":P_RCVD_BY", objMaagIssueHead.RcvdBy, OracleDbType.Double, ParameterDirection.Input));
paramArray.Add(Utilities.GetOraParam(":P_REMARKS", objMaagIssueHead.Remarks, OracleDbType.Varchar2, ParameterDirection.Input));
paramArray.Add(Utilities.GetOraParam(":P_ENTRY_BY", objMaagIssueHead.EntryBy, OracleDbType.Varchar2, ParameterDirection.Input));
if (objMaagIssueHead.Action == "A")
{
strSQL = "SP_INV_ADD_MAAG_ISSUE_HEAD";
}
else if (objMaagIssueHead.Action == "E")
{
strSQL = "SP_INV_EDIT_MAAG_ISSUE_HEAD";
}
}
try
{
SqlHelper.ExecuteNonQuery(Tran, CommandType.StoredProcedure, strSQL, paramArray.ToArray());
objMaagIssueHead.IssueSeq = int.Parse(paramArray[3].Value.ToString());
paramArray.Clear();
if (objMaagIssueHead.LstMaagIssueDetail.Count > 0)
{
DLLMaagIssueDetail.SaveMaagIssueDetail(objMaagIssueHead.LstMaagIssueDetail, objMaagIssueHead.IssueSeq, 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();
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
ATTMaagIssueHead objMaagIssueHead = new ATTMaagIssueHead
(
int.Parse(this.grdIssueMaagDetails.Rows[0].Cells[1].Text),
int.Parse(this.grdIssueMaagDetails.Rows[0].Cells[2].Text),
double.Parse(this.grdIssueMaagDetails.Rows[0].Cells[3].Text),
0,
this.txtIssueDate_DT.Text.Trim() == "" ? null : this.txtIssueDate_DT.Text.Trim(),
((ATTUserLogin)Session["Login_User_Detail"]).PID,
double.Parse(hdnRcvdBy.Value.ToString())
);
objMaagIssueHead.EntryBy = ((ATTUserLogin)Session["Login_User_Detail"]).UserName;
objMaagIssueHead.Action = "A";
List <ATTMaagIssueDetail> lstMaagIssueDet = new List <ATTMaagIssueDetail>();
foreach (GridViewRow row in this.grdIssueMaagDetails.Rows)
{
int deliverQty = 0;
TextBox txt = (TextBox)(row.FindControl("txtDelQty"));
try
{
deliverQty = int.Parse(txt.Text);
}
catch (Exception)
{
}
if ((deliverQty + int.Parse(row.Cells[12].Text)) > int.Parse(row.Cells[11].Text))
{
this.lblStatusMessage.Text = "आदेश परिमाण भन्दा निकासा परिमाण धेरै हुन सक्दैन";
this.programmaticModalPopup.Show();
return;
}
if (deliverQty > 0)
{
ATTMaagIssueDetail objMaagIssueDet = new ATTMaagIssueDetail
(
int.Parse(row.Cells[1].Text),
int.Parse(row.Cells[2].Text),
double.Parse(row.Cells[3].Text),
0,
int.Parse(row.Cells[4].Text),
int.Parse(row.Cells[6].Text),
int.Parse(row.Cells[8].Text),
deliverQty
);
objMaagIssueDet.Action = "A";
lstMaagIssueDet.Add(objMaagIssueDet);
}
}
if (lstMaagIssueDet.Count == 0)
{
this.lblStatusMessage.Text = "No Changes Have Been Made.";
this.programmaticModalPopup.Show();
}
else
{
try
{
objMaagIssueHead.LstMaagIssueDetail = lstMaagIssueDet;
BLLMaagIssueHead.SaveMaagIssueHead(objMaagIssueHead);
this.lblStatusMessage.Text = "Items Successfully Issued.";
this.programmaticModalPopup.Show();
WebForm1_BubbleClickBtn(sender, e);
}
catch (Exception ex)
{
this.lblStatusMessage.Text = ex.Message;
this.programmaticModalPopup.Show();
}
}
}
