public bool AddOrUpdateStaffingDateRange(StaffingDateRange record, string sp)
{
bool isrecordAddedOrUpdated = false;
using (SqlConnection con = GetConnection())
{
con.Open();
SqlCommand command = new SqlCommand(sp, con);
command.CommandType = CommandType.StoredProcedure;
SqlParameter StartDate = GetParameter("@StartDate", SqlDbType.Date, record.StartDate);
SqlParameter EndDate = GetParameter("@EndDate", SqlDbType.Date, record.EndDate);
if (record.Index > 0)
{
//Update
SqlParameter Index = GetParameter("@StaffingDateIndex", SqlDbType.Int, record.Index);
command.Parameters.Add(Index);
}
command.Parameters.Add(StartDate);
command.Parameters.Add(EndDate);
var results = command.ExecuteNonQuery();
if (results > -1)
{
isrecordAddedOrUpdated = true;
}
}
return(isrecordAddedOrUpdated);
}
private void BindInitialData()
{
if (ActionType == Constants.Update && !string.IsNullOrEmpty(ID))
{
int currentPeriodIndex = 0;
int.TryParse(ID, out currentPeriodIndex);
if (currentPeriodIndex > 0)
{
record = staffingDateRangeDA.GetAllStaffingDateRange(currentPeriodIndex);
PeriodStartDate_TextBox.Text = record.StartDate.ToShortDateString();
PeriodEndDate_TextBox.Text = record.EndDate.ToShortDateString();
}
}
}
public List <StaffingDateRange> GetAllStaffingDateRanges()
{
List <StaffingDateRange> data = new List <StaffingDateRange>();
using (SqlConnection con = GetConnection())
{
con.Open();
SqlCommand command = new SqlCommand("GetAllStaffingDateRange", con);
command.CommandType = CommandType.StoredProcedure;
var results = command.ExecuteReader();
if (results.HasRows)
{
StaffingDateRange staffingDateRange;
int tempInt;
DateTime date;
while (results.Read())
{
staffingDateRange = new StaffingDateRange();
if (int.TryParse(results["StaffingDateIndex"].ToString(), out tempInt))
{
staffingDateRange.Index = tempInt;
}
if (DateTime.TryParse(results["StartDate"].ToString(), out date))
{
staffingDateRange.StartDate = date;
}
if (DateTime.TryParse(results["EndDate"].ToString(), out date))
{
staffingDateRange.EndDate = date;
}
data.Add(staffingDateRange);
}
}
}
return(data);
}
public bool DeleteStaffingdateRange(StaffingDateRange record)
{
bool executionStatus = false;
using (SqlConnection con = GetConnection())
{
con.Open();
SqlCommand command = new SqlCommand("DeletStaffingDateRangeByIndex", con);
command.CommandType = CommandType.StoredProcedure;
SqlParameter Index = GetParameter("@StaffingDateIndex", SqlDbType.Int, record.Index);
command.Parameters.Add(Index);
var results = command.ExecuteNonQuery();
if (results > 0)
{
executionStatus = true;
}
}
return(executionStatus);
}
public bool UpdateStaffingDateRange(StaffingDateRange record)
{
return(AddOrUpdateStaffingDateRange(record, "UpdateStaffingDateRange"));
}
public bool AddStaffingDateRange(StaffingDateRange record)
{
return(AddOrUpdateStaffingDateRange(record, "InsertStaffingDateRange"));
}