/// <summary> /// To save details to the database /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void InsertIntoCultureProp() { string ErrorMessage = string.Empty; string AlertMessage = string.Empty; try { string uID = Session["USER_ID"].ToString(); CulturePropertiesMasterBObj = new CulturePropertiesMasterBO(); CulturePropertiesMasterBLLObj = new CulturePropertiesMasterBLL(); CulturePropertiesMasterBObj.CulturePropTypeName = CulturPropertiesTextBox.Text.ToString().Trim(); CulturePropertiesMasterBObj.CreatedBy = uID; ErrorMessage = CulturePropertiesMasterBLLObj.InsertIntoCultureProp(CulturePropertiesMasterBObj); AlertMessage = "alert('" + ErrorMessage + "');"; if (string.IsNullOrEmpty(ErrorMessage) || ErrorMessage == "" || ErrorMessage == "null") { ErrorMessage = "Data saved successfully"; clear(); BindGrid(true, true); } } catch (Exception ex) { throw ex; } AlertMessage = "alert('" + ErrorMessage + "');"; ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", AlertMessage, true); }
/// <summary> /// To fetch details from database /// </summary> /// <param name="CulturePropID"></param> /// <returns></returns> public CulturePropertiesMasterBO GetCulturePropByID(int CulturePropID) { CulturePropTypeList CulturePropTypeListObj = new CulturePropTypeList(); CulturePropertiesMasterBO CulturePropertiesMasterBObj = null; OracleConnection Conn = new OracleConnection(AppConfiguration.ConnectionString); Conn.Open(); OracleCommand Cmd = null; try { Cmd = new OracleCommand("USP_MST_GET_CULTUREPROPBYID", Conn); Cmd.CommandType = CommandType.StoredProcedure; Cmd.Parameters.Add("CULTUREPROPTYPEID_", CulturePropID); Cmd.Parameters.Add("Sp_RecordSet", OracleDbType.RefCursor).Direction = ParameterDirection.Output; OracleDataReader dr = Cmd.ExecuteReader(CommandBehavior.CloseConnection); while (dr.Read()) { CulturePropertiesMasterBObj = new CulturePropertiesMasterBO(); CulturePropertiesMasterBObj.CulturePropTypeID = Convert.ToInt32(dr["CULTUREPROPTYPEID"]); CulturePropertiesMasterBObj.CulturePropTypeName = dr["CULTUREPROPTYPE"].ToString(); } } catch { throw; } finally { Cmd.Dispose(); Conn.Close(); Conn.Dispose(); } return(CulturePropertiesMasterBObj); }
/// <summary> /// calls method save details to the database /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void SaveButton_Click(object sender, EventArgs e) { string AlertMessage = string.Empty; string message = string.Empty; if (CulturPropertiesIDTextBox.Text.ToString().Trim() == string.Empty) { try { InsertIntoCultureProp(); } catch (Exception ex) { throw ex; } } else if (CulturPropertiesIDTextBox.Text.ToString().Trim() != string.Empty) { try { string uID = Session["USER_ID"].ToString(); CulturePropertiesMasterBO CulturePropertiesMasterBObj = new CulturePropertiesMasterBO(); CulturePropertiesMasterBObj.CulturePropTypeName = CulturPropertiesTextBox.Text.ToString().Trim(); CulturePropertiesMasterBObj.CulturePropTypeID = Convert.ToInt32(CulturPropertiesIDTextBox.Text.ToString().Trim()); CulturePropertiesMasterBObj.UpdatedBy = Convert.ToInt32(uID); CulturePropertiesMasterBLL CulturePropertiesMasterBLLObj = new CulturePropertiesMasterBLL(); message = CulturePropertiesMasterBLLObj.EDITCulturePropByID(CulturePropertiesMasterBObj); if (string.IsNullOrEmpty(message) || message == "" || message == "null") { message = "Data updated successfully"; // ClearDetails(); clear(); SetUpdateMode(false); BindGrid(true, true); } } catch (Exception ex) { throw ex; } finally { CulturePropertiesMasterBObj = null; } AlertMessage = "alert('" + message + "');"; ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", AlertMessage, true); } }
/// <summary> /// To update data to database /// </summary> /// <param name="CulturePropertiesMasterBObj"></param> /// <returns></returns> public string EDITCulturePropByID(CulturePropertiesMasterBO CulturePropertiesMasterBObj) { string returnResult = string.Empty; OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString); cnn.Open(); OracleCommand dcmd = new OracleCommand("USP_MST_UPD_CULTUREPROPTYPE", cnn); dcmd.CommandType = CommandType.StoredProcedure; int count = Convert.ToInt32(dcmd.CommandType); try { dcmd.Parameters.Add("CULTUREPROPTYPEID_", CulturePropertiesMasterBObj.CulturePropTypeID); dcmd.Parameters.Add("CULTUREPROPTYPE_", CulturePropertiesMasterBObj.CulturePropTypeName); dcmd.Parameters.Add("UPDATEDBY_", CulturePropertiesMasterBObj.UpdatedBy); //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> /// To fetch details based on cultural propertyID /// </summary> protected void GetCulturePropByID(int CulturePropTypeID) { CulturePropertiesMasterBLL CulturePropertiesMasterBLLObj = null; CulturePropertiesMasterBO CulturePropertiesMasterBObj = null; try { CulturePropertiesMasterBLLObj = new CulturePropertiesMasterBLL(); CulturePropertiesMasterBObj = new CulturePropertiesMasterBO(); CulturePropertiesMasterBObj = CulturePropertiesMasterBLLObj.GetCulturePropByID(CulturePropTypeID); CulturPropertiesTextBox.Text = Convert.ToString(CulturePropertiesMasterBObj.CulturePropTypeName); CulturPropertiesIDTextBox.Text = Convert.ToString(CulturePropertiesMasterBObj.CulturePropTypeID); } catch (Exception ex) { throw ex; } }
/// <summary> /// To save data to database /// </summary> /// <param name="CulturePropertiesMasterBObj"></param> /// <returns></returns> public string InsertIntoCultureProp(CulturePropertiesMasterBO CulturePropertiesMasterBObj) { string ErrorMessage = string.Empty; int CreatedBy = 0; OracleConnection Conn = new OracleConnection(AppConfiguration.ConnectionString); Conn.Open(); OracleCommand Cmd = new OracleCommand("USP_INS_MST_CULTUREPROPERTY", Conn); Cmd.CommandType = CommandType.StoredProcedure; try { CreatedBy = Convert.ToInt32(CulturePropertiesMasterBObj.CreatedBy); Cmd.Parameters.Add("CultureProptype_", CulturePropertiesMasterBObj.CulturePropTypeName); Cmd.Parameters.Add("CreatedBy_", CreatedBy); Cmd.Parameters.Add("errorMessage_", OracleDbType.Varchar2, 500).Direction = ParameterDirection.Output; Cmd.ExecuteNonQuery(); if (Cmd.Parameters["errorMessage_"].Value != null) { ErrorMessage = Cmd.Parameters["errorMessage_"].Value.ToString(); } else { ErrorMessage = ""; } } catch { throw; } finally { Cmd.Dispose(); Conn.Close(); Conn.Dispose(); } return(ErrorMessage); }
/// <summary> /// To fetch details from database /// </summary> /// <returns></returns> public CulturePropTypeList GetAllCulturePropertyType() { CulturePropTypeList CulturePropTypeListObj = new CulturePropTypeList(); CulturePropertiesMasterBO CulturePropertiesMasterBObj = null; OracleConnection Conn = new OracleConnection(AppConfiguration.ConnectionString); Conn.Open(); OracleCommand Cmd = null; try { Cmd = new OracleCommand("USP_SEL_MST_CULTUREPROPERTY", Conn); Cmd.CommandType = CommandType.StoredProcedure; Cmd.Parameters.Add("Sp_recordset", Oracle.DataAccess.Client.OracleDbType.RefCursor).Direction = ParameterDirection.Output; OracleDataReader dr = Cmd.ExecuteReader(CommandBehavior.CloseConnection); while (dr.Read()) { CulturePropertiesMasterBObj = new CulturePropertiesMasterBO(); CulturePropertiesMasterBObj.CulturePropTypeID = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("CULTUREPROPTYPEID"))); CulturePropertiesMasterBObj.CulturePropTypeName = dr.GetString(dr.GetOrdinal("CULTUREPROPTYPE")); CulturePropertiesMasterBObj.Isdeleted = dr.GetString(dr.GetOrdinal("ISDELETED")); CulturePropTypeListObj.Add(CulturePropertiesMasterBObj); } } catch { throw; } finally { Cmd.Dispose(); Conn.Close(); Conn.Dispose(); } return(CulturePropTypeListObj); }
/// <summary> /// To EDIT Culture Properties By ID /// </summary> /// <param name="CulturePropertiesMasterBObj"></param> /// <returns></returns> public string EDITCulturePropByID(CulturePropertiesMasterBO CulturePropertiesMasterBObj) { CulturePropertiesMasterDALObj = new CulturePropertiesMasterDAL(); return(CulturePropertiesMasterDALObj.EDITCulturePropByID(CulturePropertiesMasterBObj)); }
/// <summary> /// To Insert Into Culture Properties /// </summary> /// <param name="CulturePropertiesMasterBObj"></param> /// <returns></returns> public string InsertIntoCultureProp(CulturePropertiesMasterBO CulturePropertiesMasterBObj) { CulturePropertiesMasterDALObj = new CulturePropertiesMasterDAL(); return(CulturePropertiesMasterDALObj.InsertIntoCultureProp(CulturePropertiesMasterBObj)); }