public Boolean MoveInRevenueDeleteVerify()
{
DataSet dsRevenue = new DataSet();
using (SqlConnection Connection = new SqlConnection(ConfigurationManager.AppSettings["WebApplication"]))
{
using (SqlCommand Command = new SqlCommand("BonusPlan.MoveInRevenueDeleteVerify", Connection))
{
Command.CommandType = CommandType.StoredProcedure;
Command.CommandTimeout = 600;
Command.Parameters.Add("@MoveInRevenueID", SqlDbType.Int);
Command.Parameters["@MoveInRevenueID"].Value = MoveInRevenueID.NullIfEmpty();
using (SqlDataAdapter DataAdapter = new SqlDataAdapter(Command))
{
DataAdapter.Fill(dsRevenue);
}
}
}
if (dsRevenue.HasRows())
{
return(false);
}
else
{
return(true);
}
}
public DataSet MoveInRevenueDetailGet()
{
DataSet dsRevenue = new DataSet();
using (SqlConnection Connection = new SqlConnection(ConfigurationManager.AppSettings["WebApplication"]))
{
using (SqlCommand Command = new SqlCommand("BonusPlan.MoveInRevenueDetailGet", Connection))
{
Command.CommandType = CommandType.StoredProcedure;
Command.CommandTimeout = 600;
Command.Parameters.Add("@MoveInRevenueID", SqlDbType.Int);
Command.Parameters["@MoveInRevenueID"].Value = MoveInRevenueID.NullIfEmpty();
using (SqlDataAdapter DataAdapter = new SqlDataAdapter(Command))
{
DataAdapter.Fill(dsRevenue);
if (dsRevenue.HasRows())
{
CustomerID = dsRevenue.Tables[0].Rows[0]["CustomerID"].ToString();
MoveInDate = dsRevenue.Tables[0].Rows[0]["MoveInDt"].ToString();
MoveOutDate = dsRevenue.Tables[0].Rows[0]["MoveOutDt"].ToString();
CommunityID = dsRevenue.Tables[0].Rows[0]["CommunityID"].ToString();
Community = dsRevenue.Tables[0].Rows[0]["Community"].ToString();
}
}
}
}
return(dsRevenue);
}
public void MoveInRevenueDelete()
{
SqlConnection connection = new SqlConnection(System.Configuration.ConfigurationManager.AppSettings["WebApplication"]);
using (connection)
{
connection.Open();
SqlCommand Command = new SqlCommand("BonusPlan.MoveInRevenueDelete", connection);
Command.Parameters.Add("@MoveInRevenueID", SqlDbType.Int);
Command.Parameters["@MoveInRevenueID"].Value = MoveInRevenueID.NullIfEmpty();
Command.CommandType = CommandType.StoredProcedure;
Command.CommandTimeout = 600;
Command.ExecuteNonQuery();
}
}
