private List <SqlParameter> Set_Values_In_Event_Date(EventDateInfo eventdate)
{
List <SqlParameter> sqlParams = new List <SqlParameter>();
if (eventdate.Event_Date_Id != 0)
{
sqlParams.Add(new SqlParameter("@Event_Date_Id", eventdate.Event_Date_Id));
}
sqlParams.Add(new SqlParameter("@Event_Id", eventdate.Event_Id));
sqlParams.Add(new SqlParameter("@Date", eventdate.Date));
sqlParams.Add(new SqlParameter("@Start_Time", eventdate.Start_Time));
sqlParams.Add(new SqlParameter("@End_Time", eventdate.End_Time));
sqlParams.Add(new SqlParameter("@Is_Active", eventdate.Is_Active));
if (eventdate.Event_Date_Id == 0)
{
sqlParams.Add(new SqlParameter("@Created_By", eventdate.Created_By));
sqlParams.Add(new SqlParameter("@Created_On", eventdate.Created_On));
}
sqlParams.Add(new SqlParameter("@Updated_By", eventdate.Updated_By));
sqlParams.Add(new SqlParameter("@Updated_On", eventdate.Updated_On));
return(sqlParams);
}
private EventDateInfo Get_Event_Date_Values(DataRow dr)
{
EventDateInfo eventdate = new EventDateInfo();
eventdate.Event_Date_Id = Convert.ToInt32(dr["Event_Date_Id"]);
eventdate.Event_Id = Convert.ToInt32(dr["Event_Id"]);
eventdate.Date = Convert.ToDateTime(dr["Date"]);
eventdate.Start_Time = Convert.ToString(dr["Start_Time"]);
eventdate.End_Time = Convert.ToString(dr["End_Time"]);
eventdate.Is_Active = Convert.ToBoolean(dr["Is_Active"]);
eventdate.Created_By = Convert.ToInt32(dr["Created_By"]);
eventdate.Updated_By = Convert.ToInt32(dr["Updated_By"]);
eventdate.Created_On = Convert.ToDateTime(dr["Created_On"]);
eventdate.Updated_On = Convert.ToDateTime(dr["Updated_On"]);
return(eventdate);
}
public EventDateInfo Get_Event_Date_By_Id(int Event_Date_Id)
{
EventDateInfo eventdate = new EventDateInfo();
List <SqlParameter> sqlParams = new List <SqlParameter>();
sqlParams.Add(new SqlParameter("@Event_Date_Id", Event_Date_Id));
DataTable dt = _sqlRepo.ExecuteDataTable(sqlParams, StoredProcedures.Get_Event_Date_By_Id_Sp.ToString(), CommandType.StoredProcedure);
List <DataRow> drList = new List <DataRow>();
drList = dt.AsEnumerable().ToList();
foreach (DataRow dr in drList)
{
eventdate = Get_Event_Date_Values(dr);
}
return(eventdate);
}
public void Update_Event_Date(EventDateInfo eventdate)
{
_eventRepo.Update_Event_Date(eventdate);
}
public void Insert_Event_Date(EventDateInfo eventdate)
{
_eventRepo.Insert_Event_Date(eventdate);
}
public void Update_Event_Date(EventDateInfo eventdate)
{
_sqlRepo.ExecuteNonQuery(Set_Values_In_Event_Date(eventdate), StoredProcedures.Update_Event_Date_Sp.ToString(), CommandType.StoredProcedure);
}
