public IHttpActionResult PutHoliday(int id, tblHoliday holiday)
{
if (id != holiday.ID)
{
return(BadRequest());
}
db.Entry(holiday).State = EntityState.Modified;
holiday.HOLIDAY_DAY = holiday.HOLIDAY_DATE.DayOfWeek.ToString();
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!HolidayExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
/// <summary>
/// Create a new tblHoliday object.
/// </summary>
/// <param name="id">Initial value of ID.</param>
/// <param name="date">Initial value of Date.</param>
public static tblHoliday CreatetblHoliday(int id, global::System.DateTime date)
{
tblHoliday tblHoliday = new tblHoliday();
tblHoliday.ID = id;
tblHoliday.Date = date;
return(tblHoliday);
}
public IHttpActionResult PostHolidays(tblHoliday holiday)
{
holiday.HOLIDAY_DAY = holiday.HOLIDAY_DATE.DayOfWeek.ToString();
db.tblHolidays.Add(holiday);
db.SaveChanges();
return(CreatedAtRoute("DefaultApi", new { id = holiday.ID }, holiday));
}
public SavingResult SaveNewRecord(tblHoliday SaveModel)
{
SavingResult res = new SavingResult();
//-- Perform Validation
//res.ExecutionResult = eExecutionResult.ValidationError;
//res.ValidationError = "Validation error message";
//return res;
//--
using (dbVisionEntities db = new dbVisionEntities())
{
//tblHoliday SaveModel;
if (SaveModel.HolidayName == "")
{
res.ValidationError = "Can not accept blank value. Please enter Holiday Name.";
res.ExecutionResult = eExecutionResult.ValidationError;
return(res);
}
else if (IsDuplicateRecord(SaveModel.HolidayName, SaveModel.HolidayID, db))
{
res.ValidationError = "Can not accept duplicate value. The Holiday Name is already exists.";
res.ExecutionResult = eExecutionResult.ValidationError;
return(res);
}
if (SaveModel.HolidayID == 0) // New Entry
{
SaveModel.rcuid = Model.CommonProperties.LoginInfo.LoggedinUser.UserID;
SaveModel.rcdt = DateTime.Now;
SaveModel.CompanyID = Model.CommonProperties.LoginInfo.LoggedInCompany.CompanyID;
db.tblHolidays.Add(SaveModel);
}
else
{
SaveModel.reuid = Model.CommonProperties.LoginInfo.LoggedinUser.UserID;
SaveModel.redt = DateTime.Now;
db.tblHolidays.Attach(SaveModel);
db.Entry(SaveModel).State = System.Data.Entity.EntityState.Modified;
}
//--
try
{
db.SaveChanges();
res.PrimeKeyValue = SaveModel.HolidayID;
res.ExecutionResult = eExecutionResult.CommitedSucessfuly;
}
catch (Exception ex)
{
CommonFunctions.GetFinalError(res, ex);
}
}
return(res);
}
public IHttpActionResult DeleteHoliday(int id)
{
tblHoliday objHoliday = db.tblHolidays.Find(id);
if (objHoliday == null)
{
return(NotFound());
}
db.tblHolidays.Remove(objHoliday);
db.SaveChanges();
return(Ok(objHoliday));
}
public override void FillSelectedRecordInContent(object RecordToFill)
{
tblHoliday SaveModel = DALObject.FindSaveModelByPrimeKey(((HolidayEditListModel)RecordToFill).HolidayID);
if (SaveModel == null)
{
return;
}
txtHolidayName.Text = SaveModel.HolidayName;
cmbHolidayType.SelectedIndex = SaveModel.HolidayType;
cmbRepeatOnSameDate.SelectedIndex = SaveModel.RepeatOnSameDate ? 1 : 0;
deDateFrom.DateTime = SaveModel.FromDate;
deDateTo.DateTime = SaveModel.ToDate;
txtNofDays.EditValue = SaveModel.TotalDays;
txtRemarks.Text = SaveModel.Remarks;
}
public SavingResult DeleteRecord(long DeleteID)
{
SavingResult res = new SavingResult();
using (dbVisionEntities db = new dbVisionEntities())
{
if (DeleteID != 0)
{
tblHoliday RecordToDelete = db.tblHolidays.FirstOrDefault(r => r.HolidayID == DeleteID);
if (RecordToDelete == null)
{
res.ValidationError = "Selected record not found. May be it has been deleted by another user over network.";
res.ExecutionResult = eExecutionResult.ValidationError;
return(res);
}
else
{
//db.tblHolidays.Remove(RecordToDelete);
byte RecordState_Deleted = (byte)eRecordState.Deleted;
RecordToDelete.rstate = RecordState_Deleted;
db.tblHolidays.Attach(RecordToDelete);
db.Entry(RecordToDelete).State = System.Data.Entity.EntityState.Modified;
}
try
{
db.SaveChanges();
res.ExecutionResult = eExecutionResult.CommitedSucessfuly;
}
catch (Exception ex)
{
CommonFunctions.GetFinalError(res, ex);
}
}
}
return(res);
}
/// <summary>
/// For HolidayList Bind
/// </summary>
/// <returns></returns>
public List <tblHoliday> GetHolidayList(string Empid)
{
try
{
DALBase obj = new DALBase(_config);
List <tblHoliday> listObj = new List <tblHoliday>();
DataSet ds = obj.GetHolidaylist(ConstantStoredProcedure.SP_BCL_HOLIDAYLIST, Empid);
if (ds != null && ds.Tables.Count > 0)
{
for (int i = 0; i < ds.Tables.Count; i++)
{
if (ds.Tables[i] != null && ds.Tables[i].Rows.Count > 0)
{
foreach (DataRow dtRow in ds.Tables[i].Rows)
{
var date = dtRow["FROMDATE"].ToString();
var Descr = dtRow["TODATE"].ToString();
var Descr1 = dtRow["DESCRIPTION"].ToString();
var Descr2 = dtRow["Status"].ToString();
var objLeave = new tblHoliday();
objLeave.HolidayDate = Convert.ToDateTime(date).ToString("yyyy/MM/dd").Replace('-', '/');
objLeave.HolidayName = Convert.ToDateTime(Descr).ToString("yyyy/MM/dd").Replace('-', '/');
objLeave.Text = Descr1;
objLeave.Text1 = Descr2;
listObj.Add(objLeave);
}
}
}
}
return(listObj);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// There are no comments for tblHolidays in the schema.
/// </summary>
public void AddTotblHolidays(tblHoliday tblHoliday)
{
base.AddObject("tblHolidays", tblHoliday);
}
/// <summary>
/// Create a new tblHoliday object.
/// </summary>
/// <param name="id">Initial value of ID.</param>
/// <param name="date">Initial value of Date.</param>
public static tblHoliday CreatetblHoliday(int id, global::System.DateTime date)
{
tblHoliday tblHoliday = new tblHoliday();
tblHoliday.ID = id;
tblHoliday.Date = date;
return tblHoliday;
}
/// <summary>
/// There are no comments for tblHolidays in the schema.
/// </summary>
public void AddTotblHolidays(tblHoliday tblHoliday)
{
base.AddObject("tblHolidays", tblHoliday);
}
