/// <summary> /// /// </summary> /// <param name="workingPeriod"></param> /// <returns></returns> public bool DeleteWorkingPeriod(Entities.WorkingPeriod workingPeriod) { bool isDeleted = false; DbCommand dbCommand = null; try { using (dbCommand = database.GetStoredProcCommand(DBStoredProcedure.DeleteWorkingPeriod)) { database.AddInParameter(dbCommand, "@working_period_id", DbType.Int32, workingPeriod.WorkingPeriodId); database.AddInParameter(dbCommand, "@deleted_by", DbType.Int32, workingPeriod.DeletedBy); database.AddInParameter(dbCommand, "@deleted_by_ip", DbType.String, workingPeriod.DeletedByIP); database.AddOutParameter(dbCommand, "@return_value", DbType.Int32, 0); var result = database.ExecuteNonQuery(dbCommand); if (database.GetParameterValue(dbCommand, "@return_value") != DBNull.Value) { isDeleted = Convert.ToBoolean(database.GetParameterValue(dbCommand, "@return_value")); } } } catch (Exception e) { throw e; } finally { dbCommand = null; } return(isDeleted); }
public Int32 SaveWorkingPeriod(Entities.WorkingPeriod workingPeriod) { var workingPeriodId = 0; if (workingPeriod.WorkingPeriodId == null || workingPeriod.WorkingPeriodId == 0) { workingPeriodId = AddWorkingPeriod(workingPeriod); } else if (workingPeriod.ModifiedBy > 0) { workingPeriodId = UpdateWorkingPeriod(workingPeriod); } else if (workingPeriod.IsDeleted == true) { var result = DeleteWorkingPeriod(workingPeriod); } return(workingPeriodId); }
/// <summary> /// /// </summary> /// <returns></returns> public List <Entities.WorkingPeriod> GetAllWorkingPeriods() { var workingPeriods = new List <Entities.WorkingPeriod>(); DbCommand dbCommand = null; try { using (dbCommand = database.GetStoredProcCommand(DBStoredProcedure.GetAllWorkingPeriods)) { using (IDataReader reader = database.ExecuteReader(dbCommand)) { while (reader.Read()) { var workingPeriod = new Entities.WorkingPeriod { WorkingPeriodId = DRE.GetNullableInt32(reader, "working_period_id", 0), StartDate = DRE.GetNullableString(reader, "start_date", null), EndDate = DRE.GetNullableString(reader, "end_date", null), FinancialYear = DRE.GetNullableString(reader, "financial_year", null), SrNo = DRE.GetNullableInt64(reader, "sr_no", null) }; workingPeriods.Add(workingPeriod); } } } } catch (Exception ex) { throw ex; } finally { dbCommand = null; } return(workingPeriods); }
/// <summary> /// /// </summary> /// <param name="workingPeriod"></param> /// <returns></returns> private Int32 AddWorkingPeriod(Entities.WorkingPeriod workingPeriod) { var workingPeriodId = 0; DbCommand dbCommand = null; try { using (dbCommand = database.GetStoredProcCommand(DBStoredProcedure.InsertWorkingPeriod)) { database.AddInParameter(dbCommand, "@working_period_id", DbType.Int32, workingPeriod.WorkingPeriodId); database.AddInParameter(dbCommand, "@start_date", DbType.String, workingPeriod.StartDate); database.AddInParameter(dbCommand, "@end_date", DbType.String, workingPeriod.EndDate); database.AddInParameter(dbCommand, "@financial_year", DbType.String, workingPeriod.FinancialYear); database.AddInParameter(dbCommand, "@created_by", DbType.Int32, workingPeriod.CreatedBy); database.AddInParameter(dbCommand, "@created_by_ip", DbType.String, workingPeriod.CreatedByIP); database.AddOutParameter(dbCommand, "@return_value", DbType.Int32, 0); workingPeriodId = database.ExecuteNonQuery(dbCommand); if (database.GetParameterValue(dbCommand, "@return_value") != DBNull.Value) { workingPeriodId = Convert.ToInt32(database.GetParameterValue(dbCommand, "@return_value")); } } } catch (Exception e) { throw e; } finally { dbCommand = null; } return(workingPeriodId); }
public bool DeleteWorkingPeriod(Entities.WorkingPeriod workingPeriod) { return(_workingPeriod.DeleteWorkingPeriod(workingPeriod)); }
public Int32 SaveWorkingPeriod(Entities.WorkingPeriod workingPeriod) { return(_workingPeriod.SaveWorkingPeriod(workingPeriod)); }