/// <summary> /// To Add Consultant /// </summary> /// <param name="objCon"></param> /// <returns></returns> public string AddConsultant(ConsultantBO objCon) { { ConsultantDAL objConDAL = new ConsultantDAL(); return(objConDAL.AddConsultant(objCon)); } }
/// <summary> /// To Add Consultant /// </summary> /// <param name="objCon"></param> /// <returns></returns> public string AddConsultant(ConsultantBO objCon) { string result = ""; OracleConnection con = new OracleConnection(AppConfiguration.ConnectionString); OracleCommand myCommand; myCommand = new OracleCommand("USP_TRN_INS_CONSULTANT", con); myCommand.Connection = con; myCommand.CommandType = CommandType.StoredProcedure; myCommand.Parameters.Add("CONSULTANTNAME_", objCon.ConsultName); myCommand.Parameters.Add("PROJECTID_", objCon.ProjectID); myCommand.Parameters.Add("CONSULTANTTYPE_", objCon.ConsultType); myCommand.Parameters.Add("ADDRESS_", objCon.Address); myCommand.Parameters.Add("CONTACTNUMBER_", objCon.ConNumber); myCommand.Parameters.Add("CONTACTPERSON_", objCon.ConPerson); myCommand.Parameters.Add("EMAILADDRESS_", objCon.EmailAddress); myCommand.Parameters.Add("ISDELETEDIN_", "False"); myCommand.Parameters.Add("CREATEDBY_", objCon.CreatedBy); myCommand.Parameters.Add("errorMessage_", OracleDbType.Varchar2, 500).Direction = ParameterDirection.Output; con.Open(); myCommand.ExecuteNonQuery(); con.Close(); if (myCommand.Parameters["errorMessage_"].Value != null) { result = myCommand.Parameters["errorMessage_"].Value.ToString(); } return(result); }
/// <summary> /// To Get Consultant By ID /// </summary> public ConsultantBO GetConsultantByID(int ConID) { OracleConnection con = new OracleConnection(AppConfiguration.ConnectionString); OracleCommand cmd; string proc = "USP_TRN_GET_CONSULTANTBYID"; cmd = new OracleCommand(proc, con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("CONSULTANTID", ConID); cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output; cmd.Connection.Open(); OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); ConsultantBO objCon = null; ConsultantList objConList = new ConsultantList(); while (dr.Read()) { objCon = new ConsultantBO(); objCon.ConsultID = (Convert.ToInt32(dr.GetValue(dr.GetOrdinal("CONSULTANTID")))); objCon.ConsultName = dr.GetValue(dr.GetOrdinal("CONSULTANTNAME")).ToString(); objCon.ConsultType = dr.GetValue(dr.GetOrdinal("CONSULTATIONTYPE")).ToString(); objCon.ConPerson = dr.GetValue(dr.GetOrdinal("CONTACTPERSON")).ToString(); objCon.ConNumber = dr.GetValue(dr.GetOrdinal("CONTACTNUMBER")).ToString(); objCon.Address = dr.GetValue(dr.GetOrdinal("ADDRESS")).ToString(); objCon.EmailAddress = dr.GetValue(dr.GetOrdinal("EMAILADDRESS")).ToString(); objConList.Add(objCon); } dr.Close(); return(objCon); }
/// <summary> /// To Update Consultant /// </summary> /// <param name="objCon"></param> /// <returns></returns> public int UpdateConsultant(ConsultantBO objCon) { OracleConnection con = new OracleConnection(AppConfiguration.ConnectionString); int result = 0; { OracleCommand myCommand; myCommand = new OracleCommand("USP_TRN_UPD_CONSULTANT", con); myCommand.Connection = con; myCommand.CommandType = CommandType.StoredProcedure; myCommand.Parameters.Add("CONSULTANTID", objCon.ConsultID); myCommand.Parameters.Add("@CONSULTANTNAME", objCon.ConsultName); myCommand.Parameters.Add("@CONSULTATIONTYPE", objCon.ConsultType); myCommand.Parameters.Add("@ADDRESS", objCon.Address); myCommand.Parameters.Add("@CONTACTPERSON", objCon.ConPerson); myCommand.Parameters.Add("@CONTACTNUMBER", objCon.ConNumber); myCommand.Parameters.Add("@EMAILADDRESS", objCon.EmailAddress); myCommand.Parameters.Add("UPDATEDBY", objCon.UpdatedBy); con.Open(); result = myCommand.ExecuteNonQuery(); con.Close(); } return(result); }
/// <summary> /// Set Grid Data source /// </summary> /// <param name="addRow"></param> /// <param name="deleteRow"></param>e private void BindGrid(bool addRow, bool deleteRow) { ConsultantBO objCon = new ConsultantBO(); ConsultantBLL objConBLL = new ConsultantBLL(); grdConsultant.DataSource = objConBLL.GetConsultant(Convert.ToInt32(Session["PROJECT_ID"])); grdConsultant.DataBind(); }
/// <summary> /// To bind values to dropdownlist /// </summary> private void Bindconsultantname() { ConsultantBO objCon = new ConsultantBO(); ConsultantBLL objConBLL = new ConsultantBLL(); ddlconsultantname.DataSource = objConBLL.GetConsultant(0); ddlconsultantname.DataTextField = "ConsultName"; ddlconsultantname.DataValueField = "ConsultID"; ddlconsultantname.DataBind(); }
/// <summary> /// Saves details to the database /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btn_Save_Click(object sender, EventArgs e) { string message = ""; ConsultantBO objCon = new ConsultantBO(); objCon.ConsultID = int.Parse(ViewState["CONSULTANTID"].ToString()); objCon.ProjectID = Convert.ToInt32(Session["PROJECT_ID"]); objCon.ConsultName = txtConsultantname.Text.Trim(); objCon.ConsultType = DrpConsultantType.SelectedItem.Value; objCon.EmailAddress = TxtEmailaddress.Text.Trim(); string strMax = TxtAddress.Text.ToString().Trim(); if (strMax.Trim().Length >= 399) { strMax = TxtAddress.Text.ToString().Trim().Substring(0, 399); } objCon.Address = strMax; objCon.ConNumber = TxtContactNum.Text.Trim(); objCon.ConPerson = TxtContactPerson.Text.Trim(); ConsultantBLL objConBLL = new ConsultantBLL(); if (objCon.ConsultID == 0) { objCon.CreatedBy = Convert.ToInt32(Session["USER_ID"]); message = objConBLL.AddConsultant(objCon); if (string.IsNullOrEmpty(message) || message == "" || message == "null") { message = "Data saved successfully"; } } else { objCon.UpdatedBy = Convert.ToInt32(Session["USER_ID"]); objConBLL.UpdateConsultant(objCon); message = "Data updated successfully"; SetUpdateMode(false); } ClearDetails(); BindGrid(true, false); if (message != "") { ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", "alert('" + message + "');", true); } }
/// <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 grdConsultant_RowCommand(object sender, GridViewCommandEventArgs e) { if (e.CommandName == "EditRow") { ViewState["CONSULTANTID"] = e.CommandArgument; ConsultantBO objCon = new ConsultantBO(); ConsultantBLL objConBLL = new ConsultantBLL(); objCon = objConBLL.GetConsultantByID(Convert.ToInt32(ViewState["CONSULTANTID"])); if (objCon != null) { txtConsultantname.Text = objCon.ConsultName; DrpConsultantType.ClearSelection(); if (DrpConsultantType.Items.FindByValue(objCon.ConsultType) != null) { DrpConsultantType.Items.FindByValue(objCon.ConsultType).Selected = true; } TxtEmailaddress.Text = objCon.EmailAddress; TxtAddress.Text = objCon.Address; TxtContactNum.Text = objCon.ConNumber; TxtContactPerson.Text = objCon.ConPerson; } SetUpdateMode(true); } else if (e.CommandName == "DeleteRow") { ConsultantBLL objConBLL = new ConsultantBLL(); objConBLL.DeleteConsultant(Convert.ToInt32(e.CommandArgument)); ClearDetails(); SetUpdateMode(false); BindGrid(false, true); } }
/// <summary> /// To Update Consultant /// </summary> /// <param name="objCon"></param> public void UpdateConsultant(ConsultantBO objCon) { ConsultantDAL objConDAL = new ConsultantDAL(); objConDAL.UpdateConsultant(objCon); }