private void FillForm(POFormUI pOFormUI)
{
try
{
DataTable dtb = pOFormBAL.GetPOListById(pOFormUI);
if (dtb.Rows.Count > 0)
{
ddlOpt_opt_Type.SelectedValue = dtb.Rows[0]["Type"].ToString();
txtPONumber.Text = dtb.Rows[0]["PONumber"].ToString();
txtSupplier.Text = dtb.Rows[0]["Supplier"].ToString();
txtSupplierGuid.Text = dtb.Rows[0]["tbl_SupplierId"].ToString();
txtUserId_BuyerGuid.Text = dtb.Rows[0]["tbl_UserId_Buyer"].ToString();
txtUserId_Buyer.Text = dtb.Rows[0]["BuyerName"].ToString();
txtDate.Text = dtb.Rows[0]["Date"].ToString();
txtCurrency.Text = dtb.Rows[0]["CurrencyName"].ToString();
txtCurrencyGuid.Text = dtb.Rows[0]["tbl_CurrencyId"].ToString();
chkAllowSales.Checked = Convert.ToBoolean(dtb.Rows[0]["AllowSales"].ToString());
txtRequisitionDate.Text = dtb.Rows[0]["RequisitionDate"].ToString();
txtPurchaseOrderDate.Text = dtb.Rows[0]["PurchaseOrderDate"].ToString();
txtLastEditDate.Text = dtb.Rows[0]["LastEditDate"].ToString();
txtLastPrintedDate.Text = dtb.Rows[0]["LastPrintedDate"].ToString();
txtContractExpirationDate.Text = dtb.Rows[0]["ContractExpirationDate"].ToString();
txtDatePlacedOnHold.Text = dtb.Rows[0]["DatePlacedOnHold"].ToString();
txtDateHoldRemoved.Text = dtb.Rows[0]["DateHoldRemoved"].ToString();
txtPlacedOnHoldByGuid.Text = dtb.Rows[0]["tbl_UserId_PlacedOnHoldBy"].ToString();
txtPlacedOnHoldBy.Text = dtb.Rows[0]["PlacedOnHoldByName"].ToString();
txtHoldRemovedByGuid.Text = dtb.Rows[0]["tbl_UserId_HoldRemovedBy"].ToString();
txtHoldRemovedBy.Text = dtb.Rows[0]["HoldRemovedByName"].ToString();
txtRemainingSubTotal.Text = dtb.Rows[0]["RemainingSubTotal"].ToString();
txtSubTotal.Text = dtb.Rows[0]["SubTotal"].ToString();
txtTradeDiscount.Text = dtb.Rows[0]["TradeDiscount"].ToString();
txtFreight.Text = dtb.Rows[0]["Freight"].ToString();
txtMiscellaneous.Text = dtb.Rows[0]["Miscellaneous"].ToString();
txtTotal.Text = dtb.Rows[0]["Total"].ToString();
txtComments.Text = dtb.Rows[0]["Comments"].ToString();
txtCommentsGuid.Text = dtb.Rows[0]["tbl_CommentsId"].ToString();
txtVersion.Text = dtb.Rows[0]["Version"].ToString();
ddlopt_Status.SelectedValue = dtb.Rows[0]["Status"].ToString();
}
else
{
lblError.Text = Resources.GlobalResource.msgCouldNotLoadData;
divError.Visible = true;
}
}
catch (Exception exp)
{
logExcpUIobj.MethodName = "FillForm()";
logExcpUIobj.ResourceName = "Finance_Accounts_Payable_PO_POForm.CS";
logExcpUIobj.RecordId = pOFormUI.Tbl_POId;
logExcpUIobj.ExceptionDetails = "Error Occured. System Generated Error is: " + exp.ToString();
logExcpDALobj.SaveExceptionToDB(logExcpUIobj);
log.Error("[Finance_Accounts_Payable_PO_POForm : FillForm] An error occured in the processing of Record Id : " + pOFormUI.Tbl_POId + ". Details : [" + exp.ToString() + "]");
}
}
protected void Page_Load(object sender, EventArgs e)
{
POFormUI pOFormUI = new POFormUI();
if (!Page.IsPostBack)
{
if (Request.QueryString["POId"] != null)
{
pOFormUI.Tbl_POId = Request.QueryString["POId"];
BindStatusDropDown();
BindTypeDropDown();
FillForm(pOFormUI);
btnSave.Visible = false;
btnClear.Visible = false;
btnUpdate.Visible = true;
btnDelete.Visible = true;
lblHeading.Text = "Update PO";
}
else
{
BindStatusDropDown();
BindTypeDropDown();
btnSave.Visible = true;
btnClear.Visible = true;
btnUpdate.Visible = false;
btnDelete.Visible = false;
lblHeading.Text = "Add New PO";
}
}
}
public int DeletePO(POFormUI pOFormUI)
{
int resutl = 0;
resutl = pOFormDAL.DeletePO(pOFormUI);
return(resutl);
}
public int UpdatePO(POFormUI pOFormUI)
{
int resutl = 0;
resutl = pOFormDAL.UpdatePO(pOFormUI);
return(resutl);
}
public int AddPO(POFormUI pOFormUI)
{
int resutl = 0;
resutl = pOFormDAL.AddPO(pOFormUI);
return(resutl);
}
public DataTable GetPOListById(POFormUI pOFormUI)
{
DataTable dtb = new DataTable();
dtb = pOFormDAL.GetPOListById(pOFormUI);
return(dtb);
}
public DataTable GetPOListById(POFormUI pOFormUI)
{
DataSet ds = new DataSet();
DataTable dtbl = new DataTable();
try
{
using (SqlConnection SupportCon = new SqlConnection(connectionString))
{
SqlCommand sqlCmd = new SqlCommand("SP_PO_SelectById", SupportCon);
sqlCmd.CommandType = CommandType.StoredProcedure;
sqlCmd.CommandTimeout = commandTimeout;
sqlCmd.Parameters.Add("@tbl_POId", SqlDbType.NVarChar);
sqlCmd.Parameters["@tbl_POId"].Value = pOFormUI.Tbl_POId;
using (SqlDataAdapter adapter = new SqlDataAdapter(sqlCmd))
{
adapter.Fill(ds);
}
}
if (ds.Tables.Count > 0)
{
dtbl = ds.Tables[0];
}
}
catch (Exception exp)
{
logExcpUIobj.MethodName = "GetPOListById()";
logExcpUIobj.ResourceName = "POFormDAL.CS";
logExcpUIobj.RecordId = pOFormUI.Tbl_POId;
logExcpUIobj.ExceptionDetails = "Error Occured. System Generated Error is: " + exp.ToString();
logExcpDALobj.SaveExceptionToDB(logExcpUIobj);
log.Error("[POFormDAL : GetPOListById] An error occured in the processing of Record Id : " + pOFormUI.Tbl_POId + ". Details : [" + exp.ToString() + "]");
}
finally
{
ds.Dispose();
}
return(dtbl);
}
public int DeletePO(POFormUI pOFormUI)
{
int result = 0;
try
{
using (SqlConnection SupportCon = new SqlConnection(connectionString))
{
SupportCon.Open();
SqlCommand sqlCmd = new SqlCommand("SP_PO_Delete", SupportCon);
sqlCmd.CommandType = CommandType.StoredProcedure;
sqlCmd.CommandTimeout = commandTimeout;
sqlCmd.Parameters.Add("@tbl_POId", SqlDbType.NVarChar);
sqlCmd.Parameters["@tbl_POId"].Value = pOFormUI.Tbl_POId;
result = sqlCmd.ExecuteNonQuery();
sqlCmd.Dispose();
SupportCon.Close();
}
}
catch (Exception exp)
{
logExcpUIobj.MethodName = "DeletePO()";
logExcpUIobj.ResourceName = "POFormDAL.CS";
logExcpUIobj.RecordId = pOFormUI.Tbl_POId;
logExcpUIobj.ExceptionDetails = "Error Occured. System Generated Error is: " + exp.ToString();
logExcpDALobj.SaveExceptionToDB(logExcpUIobj);
log.Error("[POFormDAL : DeletePO] An error occured in the processing of Record Id : " + pOFormUI.Tbl_POId + ". Details : [" + exp.ToString() + "]");
}
return(result);
}
public int AddPO(POFormUI pOFormUI)
{
int result = 0;
try
{
using (SqlConnection SupportCon = new SqlConnection(connectionString))
{
SupportCon.Open();
SqlCommand sqlCmd = new SqlCommand("SP_PO_Insert", SupportCon);
sqlCmd.CommandType = CommandType.StoredProcedure;
sqlCmd.CommandTimeout = commandTimeout;
sqlCmd.Parameters.Add("@CreatedBy", SqlDbType.NVarChar);
sqlCmd.Parameters["@CreatedBy"].Value = pOFormUI.CreatedBy;
sqlCmd.Parameters.Add("@tbl_OrganizationId", SqlDbType.NVarChar);
sqlCmd.Parameters["@tbl_OrganizationId"].Value = pOFormUI.Tbl_OrganizationId;
sqlCmd.Parameters.Add("@opt_Type", SqlDbType.Int);
sqlCmd.Parameters["@opt_Type"].Value = pOFormUI.opt_Type;
sqlCmd.Parameters.Add("@PONumber", SqlDbType.NVarChar);
sqlCmd.Parameters["@PONumber"].Value = pOFormUI.PONumber;
sqlCmd.Parameters.Add("@tbl_SupplierId", SqlDbType.NVarChar);
sqlCmd.Parameters["@tbl_SupplierId"].Value = pOFormUI.Tbl_SupplierId;
sqlCmd.Parameters.Add("@tbl_UserId_Buyer", SqlDbType.NVarChar);
sqlCmd.Parameters["@tbl_UserId_Buyer"].Value = pOFormUI.Tbl_UserId_Buyer;
sqlCmd.Parameters.Add("@Date", SqlDbType.DateTime);
sqlCmd.Parameters["@Date"].Value = pOFormUI.Date;
sqlCmd.Parameters.Add("@tbl_CurrencyId", SqlDbType.NVarChar);
sqlCmd.Parameters["@tbl_CurrencyId"].Value = pOFormUI.Tbl_CurrencyId;
sqlCmd.Parameters.Add("@AllowSales", SqlDbType.Bit);
sqlCmd.Parameters["@AllowSales"].Value = pOFormUI.AllowSales;
sqlCmd.Parameters.Add("@RequisitionDate", SqlDbType.DateTime);
sqlCmd.Parameters["@RequisitionDate"].Value = pOFormUI.RequisitionDate;
sqlCmd.Parameters.Add("@PurchaseOrderDate", SqlDbType.DateTime);
sqlCmd.Parameters["@PurchaseOrderDate"].Value = pOFormUI.PurchaseOrderDate;
sqlCmd.Parameters.Add("@LastEditDate", SqlDbType.DateTime);
sqlCmd.Parameters["@LastEditDate"].Value = pOFormUI.LastEditDate;
sqlCmd.Parameters.Add("@LastPrintedDate", SqlDbType.DateTime);
sqlCmd.Parameters["@LastPrintedDate"].Value = pOFormUI.LastPrintedDate;
sqlCmd.Parameters.Add("@ContractExpirationDate", SqlDbType.DateTime);
sqlCmd.Parameters["@ContractExpirationDate"].Value = pOFormUI.ContractExpirationDate;
sqlCmd.Parameters.Add("@DatePlacedOnHold", SqlDbType.DateTime);
sqlCmd.Parameters["@DatePlacedOnHold"].Value = pOFormUI.DatePlacedOnHold;
sqlCmd.Parameters.Add("@DateHoldRemoved", SqlDbType.DateTime);
sqlCmd.Parameters["@DateHoldRemoved"].Value = pOFormUI.DateHoldRemoved;
sqlCmd.Parameters.Add("@tbl_UserId_PlacedOnHoldBy", SqlDbType.NVarChar);
sqlCmd.Parameters["@tbl_UserId_PlacedOnHoldBy"].Value = pOFormUI.Tbl_UserId_PlacedOnHoldBy;
sqlCmd.Parameters.Add("@tbl_UserId_HoldRemovedBy", SqlDbType.NVarChar);
sqlCmd.Parameters["@tbl_UserId_HoldRemovedBy"].Value = pOFormUI.Tbl_UserId_HoldRemovedBy;
sqlCmd.Parameters.Add("@RemainingSubTotal", SqlDbType.Decimal);
sqlCmd.Parameters["@RemainingSubTotal"].Value = pOFormUI.RemainingSubTotal;
sqlCmd.Parameters.Add("@SubTotal", SqlDbType.Decimal);
sqlCmd.Parameters["@SubTotal"].Value = pOFormUI.SubTotal;
sqlCmd.Parameters.Add("@TradeDiscount", SqlDbType.Decimal);
sqlCmd.Parameters["@TradeDiscount"].Value = pOFormUI.TradeDiscount;
sqlCmd.Parameters.Add("@Freight", SqlDbType.Decimal);
sqlCmd.Parameters["@Freight"].Value = pOFormUI.Freight;
sqlCmd.Parameters.Add("@Miscellaneous", SqlDbType.Decimal);
sqlCmd.Parameters["@Miscellaneous"].Value = pOFormUI.Miscellaneous;
sqlCmd.Parameters.Add("@Total", SqlDbType.Decimal);
sqlCmd.Parameters["@Total"].Value = pOFormUI.Total;
sqlCmd.Parameters.Add("@tbl_CommentsId", SqlDbType.NVarChar);
sqlCmd.Parameters["@tbl_CommentsId"].Value = pOFormUI.Tbl_CommentsId;
sqlCmd.Parameters.Add("@Version", SqlDbType.Int);
sqlCmd.Parameters["@Version"].Value = pOFormUI.Version;
sqlCmd.Parameters.Add("@opt_Status", SqlDbType.Int);
sqlCmd.Parameters["@opt_Status"].Value = pOFormUI.opt_Status;
result = sqlCmd.ExecuteNonQuery();
sqlCmd.Dispose();
SupportCon.Close();
}
}
catch (Exception exp)
{
logExcpUIobj.MethodName = "AddPO()";
logExcpUIobj.ResourceName = "POFormDAL.CS";
logExcpUIobj.RecordId = "";
logExcpUIobj.ExceptionDetails = "Error Occured. System Generated Error is: " + exp.ToString();
logExcpDALobj.SaveExceptionToDB(logExcpUIobj);
log.Error("[POFormDAL : AddPO] An error occured in the processing of Record. Details : [" + exp.ToString() + "]");
}
return(result);
}
