public void Update(HolidayEntity entity)
{
SqlConnection conn = null;
SqlCommand cmd = null;
try
{
conn = DALHelper.CreateSqlDbConnection();
cmd = new SqlCommand("usp_UpdateHolidayGroup", conn);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Title", entity.Title);
cmd.Parameters.AddWithValue("@HolidayGroupId", entity.HolidayGroupId);
cmd.Parameters.AddWithValue("@StartDate", entity.StartDate);
cmd.Parameters.AddWithValue("@EndDate", entity.EndDate);
cmd.Parameters.AddWithValue("@Description", entity.Description);
cmd.Parameters.AddWithValue("@Status", entity.Status);
cmd.ExecuteNonQuery();
}
catch (Exception)
{
throw;
}
finally
{
conn.Close();
cmd.Dispose();
conn.Dispose();
}
}
protected void AddPaymentTypeButton_Click(object sender, EventArgs e)
{
HolidayEntity entity = new HolidayEntity();
HolidayMapper mapper = new HolidayMapper();
entity.HolidayGroupId = Convert.ToInt32(Request.QueryString["HolidayGroupId"]);
DateTime dt;
if (DateTime.TryParseExact(StartDateTextBox.Text, "dd.MM.yyyy", null, System.Globalization.DateTimeStyles.None, out dt))
{
entity.StartDate = dt;
}
if (DateTime.TryParseExact(EndDateTextBox.Text, "dd.MM.yyyy", null, System.Globalization.DateTimeStyles.None, out dt))
{
entity.EndDate = dt;
}
entity.Title = HolidayTitleTextBox.Text;
entity.Status = StatusEnum.Active;
entity.Description = "";
mapper.Insert(entity);
HolidayTitleTextBox.Text = "";
StartDateTextBox.Text = "";
EndDateTextBox.Text = "";
LeaveTypeGridView.DataBind();
}
public void Insert(HolidayEntity entity)
{
SqlConnection conn = null;
SqlCommand cmd = null;
try
{
conn = DALHelper.CreateSqlDbConnection();
cmd = new SqlCommand("usp_InsertHoliday", conn);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Title", entity.Title);
cmd.Parameters.AddWithValue("@HolidayGroupId", entity.HolidayGroupId);
cmd.Parameters.AddWithValue("@StartDate", entity.StartDate);
cmd.Parameters.AddWithValue("@EndDate", entity.EndDate);
cmd.Parameters.AddWithValue("@Description", entity.Description);
entity.Id = Convert.ToInt32(cmd.ExecuteScalar());
}
catch (Exception)
{
throw;
}
finally
{
conn.Close();
cmd.Dispose();
conn.Dispose();
}
}
protected override EmptyResponseData ProcessRequest(DTO.Base.APIRequest <DeleteHolidayRP> pRequest)
{
var rd = new EmptyResponseData();
var para = pRequest.Parameters;
var loggingSessionInfo = new SessionManager().CurrentUserLoginInfo;
var HolidayBLL = new HolidayBLL(loggingSessionInfo);
try
{
//删除
HolidayEntity DeleteData = HolidayBLL.GetByID(para.HolidayId);
if (DeleteData == null)
{
throw new APIException("假日对象为NULL！")
{
ErrorCode = ERROR_CODES.INVALID_BUSINESS
};
}
//执行
HolidayBLL.Delete(DeleteData);
}
catch (APIException apiEx)
{
throw new APIException(apiEx.ErrorCode, apiEx.Message);
}
return(rd);
}
public ActionResult Save(HolidayEntity entity)
{
if (_iplHoliday.Detail(entity.HolidayDate) != null)
{
TempData["Err"] = "Ngày lễ này đã tồn tại.";
return(RedirectToAction("CreateAndEdit"));
}
if (entity.Id < 1)
{
_iplHoliday.Insert(entity);
}
return(RedirectToAction("Index"));
}
protected override EmptyResponseData ProcessRequest(DTO.Base.APIRequest <SetHolidayRP> pRequest)
{
var rd = new EmptyResponseData();
var para = pRequest.Parameters;
var loggingSessionInfo = new SessionManager().CurrentUserLoginInfo;
var HolidayBLL = new HolidayBLL(loggingSessionInfo);
try
{
if (!string.IsNullOrWhiteSpace(para.HolidayId))
{
//更新
HolidayEntity UpdateData = HolidayBLL.GetByID(para.HolidayId);
if (UpdateData == null)
{
throw new APIException("假日对象为NULL！")
{
ErrorCode = ERROR_CODES.INVALID_BUSINESS
};
}
UpdateData.HolidayName = para.HolidayName;
UpdateData.BeginDate = para.BeginDate;
UpdateData.EndDate = para.EndDate;
UpdateData.Desciption = para.Desciption;
//执行
HolidayBLL.Update(UpdateData);
}
else
{
//新增
HolidayEntity AddData = new HolidayEntity();
//AddData.HolidayId = System.Guid.NewGuid().ToString();
AddData.HolidayName = para.HolidayName;
AddData.BeginDate = para.BeginDate;
AddData.EndDate = para.EndDate;
AddData.Desciption = para.Desciption;
AddData.CustomerID = loggingSessionInfo.ClientID;
//执行
HolidayBLL.Create(AddData);
}
}
catch (APIException apiEx)
{
throw new APIException(apiEx.ErrorCode, apiEx.Message);
}
return(rd);
}
public ActionResult Create(HolidayModel model)
{
ViewBag.LeaveDuration = LeaveServices.GetAllLeaveDuration();
if (ModelState.IsValid)
{
DateTime StartDate;
DateTime EndDate;
HolidayEntity ob = new HolidayEntity();
if (model.StartDate == null)
{
TempData[HRMWeb.Helpers.AlertStyles.Warning] = "Please Input Start Date";
return(View(model));
}
if (model.EndDate == null)
{
TempData[HRMWeb.Helpers.AlertStyles.Warning] = "Please Input End Date";
return(View(model));
}
StartDate = model.StartDate;
EndDate = model.EndDate;
if (StartDate > EndDate)
{
TempData[HRMWeb.Helpers.AlertStyles.Warning] = "Start Date can not exceed End Date";
return(View(model));
}
ob.HolidayId = 0;
ob.HolidayName = model.HolidayName;
ob.LeaveDurationId = model.LeaveDurationId == 0 ? (int)LeaveServices.Leave_Duration.FullDay : model.LeaveDurationId;
ob.StartDate = model.StartDate;
ob.EndDate = model.EndDate;
ob.UpdatedBy = HRMHelper.CurrentUser.UserId;
ob.CreatedBy = HRMHelper.CurrentUser.UserId;
int x = HolidayServices.InsertUpdateHoliday(ob);
if (x > 0)
{
ob.HolidayId = x;
TempData[HRMWeb.Helpers.AlertStyles.Success] = "Holiday Saved Successfully";
model = new HolidayModel();
}
else
{
TempData[HRMWeb.Helpers.AlertStyles.Danger] = "Save Fails";
}
}
return(View(model));
}
public static int InsertUpdateHoliday(HolidayEntity ob)
{
try
{
int HolidayId = 0;
using (HRMEntities db = new HRMEntities())
{
System.Data.Entity.Core.Objects.ObjectParameter OutPut = new System.Data.Entity.Core.Objects.ObjectParameter("Output", typeof(int));
db.sp_InsertUpdateHolidays(ob.HolidayId, ob.HolidayName, ob.StartDate, ob.EndDate, ob.LeaveDurationId, ob.CreatedBy, ob.UpdatedBy, OutPut);
HolidayId = int.Parse(OutPut.Value.ToString());
}
return(HolidayId);
}
catch
{
throw;
}
}
//获取这天的配送类型
public void GetDeliveryType()
{
if (OriginalDeliveryType == 1)
{
//检查节假日
HolidayEntity hd = Holidays.Find(x => x.HolidayDate == StartTime.Date);
DeliveryType = hd == null ? 1 : hd.DeliveryType;
}
else if (OriginalDeliveryType == 2)
{
//检查节假日和星期日
DeliveryType = StartTime.DayOfWeek == DayOfWeek.Sunday ? 1 : 2;
//检查节假日
HolidayEntity hd = Holidays.Find(x => x.HolidayDate.Date == StartTime.Date);
if (hd != null)
{
DeliveryType = hd.DeliveryType;
}
}
}
public List <HolidayEntity> List(int HolidayGroupId)
{
SqlConnection conn = null;
SqlCommand cmd = null;
try
{
conn = DALHelper.CreateSqlDbConnection();
cmd = new SqlCommand("usp_ListHolidays", conn);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@HolidayGroupId", HolidayGroupId);
SqlDataReader rdr = cmd.ExecuteReader();
List <HolidayEntity> list = new List <HolidayEntity>();
while (rdr.Read())
{
HolidayEntity entity = new HolidayEntity();
entity.Id = Convert.ToInt32(rdr["Id"]);
entity.Title = Convert.ToString(rdr["Title"]);
entity.StartDate = Convert.ToDateTime(rdr["StartDate"]);
entity.EndDate = Convert.ToDateTime(rdr["EndDate"]);
list.Add(entity);
}
return(list);
}
catch (Exception)
{
throw;
}
finally
{
conn.Close();
cmd.Dispose();
conn.Dispose();
}
}
public ActionResult EditHoliday(int?Id)
{
ViewBag.LeaveDuration = LeaveServices.GetAllLeaveDuration();
int HolidayId = Id == null ? 0 : (int)Id;
HolidayEntity ob = HolidayServices.GetHolidayById(HolidayId);
HolidayModel model = new HolidayModel();
if (ob != null)
{
model.HolidayId = ob.HolidayId;
model.HolidayName = ob.HolidayName;
model.StartDate = ob.StartDate;
model.EndDate = ob.EndDate;
model.LeaveDurationId = ob.LeaveDurationId;
}
else
{
return(RedirectToAction("Index"));
}
return(View(model));
}
/// <summary>
/// 获取公历周末(未排除节假日和调休)
/// </summary>
/// <param name="year"></param>
/// <returns></returns>
public List <HolidayEntity> GetWeekDayList(string year)
{
List <HolidayEntity> result = new List <HolidayEntity>();
DateTime refferTime = new DateTime(Convert.ToInt32(year), 1, 1);
DateTime startTime = new DateTime(Convert.ToInt32(year), 1, 1);
DateTime endTime = new DateTime(Convert.ToInt32(year) + 1, 1, 1);
while (refferTime < endTime)
{
if (refferTime.DayOfWeek == DayOfWeek.Saturday)
{
HolidayEntity item = new HolidayEntity()
{
Name = "周末", Status = 1, Years = year, From = refferTime, To = refferTime.AddDays(1)
};
result.Add(item);
refferTime = refferTime.AddDays(7);
}
else if (refferTime.DayOfWeek == DayOfWeek.Sunday)
{
HolidayEntity item = new HolidayEntity()
{
Name = "周末", Status = 1, Years = year, From = refferTime, To = refferTime
};
result.Add(item);
refferTime = refferTime.AddDays(6);
}
else
{
while (refferTime.DayOfWeek != DayOfWeek.Saturday)
{
refferTime = refferTime.AddDays(1);
}
}
}
return(result);
}
/// <summary>
/// 更新
/// </summary>
/// <param name="pEntity">实体实例</param>
/// <param name="pTran">事务实例,可为null,如果为null,则不使用事务来更新</param>
public void Update(HolidayEntity pEntity, IDbTransaction pTran)
{
_currentDAO.Update(pEntity, pTran);
}
/// <summary>
/// 创建一个新实例
/// </summary>
/// <param name="pEntity">实体实例</param>
public void Create(HolidayEntity pEntity)
{
_currentDAO.Create(pEntity);
}
/// <summary>
/// 分页根据实体条件查询实体
/// </summary>
/// <param name="pQueryEntity">以实体形式传入的参数</param>
/// <param name="pOrderBys">排序组合</param>
/// <returns>符合条件的实体集</returns>
public PagedQueryResult <HolidayEntity> PagedQueryByEntity(HolidayEntity pQueryEntity, OrderBy[] pOrderBys, int pPageSize, int pCurrentPageIndex)
{
return(_currentDAO.PagedQueryByEntity(pQueryEntity, pOrderBys, pPageSize, pCurrentPageIndex));
}
/// <summary>
/// 根据实体条件查询实体
/// </summary>
/// <param name="pQueryEntity">以实体形式传入的参数</param>
/// <param name="pOrderBys">排序组合</param>
/// <returns>符合条件的实体集</returns>
public HolidayEntity[] QueryByEntity(HolidayEntity pQueryEntity, OrderBy[] pOrderBys)
{
return(_currentDAO.QueryByEntity(pQueryEntity, pOrderBys));
}
/// <summary>
/// 删除
/// </summary>
/// <param name="pEntity">实体实例</param>
/// <param name="pTran">事务实例,可为null,如果为null,则不使用事务来更新</param>
public void Delete(HolidayEntity pEntity, IDbTransaction pTran)
{
_currentDAO.Delete(pEntity, pTran);
}
/// <summary>
/// 删除
/// </summary>
/// <param name="pEntity"></param>
public void Delete(HolidayEntity pEntity)
{
_currentDAO.Delete(pEntity);
}
/// <summary>
/// 更新
/// </summary>
/// <param name="pEntity">实体实例</param>
public void Update(HolidayEntity pEntity)
{
_currentDAO.Update(pEntity);
}
public static int InsertUpdateHoliday(HolidayEntity ob)
{
return(HolidayProvider.InsertUpdateHoliday(ob));
}
public HolidayEventEntity(Holiday holiday)
{
OldValue = new HolidayEntity();
NewValue = new HolidayEntity();
Mapper.Map(holiday, OldValue);
}
