public static ScheduleTask UpdateItem(ScheduleTask model) { String result = String.Empty; using (var reader = SqlHelper.ExecuteReader(CommandType.StoredProcedure, "ScheduleTask_Update", CreateSqlParameter(model))) { while (reader.Read()) { result = (String)reader[0]; } } return(GetItemByID(model.Id, model.CompanyID)); }
public static ScheduleTaskCollection Search(SearchFilter SearchKey) { ScheduleTaskCollection collection = new ScheduleTaskCollection(); using (var reader = SqlHelper.ExecuteReader("ScheduleTask_Search", SearchFilterManager.SqlSearchParam(SearchKey))) { while (reader.Read()) { ScheduleTask obj = new ScheduleTask(); obj = GetItemFromReader(reader); collection.Add(obj); } } return(collection); }
//public static ScheduleTask GetbyType(string Type, int CompanyID) //{ // ScheduleTaskCollection collection = new ScheduleTaskCollection(); // ScheduleTask obj; // var sqlParams = new SqlParameter[] // { // new SqlParameter("@Type", Type), // new SqlParameter("@CompanyID", CompanyID), // }; // using (var reader = SqlHelper.ExecuteReader("ScheduleTask_GetAll_byType", sqlParams)) // { // while (reader.Read()) // { // obj = GetItemFromReader(reader); // collection.Add(obj); // } // } // return collection; //} public static ScheduleTask GetbyType(string Type, int CompanyID) { ScheduleTask item = new ScheduleTask(); var sqlParams = new SqlParameter[] { new SqlParameter("@Type", Type), new SqlParameter("@CompanyID", CompanyID), }; using (var reader = SqlHelper.ExecuteReader("ScheduleTask_GetAll_byType", sqlParams)) { while (reader.Read()) { item = GetItemFromReader(reader); } } return(item); }
public static ScheduleTask GetItemByID(int Id, int CompanyID) { ScheduleTask item = new ScheduleTask(); var sqlParams = new SqlParameter[] { new SqlParameter("@Id", Id), new SqlParameter("@CompanyID", CompanyID), }; using (var reader = SqlHelper.ExecuteReader("ScheduleTask_GetByID", sqlParams)) { while (reader.Read()) { item = GetItemFromReader(reader); } } return(item); }
public static ScheduleTask AddItem(ScheduleTask model) { int result = 0; try { using (var reader = SqlHelper.ExecuteReader(CommandType.StoredProcedure, "ScheduleTask_Add", CreateSqlParameter(model))) { while (reader.Read()) { result = (int)reader[0]; } } } catch (Exception ObjEx) { } return(GetItemByID(result, model.CompanyID)); }
public static ScheduleTaskCollection GetAllItem(int CompanyID) { ScheduleTaskCollection collection = new ScheduleTaskCollection(); var sqlParams = new SqlParameter[] { new SqlParameter("@CompanyID", CompanyID), }; using (var reader = SqlHelper.ExecuteReader("ScheduleTask_GetAll", sqlParams)) { while (reader.Read()) { ScheduleTask obj = new ScheduleTask(); obj = GetItemFromReader(reader); collection.Add(obj); } } return(collection); }
private static ScheduleTask GetItemFromReader(IDataReader dataReader) { ScheduleTask objItem = new ScheduleTask(); objItem.CompanyID = SqlHelper.GetInt(dataReader, "CompanyID"); objItem.Id = SqlHelper.GetInt(dataReader, "Id"); objItem.Name = SqlHelper.GetString(dataReader, "Name"); objItem.Seconds = SqlHelper.GetInt(dataReader, "Seconds"); objItem.Type = SqlHelper.GetString(dataReader, "Type"); objItem.Enabled = SqlHelper.GetBoolean(dataReader, "Enabled"); objItem.StopOnError = SqlHelper.GetBoolean(dataReader, "StopOnError"); objItem.LeasedByMachineName = SqlHelper.GetString(dataReader, "LeasedByMachineName"); objItem.LeasedUntilUtc = SqlHelper.GetDateTime(dataReader, "LeasedUntilUtc"); objItem.LastStartUtc = SqlHelper.GetDateTime(dataReader, "LastStartUtc"); objItem.LastEndUtc = SqlHelper.GetDateTime(dataReader, "LastEndUtc"); objItem.LastSuccessUtc = SqlHelper.GetDateTime(dataReader, "LastSuccessUtc"); objItem.CreatedDate = SqlHelper.GetDateTime(dataReader, "CreatedDate"); objItem.CreatedUser = SqlHelper.GetInt(dataReader, "CreatedUser"); objItem.ScreenID = SqlHelper.GetString(dataReader, "ScreenID"); if (SqlHelper.ColumnExists(dataReader, "TotalRecord")) { objItem.TotalRecord = SqlHelper.GetInt(dataReader, "TotalRecord"); } return(objItem); }
private static SqlParameter[] CreateSqlParameter(ScheduleTask model) { return(new SqlParameter[] { new SqlParameter("@CompanyID", model.CompanyID), new SqlParameter("@Id", model.Id), new SqlParameter("@Name", model.Name), new SqlParameter("@Seconds", model.Seconds), new SqlParameter("@Type", model.Type), new SqlParameter("@Enabled", model.Enabled), new SqlParameter("@StopOnError", model.StopOnError), new SqlParameter("@LeasedByMachineName", model.LeasedByMachineName), new SqlParameter("@LeasedUntilUtc", model.LeasedUntilUtc), new SqlParameter("@LastStartUtc", model.LastStartUtc), new SqlParameter("@LastEndUtc", model.LastEndUtc), new SqlParameter("@LastSuccessUtc", model.LastSuccessUtc), new SqlParameter("@CreatedDate", model.CreatedDate), new SqlParameter("@CreatedUser", model.CreatedUser), new SqlParameter("@ScreenID", model.ScreenID), }); }