/// <summary>
/// To get All Category details from database
/// </summary>
/// <returns></returns>
public BudgetEstimationList getAllCategory()
{
OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString);
OracleCommand cmd;
string proc = "USP_MST_SELECTALLCATEGORY";
cmd = new OracleCommand(proc, cnn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("Sp_recordset", Oracle.DataAccess.Client.OracleDbType.RefCursor).Direction = ParameterDirection.Output;
cmd.Connection.Open();
OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
BudgetEstimationBO objBudgetEstimation = null;
BudgetEstimationList BudgetEstimationList = new BudgetEstimationList();
while (dr.Read())
{
objBudgetEstimation = new BudgetEstimationBO();
objBudgetEstimation.CategoryID = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("BGT_CATEGORYID")));
objBudgetEstimation.CategoryName = dr.GetString(dr.GetOrdinal("BGT_CATEGORYNAME"));
BudgetEstimationList.Add(objBudgetEstimation);
}
dr.Close();
return(BudgetEstimationList);
}
/// <summary>
/// To Get Budget Estimation details by ID
/// </summary>
/// <param name="pID"></param>
/// <param name="categoryID"></param>
/// <returns></returns>
public BudgetEstimationBO GetBudgetEstimationByID(int BudgetEstimationID)
{
OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString);
OracleCommand cmd;
string proc = "USP_MST_GET_BGT_EST_BYID";
cmd = new OracleCommand(proc, cnn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("BudgetEstimationID_", BudgetEstimationID);
cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output;
cmd.Connection.Open();
OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
BudgetEstimationBO BudgetEstimationBOObj = null;
BudgetEstimationList BudgetEstimationList = new BudgetEstimationList();
BudgetEstimationBOObj = new BudgetEstimationBO();
while (dr.Read())
{
if (ColumnExists(dr, "BGT_ESTIMATIONID") && !dr.IsDBNull(dr.GetOrdinal("BGT_ESTIMATIONID")))
{
BudgetEstimationBOObj.BudgetEstimationID = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("BGT_ESTIMATIONID")));
}
if (ColumnExists(dr, "BGT_SUBCATEGORYID") && !dr.IsDBNull(dr.GetOrdinal("BGT_SUBCATEGORYID")))
{
BudgetEstimationBOObj.SubCategoryID = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("BGT_SUBCATEGORYID")));
}
if (ColumnExists(dr, "BGT_CATEGORYID") && !dr.IsDBNull(dr.GetOrdinal("BGT_CATEGORYID")))
{
BudgetEstimationBOObj.CategoryID = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("BGT_CATEGORYID")));
}
if (ColumnExists(dr, "EST_VALUE") && !dr.IsDBNull(dr.GetOrdinal("EST_VALUE")))
{
BudgetEstimationBOObj.ValueAmount = Convert.ToString(dr.GetValue(dr.GetOrdinal("EST_VALUE")));
}
if (ColumnExists(dr, "EST_PERCENTAGE") && !dr.IsDBNull(dr.GetOrdinal("EST_PERCENTAGE")))
{
BudgetEstimationBOObj.ValueAmountper = Convert.ToString(dr.GetValue(dr.GetOrdinal("EST_PERCENTAGE")));
}
if (!dr.IsDBNull(dr.GetOrdinal("accountcode")))
{
BudgetEstimationBOObj.AccountNo = Convert.ToString(dr.GetValue(dr.GetOrdinal("accountcode")));
}
}
dr.Close();
return(BudgetEstimationBOObj);
}
/// <summary>
/// Set edit mode for edit comand
/// Delete data from the database for delete comand
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void grdBudgetEstimation_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "EditRow")
{
ViewState["BudgetEstimationID"] = e.CommandArgument;
BudgetEstimationBO objBudgetEstimation = new BudgetEstimationBO();
BudgetEstimationBLL objBudgetEstimationBLL = new BudgetEstimationBLL();
objBudgetEstimation = objBudgetEstimationBLL.GetBudgetEstimationByID(Convert.ToInt32(ViewState["BudgetEstimationID"]));
if (objBudgetEstimation != null)
{
ValueTextBox.Text = UtilBO.CurrencyFormat(Convert.ToDecimal(objBudgetEstimation.ValueAmount));
HiddenFieldTotalValue.Value = (float.Parse(HiddenFieldTotalValue.Value) - float.Parse(objBudgetEstimation.ValueAmount)).ToString();
ValuePerTextBox.Text = objBudgetEstimation.ValueAmountper;
BudgetEstimationIDTextBox.Text = objBudgetEstimation.BudgetEstimationID.ToString();
CategoryDropDownList.ClearSelection();
if (CategoryDropDownList.Items.FindByValue(objBudgetEstimation.CategoryID.ToString()) != null)
{
CategoryDropDownList.Items.FindByValue(objBudgetEstimation.CategoryID.ToString()).Selected = true;
}
getSubCatByCatID();
SubCategoryDropDownList.ClearSelection();
if (SubCategoryDropDownList.Items.FindByValue(objBudgetEstimation.SubCategoryID.ToString()) != null)
{
SubCategoryDropDownList.Items.FindByValue(objBudgetEstimation.SubCategoryID.ToString()).Selected = true;
}
AcountNumberTextBox.Text = objBudgetEstimation.AccountNo;
}
SetUpdateMode(true);
}
else if (e.CommandName == "DeleteRow")
{
string message = string.Empty;
string budgetEstimationID = e.CommandArgument.ToString();
BudgetEstimationBLL objBudgetEstimationBLL = new BudgetEstimationBLL();
message = objBudgetEstimationBLL.DeleteBudgetEstimation(Convert.ToInt32(budgetEstimationID));
if (string.IsNullOrEmpty(message) || message == "" || message == "null")
{
message = "Data deleted successfully";
}
if (message != "")
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", "alert('" + message + "');", true);
}
ClearDetails();
SetUpdateMode(false);
BindEstCategories();
getToatlBudgetValue();
}
}
/// <summary>
/// Method to fetch currency from database and assign to textbox
/// </summary>
private void getBudgetCurrenceFromProject()
{
BudgetEstimationBLL BudgetEstimationBLLObj = new BudgetEstimationBLL();
BudgetEstimationBO BudgetEstimationBOObj = new BudgetEstimationBO();
string projectID = Session["PROJECT_ID"].ToString();
BudgetEstimationBOObj = BudgetEstimationBLLObj.getCurrenceFromProject(projectID);
MillionUSH.Text = BudgetEstimationBOObj.CurrencyCode;
lblTotalBudgEstCurr.Text = BudgetEstimationBOObj.CurrencyCode;
CurrenceID.Text = BudgetEstimationBOObj.CurrencyID.ToString();
CurrenceID.Visible = false;
}
/// <summary>
/// To update Budget Estimation details
/// </summary>
/// <param name="objBudgetEstimation"></param>
/// <returns></returns>
public string EditBudgetEstimation(BudgetEstimationBO objBudgetEstimation)
{
OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString);
cnn.Open();
OracleCommand dcmd = new OracleCommand("USP_TRN_UPDATE_PROJ_BGT_EST", cnn);
dcmd.CommandType = CommandType.StoredProcedure;
int count = Convert.ToInt32(dcmd.CommandType);
string returnResult = string.Empty;
try
{
dcmd.Parameters.Add("BudgetEstimationID_", objBudgetEstimation.BudgetEstimationID);
dcmd.Parameters.Add("CategoryID_", objBudgetEstimation.CategoryID);
dcmd.Parameters.Add("SubCategoryID_", objBudgetEstimation.SubCategoryID);
dcmd.Parameters.Add("ValueAmount_", objBudgetEstimation.ValueAmount);
dcmd.Parameters.Add("ValueAmountper_", objBudgetEstimation.ValueAmountper);
dcmd.Parameters.Add("ProjectID_", objBudgetEstimation.ProjectID);
dcmd.Parameters.Add("UserID_", objBudgetEstimation.UserID);
dcmd.Parameters.Add("CurrencyID_", objBudgetEstimation.CurrencyID);
dcmd.Parameters.Add("AccountNo_", objBudgetEstimation.AccountNo);
dcmd.Parameters.Add("errorMessage_", OracleDbType.Varchar2, 500).Direction = ParameterDirection.Output;
dcmd.ExecuteNonQuery();
if (dcmd.Parameters["errorMessage_"].Value != null)
{
returnResult = dcmd.Parameters["errorMessage_"].Value.ToString();
}
else
{
returnResult = string.Empty;
}
}
catch
{
throw;
}
finally
{
dcmd.Dispose();
cnn.Close();
cnn.Dispose();
}
return(returnResult);
}
/// <summary>
/// To save category details to the database
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void Category_SaveButton_Click(object sender, EventArgs e)
{
string AlertMessage = string.Empty;
string message = string.Empty;
BudgetEstimationBLL BudgetEstimationBLLobj = new BudgetEstimationBLL();
try
{
string uID = Session["USER_ID"].ToString();
BudgetEstimationBO objNEWCategory = new BudgetEstimationBO();
objNEWCategory.CategoryName = AddCategoryTextBox.Text.ToString().Trim();
objNEWCategory.UserID = Convert.ToInt32(uID);
//BudgetEstimationBLL BudgetEstimationBLLobj = new BudgetEstimationBLL();
message = BudgetEstimationBLLobj.InsertNEWCategory(objNEWCategory);
if (string.IsNullOrEmpty(message) || message == "" || message == "null")
{
message = "Data saved successfully";
BindCategories(true);
BindNewCategories(true);
BindEstCategories();
// SubCategoryDropDownList.Items.Clear();
ListItem lstItem = SubCategoryDropDownList.Items[0];
SubCategoryDropDownList.Items.Clear();
SubCategoryDropDownList.Items.Insert(0, lstItem);
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
BudgetEstimationBLLobj = null;
AddCategoryTextBox.Text = "";
}
AlertMessage = "alert('" + message + "');";
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", AlertMessage, true);
}
/// <summary>
/// To get SubCategory ByCategoryID
/// </summary>
/// <param name="CategoryID"></param>
/// <returns></returns>
public BudgetEstimationList getSubCatByCatID(int CategoryID)
{
OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString);
OracleCommand cmd;
string proc = "USP_MST_GET_SUBCATBYID";
cmd = new OracleCommand(proc, cnn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("CategoryID_", CategoryID);
cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output;
cmd.Connection.Open();
OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
BudgetEstimationBO BudgetEstimationObj = null;
BudgetEstimationList BudgetEstimationList = new BudgetEstimationList();
while (dr.Read())
{
BudgetEstimationObj = new BudgetEstimationBO();
if (ColumnExists(dr, "BGT_SUBCATEGORYNAME") && !dr.IsDBNull(dr.GetOrdinal("BGT_SUBCATEGORYNAME")))
{
BudgetEstimationObj.SubCategoryName = dr.GetString(dr.GetOrdinal("BGT_SUBCATEGORYNAME"));
}
if (ColumnExists(dr, "BGT_SUBCATEGORYID") && !dr.IsDBNull(dr.GetOrdinal("BGT_SUBCATEGORYID")))
{
BudgetEstimationObj.SubCategoryID = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("BGT_SUBCATEGORYID")));
}
if (ColumnExists(dr, "BGT_CATEGORYID") && !dr.IsDBNull(dr.GetOrdinal("BGT_CATEGORYID")))
{
BudgetEstimationObj.CategoryID = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("BGT_CATEGORYID")));
}
BudgetEstimationList.Add(BudgetEstimationObj);
}
dr.Close();
return(BudgetEstimationList);
}
/// <summary>
/// To Insert NEW sub Category details
/// </summary>
/// <param name="objNEWCategory"></param>
/// <returns></returns>
public string InsertNEWsubCategory(BudgetEstimationBO objNEWsubCategory)
{
string returnResult = string.Empty;
OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString);
cnn.Open();
OracleCommand dcmd = new OracleCommand("USP_MST_BGT_EST_SUBCATEGORY", cnn);
dcmd.CommandType = CommandType.StoredProcedure;
int count = Convert.ToInt32(dcmd.CommandType);
try
{
dcmd.Parameters.Add("SUBCategoryName_", objNEWsubCategory.SubCategoryName);
dcmd.Parameters.Add("CategoryID_", objNEWsubCategory.CategoryID);
dcmd.Parameters.Add("UserID_", objNEWsubCategory.UserID);
dcmd.Parameters.Add("errorMessage_", OracleDbType.Varchar2, 500).Direction = ParameterDirection.Output;
dcmd.ExecuteNonQuery();
if (dcmd.Parameters["errorMessage_"].Value != null)
{
returnResult = dcmd.Parameters["errorMessage_"].Value.ToString();
}
else
{
returnResult = string.Empty;
}
}
catch
{
throw;
}
finally
{
dcmd.Dispose();
cnn.Close();
cnn.Dispose();
}
return(returnResult);
}
/// <summary>
/// To get Currency From Project details
/// </summary>
/// <param name="projectID"></param>
/// <returns></returns>
public BudgetEstimationBO getCurrenceFromProject(string projectID)
{
OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString);
OracleCommand cmd;
string proc = "USP_MST_SELECTCURRBUDEST";
cmd = new OracleCommand(proc, cnn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("projectID_", projectID);
cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output;
cmd.Connection.Open();
OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
BudgetEstimationBO BudgetEstimationBOObj = null;
BudgetEstimationList BudgetEstimationList = new BudgetEstimationList();
BudgetEstimationBOObj = new BudgetEstimationBO();
while (dr.Read())
{
if (ColumnExists(dr, "CURRENCYID") && !dr.IsDBNull(dr.GetOrdinal("CURRENCYID")))
{
BudgetEstimationBOObj.CurrencyID = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("CURRENCYID")));
}
if (ColumnExists(dr, "CURRENCYCODE") && !dr.IsDBNull(dr.GetOrdinal("CURRENCYCODE")))
{
BudgetEstimationBOObj.CurrencyCode = dr.GetString(dr.GetOrdinal(("CURRENCYCODE")));
}
if (ColumnExists(dr, "PROJECTID") && !dr.IsDBNull(dr.GetOrdinal("PROJECTID")))
{
BudgetEstimationBOObj.ProjectID = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("PROJECTID")));
}
}
dr.Close();
return(BudgetEstimationBOObj);
}
/// <summary>
/// To save details to the database
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void SaveButton_Click(object sender, EventArgs e)
{
ViewState["BudgetEstimationID"] = 0;
BudgetEstimationBLL BudgetEstimationBLLobj = new BudgetEstimationBLL();
if (BudgetEstimationIDTextBox.Text != "0")
{
string uID = Session["USER_ID"].ToString();
string pID = Session["PROJECT_ID"].ToString();
BudgetEstimationBO objBudgetEstimation = new BudgetEstimationBO();
objBudgetEstimation.BudgetEstimationID = Convert.ToInt32(BudgetEstimationIDTextBox.Text);
objBudgetEstimation.CategoryID = Convert.ToInt32(CategoryDropDownList.SelectedItem.Value.ToString().Trim());
objBudgetEstimation.SubCategoryID = Convert.ToInt32(SubCategoryDropDownList.SelectedItem.Value.ToString());
objBudgetEstimation.ValueAmount = ValueTextBox.Text.ToString().Replace(",", "").Trim();
objBudgetEstimation.ValueAmountper = ValuePerTextBox.Text.ToString().Trim();
objBudgetEstimation.UserID = Convert.ToInt32(uID);
objBudgetEstimation.ProjectID = Convert.ToInt32(pID);
objBudgetEstimation.CurrencyID = Convert.ToInt32(CurrenceID.Text.ToString());
objBudgetEstimation.AccountNo = AcountNumberTextBox.Text.ToString();
//BudgetEstimationBLL BudgetEstimationBLLobj = new BudgetEstimationBLL();
string message = BudgetEstimationBLLobj.EditBudgetEstimation(objBudgetEstimation);
if (message == string.Empty || message == "null")
{
BudgetEstimationIDTextBox.Text = "0";
BindEstCategories();
getToatlBudgetValue();
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", "alert('Data Updated successfully');", true);
ClearDetails();
SetUpdateMode(false);
}
else
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", "alert('" + message + "');", true);
}
}
else
{
try
{
string uID = Session["USER_ID"].ToString();
string pID = Session["PROJECT_ID"].ToString();
BudgetEstimationBO objBudgetEstimation = new BudgetEstimationBO();
objBudgetEstimation.CategoryID = Convert.ToInt32(CategoryDropDownList.SelectedItem.Value.ToString().Trim());
objBudgetEstimation.SubCategoryID = Convert.ToInt32(SubCategoryDropDownList.SelectedItem.Value.ToString());
objBudgetEstimation.ValueAmount = ValueTextBox.Text.ToString().Replace(",", "").Trim();
objBudgetEstimation.ValueAmountper = ValuePerTextBox.Text;
objBudgetEstimation.UserID = Convert.ToInt32(uID);
objBudgetEstimation.ProjectID = Convert.ToInt32(pID);
objBudgetEstimation.CurrencyID = Convert.ToInt32(CurrenceID.Text.ToString());
objBudgetEstimation.AccountNo = AcountNumberTextBox.Text.ToString();
//if (ddlCurrencyBudget.SelectedIndex > 0)
//{
// objBudgetEstimation.BudgetCurrency = Convert.ToInt32(ddlCurrencyBudget.SelectedValue);
//}
//BudgetEstimationBLL BudgetEstimationBLLobj = new BudgetEstimationBLL();
string message = BudgetEstimationBLLobj.InsertBudgetEstimation(objBudgetEstimation);
if (message == string.Empty || message == "null")
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", "alert('Data saved successfully');", true);
BindEstCategories();
getToatlBudgetValue();
ClearDetails();
}
else
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", "alert('" + message + "');", true);
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
BudgetEstimationBLLobj = null;
}
}
}
/// <summary>
/// To Insert NEW sub Category details
/// </summary>
/// <param name="objNEWCategory"></param>
/// <returns></returns>
public string InsertNEWsubCategory(BudgetEstimationBO objNEWsubCategory)
{
BudgetEstimationDAL BudgetEstimationDAL = new BudgetEstimationDAL(); //Data pass -to Database Layer
return(BudgetEstimationDAL.InsertNEWsubCategory(objNEWsubCategory));
}
/// <summary>
/// To Insert Budget Estimation details
/// </summary>
/// <param name="objBudgetEstimation"></param>
/// <returns></returns>
public string InsertBudgetEstimation(BudgetEstimationBO objBudgetEstimation)
{
BudgetEstimationDAL BudgetEstimationDAL = new BudgetEstimationDAL(); //Data pass -to Database Layer
return(BudgetEstimationDAL.InsertBudgetEstimation(objBudgetEstimation));
}
