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