/// <summary>
/// To Get Data
/// </summary>
/// <param name="CULTURALNEGOID"></param>
/// <returns></returns>
public Nego GetData(int CULTURALNEGOID)
{
OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString);
OracleCommand cmd;
string proc = "USP_TRN_GET_NGO";//"USP_TRN_GET_DAMAGE_CROPS";
cmd = new OracleCommand(proc, cnn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("N_CULTURALNEGOID", CULTURALNEGOID);
cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output;
cmd.Connection.Open();
OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
Nego Ngoobj = null;
NegoList Listobj = new NegoList();
Ngoobj = new Nego();
while (dr.Read())
{
if (!dr.IsDBNull(dr.GetOrdinal("CULTURALNEGOID")))
{
Ngoobj.CULTURALNEGOID = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("CULTURALNEGOID")));
}
if (!dr.IsDBNull(dr.GetOrdinal("CULTURALPROPID")))
{
Ngoobj.CULTURALPROPID = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("CULTURALPROPID")));
}
if (!dr.IsDBNull(dr.GetOrdinal("NEGO_APPOINTMENTDATE")))
{
Ngoobj.NEGO_APPOINTMENTDATE = Convert.ToDateTime(dr.GetValue(dr.GetOrdinal("NEGO_APPOINTMENTDATE")));
}
if (!dr.IsDBNull(dr.GetOrdinal("NEGO_VENUE")))
{
Ngoobj.NEGO_VENUE = dr.GetString(dr.GetOrdinal("NEGO_VENUE"));
}
if (!dr.IsDBNull(dr.GetOrdinal("NEGO_DATE")))
{
Ngoobj.NEGO_DATE = Convert.ToDateTime(dr.GetValue(dr.GetOrdinal("NEGO_DATE")));
}
if (!dr.IsDBNull(dr.GetOrdinal("NEGO_PROBLEMDESC")))
{
Ngoobj.NEGO_PROBLEMDESC = dr.GetString(dr.GetOrdinal("NEGO_PROBLEMDESC"));
}
}
dr.Close();
return(Ngoobj);
}
/// <summary>
/// To Get NGO DATA
/// </summary>
/// <param name="culturalPropertyID"></param>
/// <returns></returns>
public NegoList GetNGODATA(int culturalPropertyID)
{
OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString);
OracleCommand cmd;
string proc = "USP_TRN_SEL_NGO";
cmd = new OracleCommand(proc, cnn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("CULTURALPROPERTYID_", culturalPropertyID);
cmd.Parameters.Add("Sp_recordset", Oracle.DataAccess.Client.OracleDbType.RefCursor).Direction = ParameterDirection.Output;
cmd.Connection.Open();
OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
Nego Ngoobj = null;
NegoList Listobj = new NegoList();
while (dr.Read())
{
Ngoobj = new Nego();
if (!dr.IsDBNull(dr.GetOrdinal("culturalnegoid")))
{
Ngoobj.CULTURALNEGOID = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("culturalnegoid")));
}
if (!dr.IsDBNull(dr.GetOrdinal("nego_appointmentdate")))
{
Ngoobj.NEGO_APPOINTMENTDATE = Convert.ToDateTime(dr.GetValue(dr.GetOrdinal("nego_appointmentdate")));
}
if (!dr.IsDBNull(dr.GetOrdinal("nego_venue")))
{
Ngoobj.NEGO_VENUE = dr.GetString(dr.GetOrdinal("nego_venue"));
}
if (!dr.IsDBNull(dr.GetOrdinal("nego_date")))
{
Ngoobj.NEGO_DATE = Convert.ToDateTime(dr.GetValue(dr.GetOrdinal("nego_date")));
}
if (!dr.IsDBNull(dr.GetOrdinal("nego_problemdesc")))
{
Ngoobj.NEGO_PROBLEMDESC = dr.GetString(dr.GetOrdinal("nego_problemdesc"));
}
Listobj.Add(Ngoobj);
}
dr.Close();
return(Listobj);
}
/// <summary>
/// To Update
/// </summary>
/// <param name="Negoobj"></param>
/// <returns></returns>
public int Update(Nego Negoobj)
{
NegoDAL DALobj = new NegoDAL(); //Data pass -to Database Layer
try
{
return(DALobj.Update(Negoobj));
}
catch (Exception ex)
{
throw ex;
}
finally
{
DALobj = null;
}
}
/// <summary>
/// To Insert into Database
/// </summary>
/// <param name="Negoobj"></param>
/// <returns></returns>
public int Insert(Nego Negoobj)
{
OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString);
cnn.Open();
OracleCommand dcmd = new OracleCommand("USP_TRN_INSERT_NGO", cnn);
dcmd.CommandType = CommandType.StoredProcedure;
int count = Convert.ToInt32(dcmd.CommandType);
try
{
dcmd.Parameters.Add("HHID", Negoobj.HHID);
dcmd.Parameters.Add("CULTURALPROPID", Negoobj.CULTURALPROPID);
dcmd.Parameters.Add("NEGO_APPOINTMENTDATE", Negoobj.NEGO_APPOINTMENTDATE);
dcmd.Parameters.Add("NEGO_VENUE", Negoobj.NEGO_VENUE);
dcmd.Parameters.Add("NEGO_DATE", Negoobj.NEGO_DATE);
if (Negoobj.NEGO_PROBLEMDESC.Trim().Length > 1000)
{
dcmd.Parameters.Add("NEGO_PROBLEMDESC", Negoobj.NEGO_PROBLEMDESC.Substring(0, 1000));
}
else
{
dcmd.Parameters.Add("NEGO_PROBLEMDESC", Negoobj.NEGO_PROBLEMDESC);
}
dcmd.Parameters.Add("ISDELETED", Negoobj.ISDELETED);
dcmd.Parameters.Add("CREATEDBY", Negoobj.CREATEDBY);
return(dcmd.ExecuteNonQuery());
}
catch (Exception ex)
{
throw ex;
}
finally
{
dcmd.Dispose();
cnn.Close();
cnn.Dispose();
}
}
/// <summary>
/// To get the data
/// </summary>
private void GetData()
{
NegoBLL BLLobj = new NegoBLL();
int CULTURALNEGOID = 0;
if (ViewState["CULTURALNEGOID"] != null)
{
CULTURALNEGOID = Convert.ToInt32(ViewState["CULTURALNEGOID"]);
}
Nego BOobj = new Nego();
BOobj = BLLobj.GetData(CULTURALNEGOID);
CULTURALNEGOIDtxtbx.Text = BOobj.CULTURALNEGOID.ToString();
AppntDate.Text = Convert.ToString(BOobj.NEGO_APPOINTMENTDATE.ToString(UtilBO.DateFormat));
txtbxVenueforNegotiation.Text = BOobj.NEGO_VENUE;
NegotDate.Text = Convert.ToString(BOobj.NEGO_DATE.ToString(UtilBO.DateFormat));
txtbxProblems.Text = BOobj.NEGO_PROBLEMDESC;
}
/// <summary>
///To save the scheduled information
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void ScheduledInformBtnSave_Click(object sender, EventArgs e)
{
int count = 0;
if (CULTURALNEGOIDtxtbx.Text == string.Empty)
{
NegoBLL BLLobj = new NegoBLL();
try
{
string uID = Session["USER_ID"].ToString();
string hhid = Session["HH_ID"].ToString();
int CULTURALPROPID = Convert.ToInt32(ViewState["CULTURALPROPID"]);
Nego Negoobj = new Nego();
Negoobj.HHID = Convert.ToInt32(hhid);
Negoobj.CULTURALPROPID = CULTURALPROPID;
Negoobj.NEGO_APPOINTMENTDATE = Convert.ToDateTime(AppntDate.Text);
Negoobj.NEGO_VENUE = txtbxVenueforNegotiation.Text;
Negoobj.NEGO_DATE = Convert.ToDateTime(NegotDate.Text);
if (txtbxProblems.Text != string.Empty)
{
Negoobj.NEGO_PROBLEMDESC = txtbxProblems.Text;
}
else
{
Negoobj.NEGO_PROBLEMDESC = "";
}
Negoobj.ISDELETED = "False";
Negoobj.CREATEDBY = Convert.ToInt32(uID);
NegoBLL NegoBLLobj = new NegoBLL();
count = NegoBLLobj.Insert(Negoobj);
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", "alert('Data saved successfully');", true);
ClearScheduledData();
BindGrid();
}
catch (Exception ex)
{
throw ex;
}
finally
{
BLLobj = null;
}
}
else if (CULTURALNEGOIDtxtbx.Text != string.Empty)
{
NegoBLL BLLobj = new NegoBLL();
try
{
string uID = Session["USER_ID"].ToString();
string hhid = Session["HH_ID"].ToString();
int CULTURALPROPID = Convert.ToInt32(ViewState["CULTURALPROPID"]);
Nego Negoobj = new Nego();
Negoobj.HHID = Convert.ToInt32(hhid);
Negoobj.CULTURALNEGOID = Convert.ToInt32(CULTURALNEGOIDtxtbx.Text);
Negoobj.CULTURALPROPID = CULTURALPROPID;
Negoobj.NEGO_APPOINTMENTDATE = Convert.ToDateTime(AppntDate.Text);
Negoobj.NEGO_VENUE = txtbxVenueforNegotiation.Text;
Negoobj.NEGO_DATE = Convert.ToDateTime(NegotDate.Text);
Negoobj.NEGO_PROBLEMDESC = txtbxProblems.Text;
Negoobj.ISDELETED = "False";
Negoobj.CREATEDBY = Convert.ToInt32(uID);
NegoBLL NegoBLLobj = new NegoBLL();
count = NegoBLLobj.Update(Negoobj);
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Updated", "ShowUpdateMessage('');", true);
ClearScheduledData();
BindGrid();
SetUpdateMode(false);
}
catch (Exception ex)
{
throw ex;
}
finally
{
BLLobj = null;
}
}
}
public ToonStats()
{
ht = new HT(); mf = new MF(); nego = new Nego(); traya = new Traya(); en = new EN(); padme = new Padme(); jkr = new JKR(); grievous = new Grievous(); bsf = new BSF(); bossk = new Bossk(); gba = new GBA(); mal = new Malevolence(); dr = new DR(); dm = new DM();
}
