public HolidayList Holiday(int scode)
{
HolidayList Detail = new HolidayList();
Holiday holiday = new Holiday();
using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["con"].ConnectionString))
{
using (SqlCommand cmd = new SqlCommand("usp_api_holidaylist_mobile", con))
{
con.Open();
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@studentcode", SqlDbType.Int).Value = scode;
SqlDataAdapter sda = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
sda.Fill(dt);
if (dt.Rows.Count > 0)
{
foreach (DataRow dtrow in dt.Rows)
{
holiday.HolidayLink = Convert.ToString(dtrow["HolidayLink"]);
}
Detail.Holidays = holiday;
}
else
{
throw new HttpResponseException(HttpStatusCode.NoContent);
}
}
return(Detail);
}
}
public void Add(HolidayList holidayList)
{
try
{
holidayList.CreatedBy = sessionObj.USERID;
holidayList.CreatedOn = UTILITY.SINGAPORETIME;
if (sessionObj.BRANCHID != -1)
{
holidayList.BranchID = sessionObj.BRANCHID;
}
holidayListRepository.Add(holidayList);
//if (holidayList.HolidayId != -1)
//{
//}
//else
//{
// holidayList.ModifiedBy = sessionObj.USERID;
// holidayList.ModifiedOn = UTILITY.SINGAPORETIME;
// holidayListRepository.Add(holidayList);
//}
}
catch (Exception ex)
{
throw ex;
}
}
protected void DeleteMethod(object obj)
{
try
{
if (MessageBox.Show("You are going to Delete this Holiday.Do you want to proceed?", "Alert", MessageBoxButton.YesNo, MessageBoxImage.Warning) == MessageBoxResult.No)
{
return;
}
using (SqlConnection conn = new SqlConnection(GlobalClass.TConnectionString))
{
conn.Open();
using (SqlTransaction tran = conn.BeginTransaction())
{
Holiday.Delete(tran);
tran.Commit();
}
}
HolidayList.Remove(HolidayList.First(x => x.HolidayId == Holiday.HolidayId));
MessageBox.Show("Holiday Successfully Deleted.", MessageBoxCaption, MessageBoxButton.OK, MessageBoxImage.Information);
UndoMethod(null);
}
catch (Exception ex)
{
while (ex.InnerException != null)
{
ex = ex.InnerException;
}
MessageBox.Show(ex.Message, MessageBoxCaption, MessageBoxButton.OK, MessageBoxImage.Error);
}
}
public void Remove(HolidayList holidayList)
{
if (holidayList.Id > 0)
{
HolidayRepository.Remove(holidayList);
}
}
public void Save(HolidayList holidayList)
{
if (holidayList.Id == 0)
{
HolidayRepository.Insert(holidayList);
}
else
{
HolidayRepository.Update(holidayList);
}
}
public void HolidayListRemoveTest()
{
HolidayList list = new HolidayList();
MockDayOfYearHoliday holiday = new MockDayOfYearHoliday($"2/1");
list.Add(holiday);
list.Remove(holiday);
Assert.Multiple(() =>
{
Assert.AreEqual(0, list.Count());
});
}
public void SaveHolidayList(HolidayList holidayList, bool autoCommit = true)
{
if (holidayList.Id == 0)
{
HolidayListRepository.Insert(holidayList);
}
else
{
HolidayListRepository.Update(holidayList);
}
if (autoCommit)
{
HolidayListRepository.Commit();
}
}
public void HolidayListAddRangeTest()
{
HolidayList list = new HolidayList();
MockDayOfYearHoliday holiday1 = new MockDayOfYearHoliday($"2/1");
MockDayOfYearHoliday holiday2 = new MockDayOfYearHoliday($"3/1");
MockDayOfYearHoliday holiday3 = new MockDayOfYearHoliday($"4/1");
MockDayOfYearHoliday holiday4 = new MockDayOfYearHoliday($"5/1");
list.AddRange(new IHoliday[] { holiday1, holiday2, holiday3, holiday4 });
Assert.Multiple(() =>
{
Assert.AreEqual(4, list.Count());
Assert.AreEqual(holiday1, list.First());
Assert.AreEqual(holiday4, list.Last());
});
}
public ActionResult CreateHolidayList(HolidayList objholidaylist)
{
try
{
cHolidayList objholiday = cHolidayList.Create();
objholiday.sOccassion = objholidaylist.Occassion;
objholiday.dtOccDate = Convert.ToDateTime(objholidaylist.Date);
objholiday.sDescription = objholidaylist.Description;
objholiday.Save();
Session["Result"] = "1";
LeaveViewModel objleaveviewmodel = new LeaveViewModel();
return(RedirectToAction("HolidayList"));
}
catch (Exception ex)
{
throw ex;
}
}
public int?AddHoliday(HolidayList holiday)
{
try
{
int?result = -1;
if (holiday != null)
{
holiday.CreatedDate = DateTime.Now;
_context.HolidayList.Add(holiday);
_context.SaveChanges();
result = holiday.HolidayId;
}
return(result);
}
catch (Exception)
{
throw;
}
}
private void Save(object obj)
{
try
{
if (MessageBox.Show("You are going to Save this Holiday.Do you want to proceed?", MessageBoxCaption, MessageBoxButton.YesNo, MessageBoxImage.Question) == MessageBoxResult.No)
{
return;
}
using (SqlConnection conn = new SqlConnection(GlobalClass.TConnectionString))
{
conn.Open();
using (SqlTransaction tran = conn.BeginTransaction())
{
do
{
Holiday.HolidayId = conn.ExecuteScalar <int>("SELECT ISNULL(MAX(HolidayId), 0) + 1 FROM Holiday ", transaction: tran);
Holiday.HolidayDate = FDate;
Holiday.Save(tran);
FDate = FDate.AddDays(1);
}while (FDate <= TDate);
tran.Commit();
}
}
HolidayList.Add(new Holiday
{
HolidayId = Holiday.HolidayId,
HolidayName = Holiday.HolidayName,
HolidayDate = Holiday.HolidayDate
});
MessageBox.Show("Holiday successfully saved.", MessageBoxCaption, MessageBoxButton.OK, MessageBoxImage.Information);
UndoMethod(null);
}
catch (Exception ex)
{
while (ex.InnerException != null)
{
ex = ex.InnerException;
}
MessageBox.Show(ex.Message, MessageBoxCaption, MessageBoxButton.OK, MessageBoxImage.Error);
}
}
public JsonResult SaveHolidayLists(HolidayListViewModel holidayListViewModel)
{
JsonResult result = null;
//HolidayListViewModel holidayListViewModel = new HolidayListViewModel();
try
{
Branch branch = holidayListViewModel.BranchID > 0 ? MasterService.GetBranch(holidayListViewModel.BranchID) : null;
if (holidayListViewModel != null)
{
HolidayList holidayList = new HolidayList();
if (holidayListViewModel.Id == 0)
{
holidayList.CreatedBy = "Admin";
holidayList.CreatedOn = DateTimeConverter.SingaporeDateTimeConversion(DateTime.Now);
}
else
{
holidayList.ModifiedBy = "Admin";
holidayList.ModifiedOn = DateTimeConverter.SingaporeDateTimeConversion(DateTime.Now);
}
holidayList.Date = DateTimeConverter.SingaporeDateTimeConversion(DateTime.ParseExact(holidayListViewModel.Date, "dd/MM/yyyy", CultureInfo.InvariantCulture));
holidayList.Description = !string.IsNullOrWhiteSpace(holidayListViewModel.Description) ? holidayListViewModel.Description : string.Empty;
holidayList.BranchID = branch != null ? branch.BranchID : 0;
if (holidayList != null)
{
MasterService.Save(holidayList);
}
}
}
catch (Exception ex)
{
if (ex.InnerException != null && !string.IsNullOrEmpty(ex.InnerException.Message))
{
return(Json(new { success = false, message = ex.InnerException.Message }, JsonRequestBehavior.AllowGet));
}
}
return(result);
}
public ActionResult SaveHolidayListData(HolidayList holidayList)
{
JsonResult result = new JsonResult();
if (holidayList != null)
{
try
{
HolidayList _holidayList = new HolidayList();
if (holidayList.Id > 0)
{
_holidayList = CompanyService.GetHolidayListById(holidayList.Id);
_holidayList.ModifiedBy = USER_OBJECT.UserID;
_holidayList.ModifiedOn = DateTimeConverter.SingaporeDateTimeConversion(DateTime.Now);
}
else
{
_holidayList.CreatedBy = USER_OBJECT.UserID;
_holidayList.CreatedOn = DateTimeConverter.SingaporeDateTimeConversion(DateTime.Now);
}
_holidayList.Date = DateTimeConverter.SingaporeDateTimeConversion(holidayList.Date);
_holidayList.Description = holidayList.Description;
_holidayList.CountryId = holidayList.CountryId;
_holidayList.BranchID = holidayList.BranchID;
CompanyService.SaveHolidayList(_holidayList);
result = Json(new { success = true, message = C.SUCCESSFUL_SAVE_MESSAGE }, JsonRequestBehavior.AllowGet);
}
catch (Exception ex)
{
if (ex.InnerException != null && !string.IsNullOrEmpty(ex.InnerException.Message))
{
return(Json(new { success = false, message = ex.InnerException.Message }, JsonRequestBehavior.AllowGet));
}
}
}
return(result);
}
internal DateTimeEstimator(IHostEnvironment env, string inputColumnName, string columnPrefix, HolidayList country = HolidayList.None)
{
Contracts.CheckValue(env, nameof(env));
_host = Contracts.CheckRef(env, nameof(env)).Register("DateTimeTransformerEstimator");
_host.CheckValue(inputColumnName, nameof(inputColumnName), "Input column should not be null.");
_host.Check(!CommonExtensions.OsIsCentOS7(), "CentOS7 is not supported");
_options = new Options
{
Source = inputColumnName,
Prefix = columnPrefix,
Country = country
};
}
