public string CreateLeaveType(LeaveTypeEntity LeaveTypeDtl)
{
string strResponse = string.Empty;
try
{
var LeaveTypeComponent = new LeaveTypeComponent();
UserSessionInfo _objSessioninfo = Session["UserSessionInfo"] as UserSessionInfo;
int _userID = _objSessioninfo.UserId;
LeaveTypeDtl.LTyp_CreatedBy = _userID;
var Org = new LeaveTypeComponent();
int r = Org.AddLeaveType(LeaveTypeDtl);
if (r > 0)
{
strResponse = "Leave created successfully";
}
else if (r == 0)
{
strResponse = "Leave already exists";
}
else if (r < 0)
{
strResponse = "Error occured in CreateLeaveType";
}
}
catch (Exception ex)
{
return(strResponse);
}
return(strResponse);
}
protected void Page_Load(object sender, EventArgs e)
{
//http://localhost:14994/HRM/HR-Managment/Definition/LeaveType/Edit.aspx?LeaveTypeNameId=3&action=delete&LeaveTypeId=15
if (Request.QueryString["LeaveTypeNameId"] != null && Request.QueryString["action"] == "delete")
{
new LeaveTypeLevelMapper().Delete(new Entities.LeaveTypeLevelEntity() { Id = Convert.ToInt32(Request.QueryString["LeaveTypeNameId"]) });
}
if (!IsPostBack)
{
GUIHelper.BindEnum2DropDownList(TypeDropDownList, typeof(LeaveNameType), true);
if (Request.QueryString["LeaveTypeId"] != null)
{
int LeaveTypeId;
LeaveTypeEntity entity = new LeaveTypeEntity();
Int32.TryParse(Request.QueryString["LeaveTypeId"], out LeaveTypeId);
entity.Id = LeaveTypeId;
LeaveTypeMapper mapper = new LeaveTypeMapper();
entity = mapper.Get(entity);
TitleTextBox.Text = entity.Title;
DescriptionTextBox.Text = entity.Description;
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
//http://localhost:14994/HRM/HR-Managment/Definition/LeaveType/Edit.aspx?LeaveTypeNameId=3&action=delete&LeaveTypeId=15
if (Request.QueryString["LeaveTypeNameId"] != null && Request.QueryString["action"] == "delete")
{
new LeaveTypeLevelMapper().Delete(new Entities.LeaveTypeLevelEntity()
{
Id = Convert.ToInt32(Request.QueryString["LeaveTypeNameId"])
});
}
if (!IsPostBack)
{
GUIHelper.BindEnum2DropDownList(TypeDropDownList, typeof(LeaveNameType), true);
if (Request.QueryString["LeaveTypeId"] != null)
{
int LeaveTypeId;
LeaveTypeEntity entity = new LeaveTypeEntity();
Int32.TryParse(Request.QueryString["LeaveTypeId"], out LeaveTypeId);
entity.Id = LeaveTypeId;
LeaveTypeMapper mapper = new LeaveTypeMapper();
entity = mapper.Get(entity);
TitleTextBox.Text = entity.Title;
DescriptionTextBox.Text = entity.Description;
}
}
}
protected void AddLeaveType_Click(object sender, EventArgs e)
{
LeaveTypeEntity entity = new LeaveTypeEntity();
entity.Title = TitleTextBox.Text;
entity.Description = DescriptionTextBox.Text;
LeaveTypeMapper mapper = new LeaveTypeMapper();
mapper.Insert(entity);
Response.Redirect(String.Format("Edit.aspx?LeavetypeId={0}", entity.Id));
}
public string UpdateLeaveType(LeaveTypeEntity LeaveTypeDtl)
{
string strResponse = string.Empty;
short UsTCurrentVersion = 0;
try
{
var LeaveTypeComponent = new LeaveTypeComponent();
var currentLeaveTypeDetails = LeaveTypeComponent.GetLeaveTypeDetailByID(LeaveTypeDtl.LTyp_LeaveTypeID);
int LeaveTypeID = currentLeaveTypeDetails.LTyp_LeaveTypeID;
UsTCurrentVersion = Convert.ToInt16(currentLeaveTypeDetails.LTyp_Version);
bool _currentStatus = false;
//check for version and active status
if (ModelState["LTyp_ActiveStatus"].Value != null)
{
_currentStatus = LeaveTypeDtl.LTyp_ActiveStatus == true;
}
if (ModelState.IsValid)
{
UserSessionInfo _objSessioninfo = Session["UserSessionInfo"] as UserSessionInfo;
int _userID = _objSessioninfo.UserId;
LeaveTypeDtl.LTyp_ModifiedBy = _userID;
//while udating increment version by1
LeaveTypeDtl.LTyp_Version = ++UsTCurrentVersion;
LeaveTypeDtl.LTyp_ActiveStatus = _currentStatus;
var Org = new LeaveTypeComponent();
int r = Org.UpdateLeaveTypeDetail(LeaveTypeDtl);
if (r > 0)
{
strResponse = "Leave updated successfully";
}
else if (r == 0)
{
strResponse = "Leave does not exists";
}
else if (r < 0)
{
strResponse = "Error occured in UpdateLeaveType";
}
}
}
catch (Exception ex)
{
return(strResponse);
}
return(strResponse);
}
protected void AddLeaveType_Click(object sender, EventArgs e)
{
LeaveTypeEntity entity = new LeaveTypeEntity();
entity.Title = TitleTextBox.Text;
entity.Description = DescriptionTextBox.Text;
LeaveTypeMapper mapper = new LeaveTypeMapper();
mapper.Insert(entity);
Response.Redirect(String.Format("Edit.aspx?LeavetypeId={0}", entity.Id));
}
public JsonResult GetLeaveTypeByID(int catID)
{
LeaveTypeEntity LeaveTypeDetails = null;
try
{
var objDtl = new LeaveTypeComponent();
LeaveTypeDetails = objDtl.GetLeaveTypeDetailByID(catID);
}
catch (Exception ex)
{
return(null);
}
return(Json(LeaveTypeDetails, JsonRequestBehavior.AllowGet));
}
public string CrudOperation(FormCollection formCollection)
{
string strResponse = string.Empty;
try
{
var strOperation = formCollection["oper"];
if (strOperation == "add")
{
LeaveTypeEntity updateList = new LeaveTypeEntity
{
LTyp_AccountID = Convert.ToInt32(formCollection.Get("LTyp_AccountID")),
LTyp_LeaveType = formCollection.Get("LTyp_LeaveType"),
LTyp_LeaveTypeDescription = formCollection.Get("LTyp_LeaveTypeDescription"),
LTyp_Version = 1,
LTyp_ActiveStatus = Convert.ToBoolean(formCollection.Get("LTyp_ActiveStatus")),
LTyp_isDeleted = false
};
strResponse = CreateLeaveType(updateList);
}
else if (strOperation == "edit")
{
LeaveTypeEntity updateList = new LeaveTypeEntity
{
LTyp_LeaveTypeID = Convert.ToInt32(formCollection.Get("id")),
LTyp_AccountID = Convert.ToInt32(formCollection.Get("LTyp_AccountID")),
LTyp_LeaveType = formCollection.Get("LTyp_LeaveType"),
LTyp_LeaveTypeDescription = formCollection.Get("LTyp_LeaveTypeDescription"),
LTyp_ActiveStatus = Convert.ToBoolean(formCollection.Get("LTyp_ActiveStatus")),
LTyp_isDeleted = Convert.ToBoolean(formCollection.Get("LTyp_isDeleted"))
};
strResponse = UpdateLeaveType(updateList);
}
else if (strOperation == "del")
{
int LeaveTypeID = Convert.ToInt32(formCollection.Get("id"));
strResponse = DeleteLeaveType(LeaveTypeID);
}
}
catch (Exception ex)
{
return(strResponse);
}
return(strResponse);
}
public int UpdateLeaveTypeDetail(LeaveTypeEntity _LeaveType)
{
var LeaveTypeDAC = new LeaveTypeDAC();
return(LeaveTypeDAC.UpdateLeaveTypeDetail(_LeaveType));
}
public int AddLeaveType(LeaveTypeEntity _LeaveType)
{
var LeaveTypeDAC = new LeaveTypeDAC();
return(LeaveTypeDAC.AddLeaveType(_LeaveType));
}
public List<string> Edit(LeaveTypeEntity leaveType)
{
DbContext.Entry(leaveType).State = EntityState.Modified;
return DbContext.Commit();
}
public List<string> Add(LeaveTypeEntity leaveType)
{
DbContext.LeaveTypeRepository.Add(leaveType);
return DbContext.Commit();
}
public List<string> Remove(LeaveTypeEntity leave_Type, bool notPurging = true)
{
LeaveTypeEntity leaveType = DbContext.LeaveTypeRepository.GetAll().FirstOrDefault(u => u.LeaveTypeId == leave_Type.LeaveTypeId);
var errors = new List<string>();
if (leaveType != null)
{
if (notPurging)
{
leaveType.RecordState.RecordStateType = RecordStateType.Inactive;
leaveType.RecordState.ModfiedByUserId = leaveType.RecordState.ModfiedByUserId;
DbContext.Entry(leaveType).State = EntityState.Modified;
}
else
DbContext.Entry(leaveType).State = EntityState.Deleted;
}
else
{
errors.Add("Custom : No such leave type mateches the id");
}
return errors;
}
