/// <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)); }