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