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