/// <summary> /// To Get Contracted ID /// </summary> /// <param name="ContractedID"></param> /// <returns></returns> public HIVContractedBO GetContractedID(int ContractedID) { OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString); OracleCommand cmd; string proc = "USP_MST_GET_HIVC"; cmd = new OracleCommand(proc, cnn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("CONTRACTEDID_", ContractedID); cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output; cmd.Connection.Open(); OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); HIVContractedBO objHIVContracted = null; HIVContractedList Users = new HIVContractedList(); objHIVContracted = new HIVContractedBO(); while (dr.Read()) { if (ColumnExists(dr, "CONTRACTED_THROUGH") && !dr.IsDBNull(dr.GetOrdinal("CONTRACTED_THROUGH"))) { objHIVContracted.ContractedThrough = dr.GetString(dr.GetOrdinal("CONTRACTED_THROUGH")); } if (ColumnExists(dr, "CONTRACTED_ID") && !dr.IsDBNull(dr.GetOrdinal("CONTRACTED_ID"))) { objHIVContracted.ContractedID = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("CONTRACTED_ID"))); } } dr.Close(); return(objHIVContracted); }
/// <summary> /// To Get HIV Contracted /// </summary> /// <returns></returns> public HIVContractedList GetHIVContracted() { OracleConnection con = new OracleConnection(AppConfiguration.ConnectionString); OracleCommand cmd; string proc = "USP_MST_GET_HIVC"; cmd = new OracleCommand(proc, con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output; cmd.Connection.Open(); OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); HIVContractedBO objHIVContracted = null; HIVContractedList objHIV = new HIVContractedList(); while (dr.Read()) { objHIVContracted = new HIVContractedBO(); objHIVContracted.ContractedID = dr.GetInt32(dr.GetOrdinal("CONTRACTED_ID")); objHIVContracted.ContractedThrough = dr.GetString(dr.GetOrdinal("CONTRACTED_THROUGH")); // objHIVContracted.Isdeleted = dr.GetString(dr.GetOrdinal("isdeleted")); objHIV.Add(objHIVContracted); } dr.Close(); return(objHIV); }
/// <summary> /// To save details to database /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void SaveButton_Click(object sender, EventArgs e) { string message = ""; HIVContractedBLL HIVContractedBLLobj = null; try { HIVContractedBLLobj = new HIVContractedBLL(); HIVContractedBO objHIVContracted = new HIVContractedBO(); if (Convert.ToInt32(ViewState["ContractedID"]) > 0) { objHIVContracted.ContractedThrough = HIVCTextBox.Text.Trim(); objHIVContracted.ContractedID = Convert.ToInt32(ViewState["ContractedID"]); message = HIVContractedBLLobj.EDITHIVC(objHIVContracted); if (string.IsNullOrEmpty(message) || message == "" || message == "null") { message = "Data updated successfully"; } SetUpdateMode(false); } else { objHIVContracted.ContractedThrough = HIVCTextBox.Text.Trim(); objHIVContracted.CreatedBy = Convert.ToInt32(Session["USER_ID"]); message = HIVContractedBLLobj.insertHIVC(objHIVContracted); if (string.IsNullOrEmpty(message) || message == "" || message == "null") { message = "Data saved successfully"; } } if (message != "") { ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", "alert('" + message + "');", true); } clearfields(); BindGrid(true, true); } catch (Exception ex) { throw ex; } finally { HIVContractedBLLobj = null; } }
/// <summary> /// get the Grid value into textBox /// </summary> private void Get_HIVC_Details() { HIVContractedBLL HIVContractedBLLobj = new HIVContractedBLL(); int ContractedID = 0; if (ViewState["ContractedID"] != null) { ContractedID = Convert.ToInt32(ViewState["ContractedID"]); } HIVContractedBO objHIVContracted = new HIVContractedBO(); objHIVContracted = HIVContractedBLLobj.GetContractedID(ContractedID); HIVCTextBox.Text = objHIVContracted.ContractedThrough; }
/// <summary> /// To EDIT HIVC /// </summary> /// <param name="objHIVContracted"></param> /// <returns></returns> public string EDITHIVC(HIVContractedBO objHIVContracted) { HIVContractedDAL HIVContractedDALobj = new HIVContractedDAL(); //Data pass -to Database Layer try { return(HIVContractedDALobj.EDITHIVC(objHIVContracted)); } catch { throw; } finally { HIVContractedDALobj = null; } }
/// <summary> /// To EDIT HIVC /// </summary> /// <param name="objHIVContracted"></param> /// <returns></returns> public string EDITHIVC(HIVContractedBO objHIVContracted) { string returnResult = ""; OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString); cnn.Open(); OracleCommand dcmd = new OracleCommand("USP_MST_UPD_HIVC", cnn); dcmd.CommandType = CommandType.StoredProcedure; int count = Convert.ToInt32(dcmd.CommandType); try { dcmd.Parameters.Add("CONTRACTEDTHROUGH_", objHIVContracted.ContractedThrough); dcmd.Parameters.Add("CONTRACTEDID_", objHIVContracted.ContractedID); dcmd.Parameters.Add("UpdatedBY", objHIVContracted.CreatedBy); dcmd.Parameters.Add("errorMessage_", OracleDbType.Varchar2, 500).Direction = ParameterDirection.Output; dcmd.ExecuteNonQuery(); if (dcmd.Parameters["errorMessage_"].Value != null) { returnResult = dcmd.Parameters["errorMessage_"].Value.ToString(); } return(returnResult); } catch { throw; } finally { dcmd.Dispose(); cnn.Close(); cnn.Dispose(); } }