public static List <ATTAuctionMaster> GetAuctionDateDetails(int orgid, string AuctionDate, string AppYesNo)
{
List <ATTAuctionMaster> lstitems = new List <ATTAuctionMaster>();
try
{
foreach (DataRow row in DLLAuctionApprove.GetAuctionDateDetails(orgid, AuctionDate, AppYesNo).Rows)
{
ATTAuctionMaster objitems = new ATTAuctionMaster();
objitems.OrgID = int.Parse(row["ORG_ID"].ToString());
objitems.AuctionSeq = int.Parse(row["AUCTION_SEQ"].ToString());
objitems.AuctionDate = row["AUCTION_DATE"].ToString();
//objitems.App_By = int.Parse(row["APP_BY"].ToString());
objitems.App_Date = row["APP_DATE"].ToString();
objitems.App_Yes_No = row["APP_YES_NO"].ToString();
lstitems.Add(objitems);
}
return(lstitems);
}
catch (Exception ex)
{
throw ex;
}
}
public static bool SaveAuctionMaster(ATTAuctionMaster objItemsMaster)
{
try
{
return(DLLAuctionMaster.SaveAuctionMaster(objItemsMaster));
}
catch (Exception ex)
{
throw ex;
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
if (this.grdAuctionDateDetails.SelectedIndex > -1)
{
List <ATTAuctionMaster> LSTAucDateDetails = (List <ATTAuctionMaster>)Session["AuctionDateDetails"];
ATTAuctionMaster objData = new ATTAuctionMaster();
objData.OrgID = ((ATTUserLogin)Session["Login_User_Detail"]).OrgID;
objData.AuctionSeq = LSTAucDateDetails[this.grdAuctionDateDetails.SelectedIndex].AuctionSeq;
objData.AuctionDate = LSTAucDateDetails[this.grdAuctionDateDetails.SelectedIndex].AuctionDate;
objData.App_By = ((ATTUserLogin)Session["Login_User_Detail"]).PID;
objData.App_Date = this.txtCurrentDate.Text;
if (this.chkApprove.Checked == true)
{
objData.App_Yes_No = "Y";
}
else
{
objData.App_Yes_No = "N";
}
objData.EntryBy = ((ATTUserLogin)Session["Login_User_Detail"]).UserName;
if (this.grdAuctionDetails.SelectedIndex > -1)
{
objData.Action = "E";
objData.LstAuctionDetails = (List <ATTAuctionDetails>)Session["AuctionDetails"];
}
else
{
objData.Action = "App";
}
if (BLLAuctionMaster.SaveAuctionMaster(objData))
{
if (objData.Action == "E")
{
this.lblStatusMessage.Text = "Auction Details Edited Successfully";
this.programmaticModalPopup.Show();
}
else if (objData.Action == "App")
{
this.lblStatusMessage.Text = "Auction Details Approved Successfully";
this.programmaticModalPopup.Show();
}
}
ClearControls("submit");
}
else
{
this.lblStatusMessage.Text = "**र्कपया निलामी मिति छान्नुहोस्";
this.programmaticModalPopup.Show();
return;
}
}
public static bool SaveAuctionMaster(ATTAuctionMaster objItemsMaster)
{
GetConnection getConn = new GetConnection();
OracleConnection DBConn = getConn.GetDbConn(Module.OAS);
OracleTransaction Tran = DBConn.BeginTransaction();
string SP = "";
if (objItemsMaster.Action == "A")
{
SP = "SP_INV_ADD_ITEMS_AUCTION";
}
if (objItemsMaster.Action == "E")
{
SP = "SP_INV_EDIT_ITEMS_AUCTION";
}
if (objItemsMaster.Action == "App")
{
SP = "SP_INV_APP_ITEMS_AUCTION";
}
try
{
List <OracleParameter> paramArray = new List <OracleParameter>();
paramArray.Add(Utilities.GetOraParam(":P_ORG_ID", objItemsMaster.OrgID, OracleDbType.Int32, ParameterDirection.Input));
paramArray.Add(Utilities.GetOraParam(":P_AUCTION_SEQ", objItemsMaster.AuctionSeq, OracleDbType.Int32, ParameterDirection.InputOutput));
paramArray.Add(Utilities.GetOraParam(":P_AUCTION_DATE", objItemsMaster.AuctionDate, OracleDbType.Varchar2, ParameterDirection.Input));
paramArray.Add(Utilities.GetOraParam(":P_APP_BY", objItemsMaster.App_By, OracleDbType.Double, ParameterDirection.Input));
paramArray.Add(Utilities.GetOraParam(":P_APP_DATE", objItemsMaster.App_Date, OracleDbType.Varchar2, ParameterDirection.Input));
paramArray.Add(Utilities.GetOraParam(":P_APP_YES_NO", objItemsMaster.App_Yes_No, OracleDbType.Varchar2, ParameterDirection.Input));
paramArray.Add(Utilities.GetOraParam(":P_ENTRY_BY", objItemsMaster.EntryBy, OracleDbType.Varchar2, ParameterDirection.Input));
SqlHelper.ExecuteNonQuery(Tran, CommandType.StoredProcedure, SP, paramArray.ToArray());
objItemsMaster.AuctionSeq = int.Parse(paramArray[1].Value.ToString());
DLLAuctionDetails.SaveAuctionDetails(Tran, objItemsMaster.AuctionSeq, objItemsMaster.LstAuctionDetails);
paramArray.Clear();
Tran.Commit();
return(true);
}
catch (Exception ex)
{
Tran.Rollback();
throw ex;
}
finally
{
getConn.CloseDbConn();
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
try
{
ATTAuctionMaster objData = new ATTAuctionMaster();
objData.OrgID = ((ATTUserLogin)Session["Login_User_Detail"]).OrgID;
objData.AuctionSeq = 0;
objData.AuctionDate = this.txtAuctionDate.Text;
objData.App_By = 0;
objData.App_Date = "";
objData.App_Yes_No = "";
objData.Action = "A";
objData.EntryBy = ((ATTUserLogin)Session["Login_User_Detail"]).UserName;
objData.LstAuctionDetails = (List <ATTAuctionDetails>)Session["AuctionList"];
if (BLLAuctionMaster.SaveAuctionMaster(objData))
{
this.lblStatusMessage.Text = "Auction Details Saved Successfully";
this.programmaticModalPopup.Show();
}
//List<ATTAuctionDetails> LSTAuctionDetails = (List<ATTAuctionDetails>)Session["AuctionDetails"];
//if (LSTAuctionDetails.Count <= 0)
//{
// this.lblStatusMessage.Text = "Sorry No Data To Save";
// this.programmaticModalPopup.Show();
// return;
//}
//for (int j = 0; j <= this.grdAuctionList.Rows.Count - 1; j++)
//{
// LSTAuctionDetails[j].Remarks = ((TextBox)grdAuctionList.Rows[j].FindControl("txtDescription")).Text;
//}
this.ClearControls("submit");
}
catch (Exception ex)
{
this.lblStatusMessage.Text = ex.Message;
this.programmaticModalPopup.Show();
}
}