public static int RecomendApprovePurchaseOrder(ATTInvPurchaseOrder objPo)
{
try
{
return(DLLInvPurchaseOrder.RecomendApprovePurchaseOrder(objPo));
}
catch (Exception ex)
{
throw (ex);
}
}
public static List <ATTInvPurchaseOrder> SrchPurchaseOrder(ATTInvSrchPurchaseOrder objSrchPo, int type)
{
try
{
List <ATTInvPurchaseOrder> lst = new List <ATTInvPurchaseOrder>();
foreach (DataRow row in DLLInvSrchPurchaseOrder.SrchPurchaseOrder(objSrchPo, type).Rows)
{
ATTInvPurchaseOrder obj = new ATTInvPurchaseOrder();
int?recby = null;
int?appby = null;
if (row["REC_BY"].ToString() != "")
{
recby = int.Parse(row["REC_BY"].ToString());
}
if (row["APP_BY"].ToString() != "")
{
appby = int.Parse(row["APP_BY"].ToString());
}
obj.OrgID = int.Parse(row["ORG_ID"].ToString());
obj.SupplierID = int.Parse(row["SUPPLIERS_ID"].ToString());
obj.SupplierName = row["SUPPLIERS_NAME"].ToString();
obj.OrderDate = row["ORDER_DATE"].ToString();
obj.OrderNo = row["ORDER_NO"].ToString();
obj.RecBy = recby;
obj.RecDate = row["REC_DATE"].ToString();
obj.RecYesNo = row["REC_YES_NO"].ToString();
obj.AppBy = appby;
obj.AppDate = row["APP_DATE"].ToString();
obj.AppYesNo = row["APP_YES_NO"].ToString();
lst.Add(obj);
}
return(lst);
}
catch (Exception ex)
{
throw (ex);
}
}
public static int CheckPurOrderAvailability(ATTInvPurchaseOrder objPo, OracleTransaction Tran)
{
try
{
string chkPurOrderSQL = "SELECT CHECK_PUR_ORDER_AVAILABILITY(" + objPo.OrgID + ",'"
+ objPo.OrderNo + "')" +
"FROM DUAL";
DataSet ds = SqlHelper.ExecuteDataset(Tran, CommandType.Text, chkPurOrderSQL);
DataTable tbl = new DataTable();
tbl = (DataTable)ds.Tables[0];
int orderCount = int.Parse(tbl.Rows[0][0].ToString());
return(orderCount);
}
catch (Exception ex)
{
throw (ex);
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
try
{
if (Session["CurrentDate"] != null && txtODate_RDT.Text != "")
{
if (CompareDate(Session["CurrentDate"].ToString(), txtODate_RDT.Text))
{
bool flag = true;
ATTInvPurchaseOrder objPo = new ATTInvPurchaseOrder();
objPo.OrgID = orgID;
//objPo.UnitID = int.Parse(ddlUnit_rqd.SelectedValue);
objPo.OrderNo = txtOrderNo_rqd.Text;
objPo.OrderDate = txtODate_RDT.Text;
objPo.SupplierID = int.Parse(ddlSupplier_rqd.SelectedValue);
objPo.EntryBy = entryBy;
objPo.Action = "A";
if (Session["PoDetail"] != null)
{
if (((List <ATTInvPurchaseOrderDetail>)Session["PoDetail"]).Count > 0)
{
objPo.lstPurchaseOrderDetail = (List <ATTInvPurchaseOrderDetail>)Session["PoDetail"];
}
else
{
flag = false;
}
}
else
{
flag = false;
}
if (flag)
{
int saveConfirm = BLLInvPurchaseOrder.SavePurchaseOrder(objPo);
if (saveConfirm == 0)
{
ClearControls();
this.lblStatusMessageTitle.Text = "खरिद अर्डर ";
this.lblStatusMessage.Text = "सफलतापूर्वक सेभ भयो!!!";
this.programmaticModalPopup.Show();
}
else if (saveConfirm == -1)
{
this.lblStatusMessageTitle.Text = "खरिद अर्डर ";
this.lblStatusMessage.Text = "अर्डर नंम्बर पहिला नै प्रयोग भइसक्यो!!!";
this.programmaticModalPopup.Show();
}
else
{
this.lblStatusMessageTitle.Text = "खरिद अर्डर ";
this.lblStatusMessage.Text = "सेभ गर्दा वाधा उत्पन्न भयो!!!";
this.programmaticModalPopup.Show();
}
}
else
{
this.lblStatusMessageTitle.Text = "खरिद अर्डर ";
this.lblStatusMessage.Text = "कृपया खरिद गर्ने आइटम छान्नुहोस् ।!!!";
this.programmaticModalPopup.Show();
}
}
else
{
this.lblStatusMessageTitle.Text = "खरिद अर्डर ";
this.lblStatusMessage.Text = "अर्डर मिति नागीसक्यो !!! त्यसैले अर्को अर्डर मिति राख्नुहोस्";
this.programmaticModalPopup.Show();
}
}
else
{
this.lblStatusMessageTitle.Text = "खरिद अर्डर ";
this.lblStatusMessage.Text = "कृपया मिति राख्नुहोस् ।!!!";
this.programmaticModalPopup.Show();
}
}
catch (Exception ex)
{
this.lblStatusMessageTitle.Text = "Error Status";
this.lblStatusMessage.Text = ex.Message;
this.programmaticModalPopup.Show();
}
}
public static bool SavePurchaseOrderDetail(ATTInvPurchaseOrder objPo, OracleTransaction Tran)
{
try
{
string sp = "";
foreach (ATTInvPurchaseOrderDetail objPoDetail in objPo.lstPurchaseOrderDetail)
{
if (objPoDetail.Action == "A")
{
sp = "sp_inv_add_purchase_order_det";
}
else if (objPoDetail.Action == "E")
{
sp = "sp_inv_edit_purchase_order_det";
}
else if (objPoDetail.Action == "D")
{
sp = "sp_inv_del_purchase_order_det";
}
if (objPoDetail.Action != "N" && sp != "")
{
objPoDetail.OrgID = objPo.OrgID;
objPoDetail.UnitID = objPo.UnitID;
objPoDetail.OrderNo = objPo.OrderNo;
objPoDetail.EntryBy = objPo.EntryBy;
List <OracleParameter> paramArray = new List <OracleParameter>();
paramArray.Add(Utilities.GetOraParam(":p_org_id", objPoDetail.OrgID, OracleDbType.Int64, ParameterDirection.Input));
paramArray.Add(Utilities.GetOraParam(":p_order_no", objPoDetail.OrderNo, OracleDbType.Varchar2, ParameterDirection.Input));
paramArray.Add(Utilities.GetOraParam(":p_items_category_id", objPoDetail.ItemsCategoryID, OracleDbType.Int64, ParameterDirection.Input));
paramArray.Add(Utilities.GetOraParam(":p_items_sub_category_id", objPoDetail.ItemsSubCategoryID, OracleDbType.Int64, ParameterDirection.Input));
paramArray.Add(Utilities.GetOraParam(":p_items_id", objPoDetail.ItemsID, OracleDbType.Int64, ParameterDirection.Input));
paramArray.Add(Utilities.GetOraParam(":p_seq_no", objPoDetail.SeqNo, OracleDbType.Int64, ParameterDirection.InputOutput));
if (sp != "sp_inv_del_purchase_order_det")
{
paramArray.Add(Utilities.GetOraParam(":p_manu_company", objPoDetail.ManuCompany, OracleDbType.Varchar2, ParameterDirection.Input));
paramArray.Add(Utilities.GetOraParam(":p_manu_date", objPoDetail.ManuDate, OracleDbType.Varchar2, ParameterDirection.Input));
paramArray.Add(Utilities.GetOraParam(":p_brand", objPoDetail.Brand, OracleDbType.Varchar2, ParameterDirection.Input));
paramArray.Add(Utilities.GetOraParam(":p_total_quantity", objPoDetail.TotalQty, OracleDbType.Int64, ParameterDirection.Input));
paramArray.Add(Utilities.GetOraParam(":p_unit_price", objPoDetail.UnitPrice, OracleDbType.Double, ParameterDirection.Input));
// paramArray.Add(Utilities.GetOraParam(":p_specifications", objPoDetail.Specification, OracleDbType.Varchar2, ParameterDirection.Input));
paramArray.Add(Utilities.GetOraParam(":p_entry_by", objPoDetail.EntryBy, OracleDbType.Varchar2, ParameterDirection.Input));
}
SqlHelper.ExecuteNonQuery(Tran, CommandType.StoredProcedure, sp, paramArray.ToArray());
sp = "";
}
}
return(true);
}
catch (Exception ex)
{
throw (ex);
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
try
{
if (i == 0)//to prevent the event below from executing more than 1 time
{
bool flag = true;
ArrayList arrPoDetailInfo = new ArrayList();
if (type == 0)
{
if (Session["arrPoDetailInfo"] != null)
{
arrPoDetailInfo = (ArrayList)Session["arrPoDetailInfo"];
}
}
else if (type == 1)
{
if (Session["arrPoRecmDetailInfo"] != null)
{
arrPoDetailInfo = (ArrayList)Session["arrPoRecmDetailInfo"];
}
}
else if (type == 2)
{
if (Session["arrPoApprvDetailInfo"] != null)
{
arrPoDetailInfo = (ArrayList)Session["arrPoApprvDetailInfo"];
}
}
ATTInvPurchaseOrder objPo = new ATTInvPurchaseOrder();
objPo.OrgID = int.Parse(arrPoDetailInfo[0].ToString());
//objPo.UnitID = int.Parse(arrPoDetailInfo[1].ToString());
objPo.OrderNo = arrPoDetailInfo[4].ToString();
objPo.SupplierID = int.Parse(ddlSupplier.SelectedValue);
objPo.OrderDate = txtOrderDate.Text;
objPo.EntryBy = arrPoDetailInfo[6].ToString();
objPo.Type = int.Parse(arrPoDetailInfo[7].ToString());
if (arrPoDetailInfo[8].ToString() != "")
{
objPo.RecBy = int.Parse(arrPoDetailInfo[8].ToString());
}
else
{
objPo.RecBy = null;
}
objPo.RecDate = arrPoDetailInfo[9].ToString();
objPo.RecYesNo = arrPoDetailInfo[10].ToString();
if (chkRecomend_rqd.Checked == true && txtRecomendDate_RDT.Text != "")
{
if (objPo.Type == 1)
{
objPo.RecYesNo = "Y";
objPo.RecDate = txtRecomendDate_RDT.Text;
objPo.RecBy = int.Parse(arrPoDetailInfo[11].ToString());
}
else if (objPo.Type == 2)
{
objPo.AppYesNo = "Y";
objPo.AppDate = txtRecomendDate_RDT.Text;
objPo.AppBy = int.Parse(arrPoDetailInfo[11].ToString());
}
}
else
{
objPo.Type = 0;
objPo.Action = "E";
}
if (type == 0)
{
if (((List <ATTInvPurchaseOrderDetail>)Session["PoUpdDetail"]).Count > 0)
{
objPo.lstPurchaseOrderDetail = (List <ATTInvPurchaseOrderDetail>)Session["PoUpdDetail"];
}
}
else if (type == 1)
{
if (((List <ATTInvPurchaseOrderDetail>)Session["PoRecmUpdDetail"]).Count > 0)
{
objPo.lstPurchaseOrderDetail = (List <ATTInvPurchaseOrderDetail>)Session["PoRecmUpdDetail"];
}
}
else if (type == 2)
{
if (((List <ATTInvPurchaseOrderDetail>)Session["PoApprvUpdDetail"]).Count > 0)
{
objPo.lstPurchaseOrderDetail = (List <ATTInvPurchaseOrderDetail>)Session["PoApprvUpdDetail"];
}
}
else
{
flag = false;
}
if (flag)
{
int?updateConfirm = null;
if (objPo.Type == 0)
{
updateConfirm = BLLInvPurchaseOrder.SavePurchaseOrder(objPo);
}
else if (objPo.Type == 1 || objPo.Type == 2)
{
updateConfirm = BLLInvPurchaseOrder.RecomendApprovePurchaseOrder(objPo);
}
if (updateConfirm == 0)
{
ClearItemsDetailControls();
this.lblStatusMessageTitle.Text = "खरिद अर्डर ";
this.lblStatusMessage.Text = "सफलतापूर्वक परिर्वतन भयो!!!";
this.programmaticModalPopup.Show();
}
else if (updateConfirm == 1)
{
ClearItemsDetailControls();
this.lblStatusMessageTitle.Text = "खरिद अर्डर ";
this.lblStatusMessage.Text = "सफलतापूर्वक सिफारिस भयो।";
this.programmaticModalPopup.Show();
}
else if (updateConfirm == 2)
{
ClearItemsDetailControls();
this.lblStatusMessageTitle.Text = "खरिद अर्डर ";
this.lblStatusMessage.Text = "सफलतापूर्वक प्रमाणित भयो।";
this.programmaticModalPopup.Show();
}
else
{
this.lblStatusMessageTitle.Text = "खरिद अर्डर ";
this.lblStatusMessage.Text = "वाधा उत्पन्न भयो!!!";
this.programmaticModalPopup.Show();
}
}
i++;
OnBubbleClick(e);
}
}
catch (Exception ex)
{
throw (ex);
}
}
public static int RecomendApprovePurchaseOrder(ATTInvPurchaseOrder objPo)
{
GetConnection GetConn = new GetConnection();
OracleConnection DBConn = GetConn.GetDbConn(Module.OAS);
OracleTransaction Tran = DBConn.BeginTransaction();
try
{
string sp = "";
int countPoDetail = objPo.lstPurchaseOrderDetail.Count;
if (objPo.Type == 1)
{
sp = "SP_INV_REC_PURCHASE_ORDER";
}
else if (objPo.Type == 2)
{
sp = "SP_INV_APP_PURCHASE_ORDER";
}
if (objPo.Type != null && sp != "")
{
List <OracleParameter> paramArray = new List <OracleParameter>();
paramArray.Add(Utilities.GetOraParam(":p_org_id", objPo.OrgID, OracleDbType.Int64, ParameterDirection.Input));
// paramArray.Add(Utilities.GetOraParam(":p_unit_id", objPo.UnitID, OracleDbType.Int64, ParameterDirection.Input));
paramArray.Add(Utilities.GetOraParam(":p_order_no", objPo.OrderNo, OracleDbType.Varchar2, ParameterDirection.Input));
if (objPo.Type == 1)
{
paramArray.Add(Utilities.GetOraParam(":p_rec_by", objPo.RecBy, OracleDbType.Int64, ParameterDirection.Input));
paramArray.Add(Utilities.GetOraParam(":p_rec_date", objPo.RecDate, OracleDbType.Varchar2, ParameterDirection.Input));
paramArray.Add(Utilities.GetOraParam(":p_rec_yes_no", objPo.RecYesNo, OracleDbType.Varchar2, ParameterDirection.Input));
}
else if (objPo.Type == 2)
{
paramArray.Add(Utilities.GetOraParam(":p_app_by", objPo.AppBy, OracleDbType.Int64, ParameterDirection.Input));
paramArray.Add(Utilities.GetOraParam(":p_app_date", objPo.AppDate, OracleDbType.Varchar2, ParameterDirection.Input));
paramArray.Add(Utilities.GetOraParam(":p_app_yes_no", objPo.AppYesNo, OracleDbType.Varchar2, ParameterDirection.Input));
}
SqlHelper.ExecuteNonQuery(Tran, CommandType.StoredProcedure, sp, paramArray.ToArray());
paramArray.Clear();
}
if (countPoDetail > 0)
{
DLLInvPurchaseOrderDetail.SavePurchaseOrderDetail(objPo, Tran);
}
Tran.Commit();
if (objPo.Type == 1)
{
return(1);
}
else if (objPo.Type == 2)
{
return(2);
}
else
{
return(3);
}
}
catch (Exception ex)
{
throw(ex);
}
}
public static int SavePurchaseOrder(ATTInvPurchaseOrder objPo)
{
GetConnection GetConn = new GetConnection();
OracleConnection DBConn = GetConn.GetDbConn(Module.OAS);
OracleTransaction Tran = DBConn.BeginTransaction();
try
{
if (objPo.Action == "A")
{
int orderCount = CheckPurOrderAvailability(objPo, Tran);
if (orderCount > 0)
{
Tran.Commit();
return(-1);
}
}
string sp = "";
int countPoDetail = objPo.lstPurchaseOrderDetail.Count;
if (objPo.Action == "A")
{
sp = "sp_inv_add_purchase_order";
}
else if (objPo.Action == "E")
{
sp = "sp_inv_edit_purchase_order";
}
if (objPo.Action != "N" && sp != "")
{
OracleParameter[] paramArray = new OracleParameter[11];
paramArray[0] = Utilities.GetOraParam(":p_org_id", objPo.OrgID, OracleDbType.Int64, ParameterDirection.Input);
paramArray[1] = Utilities.GetOraParam(":p_order_no", objPo.OrderNo, OracleDbType.Varchar2, ParameterDirection.Input);
paramArray[2] = Utilities.GetOraParam(":p_order_date", objPo.OrderDate, OracleDbType.Varchar2, ParameterDirection.Input);
paramArray[3] = Utilities.GetOraParam(":p_suppliers_id", objPo.SupplierID, OracleDbType.Int64, ParameterDirection.Input);
paramArray[4] = Utilities.GetOraParam(":p_rec_by", objPo.RecBy, OracleDbType.Int64, ParameterDirection.Input);
paramArray[5] = Utilities.GetOraParam(":p_rec_date", objPo.RecDate, OracleDbType.Varchar2, ParameterDirection.Input);
paramArray[6] = Utilities.GetOraParam(":p_rec_yes_no", objPo.RecYesNo, OracleDbType.Varchar2, ParameterDirection.Input);
paramArray[7] = Utilities.GetOraParam(":p_app_by", objPo.AppBy, OracleDbType.Int64, ParameterDirection.Input);
paramArray[8] = Utilities.GetOraParam(":p_app_date", objPo.AppDate, OracleDbType.Varchar2, ParameterDirection.Input);
paramArray[9] = Utilities.GetOraParam(":p_app_yes_no", objPo.AppYesNo, OracleDbType.Varchar2, ParameterDirection.Input);
paramArray[10] = Utilities.GetOraParam(":p_entry_by", objPo.EntryBy, OracleDbType.Varchar2, ParameterDirection.Input);
SqlHelper.ExecuteNonQuery(Tran, CommandType.StoredProcedure, sp, paramArray);
}
if (countPoDetail > 0)
{
DLLInvPurchaseOrderDetail.SavePurchaseOrderDetail(objPo, Tran);
}
Tran.Commit();
return(0);
}
catch (Exception ex)
{
Tran.Rollback();
throw (ex);
}
finally
{
GetConn.CloseDbConn();
}
}
