/// <summary> /// To GET ALL CardType /// </summary> /// <returns></returns> public CardTypeList GETALLCardType() { // used in Master page OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString); OracleCommand cmd; string proc = " USP_MST_GETALLCardType"; cmd = new OracleCommand(proc, cnn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output; cmd.Connection.Open(); OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); CardTypeBO objCardType = null; CardTypeList CardType = new CardTypeList(); while (dr.Read()) { objCardType = new CardTypeBO(); objCardType.CardTypeID = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("CardTypeID"))); objCardType.CardTypeName = dr.GetString(dr.GetOrdinal("CARDNAME")); objCardType.Isdeleted = dr.GetString(dr.GetOrdinal("IsDeleted")); CardType.Add(objCardType); } dr.Close(); return(CardType); }
/// <summary> /// get the data based on ID /// </summary> /// <param name="CardTypeID"></param> /// <returns></returns> public CardTypeBO GetCardTypeById(int CardTypeID) { OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString); OracleCommand cmd; string proc = "USP_MST_GETSELECTCardType"; cmd = new OracleCommand(proc, cnn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("CardTypeID_", CardTypeID); cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output; cmd.Connection.Open(); OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); CardTypeBO CardTypeObj = null; CardTypeList Users = new CardTypeList(); CardTypeObj = new CardTypeBO(); while (dr.Read()) { if (ColumnExists(dr, "CARDNAME") && !dr.IsDBNull(dr.GetOrdinal("CARDNAME"))) { CardTypeObj.CardTypeName = dr.GetString(dr.GetOrdinal("CARDNAME")); } if (ColumnExists(dr, "CardTypeID") && !dr.IsDBNull(dr.GetOrdinal("CardTypeID"))) { CardTypeObj.CardTypeID = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("CardTypeID"))); } } dr.Close(); return(CardTypeObj); }
/// <summary> /// get the Grid value into textBox /// </summary> private void GetCardTypeDetails(int CardTypeID) { CardTypeBLL CardTypeBLLobj = new CardTypeBLL(); //int CardTypeID = 0; //if (ViewState["CardTypeID"] != null) // CardTypeID = Convert.ToInt32(ViewState["CardTypeID"]); CardTypeBO CardTypeObj = new CardTypeBO(); CardTypeObj = CardTypeBLLobj.GetCardTypeById(CardTypeID); CardTypeTextBox.Text = CardTypeObj.CardTypeName; CardTypeIDTextBox.Text = CardTypeObj.CardTypeID.ToString(); //int CardTypeID_test = Convert.ToInt32(CardTypeObj.CardTypeID); }
//Edit the data public string EDITCardType(CardTypeBO objCardType) { CardTypeDAL CardTypeDAl = new CardTypeDAL(); //Data pass -to Database Layer try { return(CardTypeDAl.EDITCardType(objCardType)); } catch { throw; } finally { CardTypeDAl = null; } }
/// <summary> /// To update data to database /// </summary> /// <param name="objCardType"></param> /// <returns></returns> public string EDITCardType(CardTypeBO objCardType) { string returnResult = string.Empty; OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString); cnn.Open(); OracleCommand dcmd = new OracleCommand("USP_MST_UPDATECCardType", cnn); dcmd.CommandType = CommandType.StoredProcedure; int count = Convert.ToInt32(dcmd.CommandType); try { dcmd.Parameters.Add("CardType_", objCardType.CardTypeName); dcmd.Parameters.Add("CardTypeID_", objCardType.CardTypeID); dcmd.Parameters.Add("UpdatedBY", objCardType.UserID); //return dcmd.ExecuteNonQuery(); 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> /// save data to database /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void SaveButton_Click(object sender, EventArgs e) { // int count = 0; string AlertMessage = string.Empty; string message = string.Empty; if (CardTypeIDTextBox.Text.ToString().Trim() == string.Empty) { CardTypeBLL CardTypeBLLOBJ = new CardTypeBLL(); try { string uID = Session["USER_ID"].ToString(); CardTypeBO objCardType = new CardTypeBO(); objCardType.CardTypeName = CardTypeTextBox.Text.ToString().Trim();; objCardType.UserID = Convert.ToInt32(uID); CardTypeBLL CardTypeBLLobj = new CardTypeBLL(); message = CardTypeBLLobj.Insert(objCardType); AlertMessage = "alert('" + message + "');"; if (string.IsNullOrEmpty(message) || message == "" || message == "null") { message = "Data saved successfully"; clear(); // ClearDetails(); BindGrid(true, true); } } catch (Exception ex) { throw ex; } finally { CardTypeBLLOBJ = null; } } //edit the data in the textbox exiting in the Grid else if (CardTypeIDTextBox.Text.ToString().Trim() != string.Empty) { CardTypeBLL CardTypeBLLOBJ = new CardTypeBLL(); try { string uID = Session["USER_ID"].ToString(); CardTypeBO objCardType = new CardTypeBO(); objCardType.CardTypeName = CardTypeTextBox.Text.ToString().Trim(); objCardType.CardTypeID = Convert.ToInt32(CardTypeIDTextBox.Text.ToString().Trim()); objCardType.UserID = Convert.ToInt32(uID); CardTypeBLL CardTypeBLLobj = new CardTypeBLL(); message = CardTypeBLLobj.EDITCardType(objCardType); if (string.IsNullOrEmpty(message) || message == "" || message == "null") { message = "Data updated successfully"; // ClearDetails(); clear(); SetUpdateMode(false); BindGrid(true, true); } } catch (Exception ex) { throw ex; } finally { CardTypeBLLOBJ = null; } } AlertMessage = "alert('" + message + "');"; ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", AlertMessage, true); }