public List <DesignationDTO> Designation()
{
using (IDbSvc dbSvc = new DbSvc(_configSvc))
{
try
{
dbSvc.OpenConnection();
MySqlCommand command = new MySqlCommand();
command.CommandText = "select DesignationId,DesignationDescription from designation where Active=1";
command.Connection = dbSvc.GetConnection() as MySqlConnection;
_dtData = new DataTable();
MySqlDataAdapter msDa = new MySqlDataAdapter(command);
msDa.Fill(_dtData);
List <DesignationDTO> lstDesignation = new List <DesignationDTO>();
if (_dtData != null && _dtData.Rows.Count > 0)
{
DesignationDTO designationDTO = null;
foreach (DataRow dr in _dtData.Rows)
{
designationDTO = new DesignationDTO();
designationDTO.DesignationId = (int)dr["DesignationId"];
designationDTO.DesignationDescription = dr["DesignationDescription"].ToString();
lstDesignation.Add(designationDTO);
}
}
return(lstDesignation);
}
catch (Exception exp)
{
throw exp;
}
}
}
public ActionResult DesignationCreate(DesignationDTO data)
{
try
{
if (!ModelState.IsValid)
{
return(View(data));
}
DesignationDTO resDesgDTO = new DesignationDTO();
resDesgDTO = _designationServices.InsertDesignation(data);
ViewBag.designationList = _designationServices.GetDesignationList();
ViewBag.levelList = _levelService.GetLevellist();
List <SelectListItem> GradeList = new List <SelectListItem>();
ViewBag.gradeList = GradeList;
ViewBag.success = String.Format("The designation with code {0} has been inserted.", resDesgDTO.DesgCode);
ModelState.Clear();
return(View());
}
catch (Exception Ex)
{
ViewBag.error = Ex.Message;
return(View());
}
}
public int UpdateDesignation(DesignationDTO data)
{
Designation desg = DesignationRequestFormatter.ConvertRespondentInfoFromDTO(data);
var response = _unitOfWork.DesignationRepository.Update(desg);
_unitOfWork.Save();
return(response);
}
public ActionResult DesignationEdit(int DesgId)
{
ViewBag.designationList = _designationServices.GetDesignationList();
ViewBag.levelList = _levelService.GetLevellist();
DesignationDTO DesignationListById = _designationServices.GetDesignationById(DesgId);
return(View(DesignationListById));
}
public SelectList getDesignationDropDown()
{
List <DesignationDTO> rDto = _ddlRepo.Designation();
DesignationDTO dDesg = new DesignationDTO();
dDesg.DesignationId = -1;
dDesg.DesignationDescription = "";
rDto.Insert(0, dDesg);
return(new SelectList(rDto, "DesignationId", "DesignationDescription"));
}
public ActionResult DesignationEdit(DesignationDTO data)
{
ViewBag.designationList = _designationServices.GetDesignationList();
ViewBag.levelList = _levelService.GetLevellist();
int reDesg = _designationServices.UpdateDesignation(data);
ViewBag.Success = "Designation updated successfully";
ModelState.Clear();
return(View(data));
}
public ActionResult Edit(DesignationDTO objDesignationMasterDTO)
{
objDesignationMasterDTO.ModifiedBy = Convert.ToInt32(Session["UserID"]);
DateTime timeUtc = System.DateTime.UtcNow;
TimeZoneInfo cstZone = TimeZoneInfo.FindSystemTimeZoneById("India Standard Time");
DateTime cstTime = TimeZoneInfo.ConvertTimeFromUtc(timeUtc, cstZone);
objDesignationMasterDTO.ModifiedDate = cstTime;
objIDesignationMaster.UpdateDesignation(objDesignationMasterDTO);
TempData["MessageUpdate"] = "Designation Updated Successfully.";
return(RedirectToAction("Details"));
}
public ActionResult DesignationCreateClose(DesignationDTO data)
{
try
{
DesignationDTO resDeptDTO = new DesignationDTO();
resDeptDTO = _designationServices.InsertDesignation(data);
ViewBag.Success = "New Designation created successfully";
ModelState.Clear();
return(View("Designations", _designationServices.GetDesignationList()));
}
catch (Exception Ex)
{
ViewBag.error = Ex.Message;
return(View(data));
}
}
public void InsertDesignation(DesignationDTO desgnation)
{
con.Open();
var para = new DynamicParameters();
para.Add("@DesignationId", desgnation.DesignationId); // Normal Parameters
para.Add("@Designation", desgnation.Designation);
para.Add("@CreatedDate", desgnation.CreatedDate);
para.Add("@CreatedBy", desgnation.CreatedBy);
para.Add("@ModifiedDate", desgnation.ModifiedDate);
para.Add("@ModifiedBy", desgnation.ModifiedBy);
para.Add("@DeleteStatus", "ACTIVE");
var value = con.Query <int>("SP_Insert_Update_DesignationMaster", para, null, true, 0, CommandType.StoredProcedure);
con.Close();
}
public void UpdateDesignation(DesignationDTO desgnation)
{
using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["Mystring"].ToString()))
{
con.Open();
var para = new DynamicParameters();
para.Add("@DesignationId", desgnation.DesignationId); // Normal Parameters
para.Add("@Designation", desgnation.Designation);
para.Add("@CreatedDate", desgnation.CreatedDate);
para.Add("@CreatedBy", desgnation.CreatedBy);
para.Add("@ModifiedDate", desgnation.ModifiedDate);
para.Add("@ModifiedBy", desgnation.ModifiedBy);
para.Add("@DeleteStatus", "ACTIVE");
var value = con.Query <int>("SP_Insert_Update_DesignationMaster", para, null, true, 0, CommandType.StoredProcedure);
con.Close();
}
}
public DesignationDTO InsertDesignation(DesignationDTO data)
{
Designation desg = DesignationRequestFormatter.ConvertRespondentInfoFromDTO(data);
_desg.LeaveApprove = desg.LeaveApprove;
_desg.DesgCode = desg.DesgCode;
_desg.DesgLevelId = desg.DesgLevelId;
_desg.DesgMaxPeriodDays = desg.DesgMaxPeriodDays;
_desg.DesgOrder = desg.DesgOrder;
_desg.LeaveRecommendation = desg.LeaveRecommendation;
_desg.AttendanceApprove = desg.AttendanceApprove;
_desg.AttendanceRecommendation = desg.AttendanceRecommendation;
_desg.DesgShortCode = desg.DesgShortCode;
_desg.DsgId = desg.DsgId;
_desg.DsgName = desg.DsgName;
_desg.DsgParentId = desg.DsgParentId;
return(DesignationRequestFormatter.ConvertRespondentInfoToDTO(_unitOfWork.DesignationRepository.Create(desg)));
}
public DesignationDTO GetDesignationById(int desgId)
{
var designationList = _unitOfWork.DesignationRepository.All();
DesignationDTO list = (from desg in designationList
select new DesignationDTO {
LeaveApprove = desg.LeaveApprove,
DesgCode = desg.DesgCode,
DesgLevelId = desg.DesgLevelId,
DesgMaxPeriodDays = desg.DesgMaxPeriodDays,
DesgOrder = desg.DesgOrder,
LeaveRecommendation = desg.LeaveRecommendation,
AttendanceApprove = desg.AttendanceApprove,
AttendanceRecommendation = desg.AttendanceRecommendation,
DesgShortCode = desg.DesgShortCode,
DsgId = desg.DsgId,
DsgName = desg.DsgName,
DsgParentId = desg.DsgParentId
}).Where(x => x.DsgId == desgId).FirstOrDefault();
return(list);
}
public Result Save(DesignationDTO obj)
{
try
{
using (DbCommand cmd = Common.dbConn.GetStoredProcCommand("MSTDesigSave"))
{
Common.dbConn.AddInParameter(cmd, "Id", DbType.Int32, obj.Id);
Common.dbConn.AddInParameter(cmd, "Designation", DbType.String, obj.Designation);
Common.dbConn.ExecuteNonQuery(cmd);
return(new Result {
Id = 1, Message = "Saved", ResultStatus = OperationStatus.SavedSuccessFully
});
}
}
catch (Exception exception)
{
throw exception;
}
return(null);
}
public ActionResult Create(DesignationDTO objDesignationMasterDTO)
{
if (ModelState.IsValid)
{
objDesignationMasterDTO.CreatedBy = Convert.ToInt32(Session["UserID"]);
DateTime timeUtc = System.DateTime.UtcNow;
TimeZoneInfo cstZone = TimeZoneInfo.FindSystemTimeZoneById("India Standard Time");
DateTime cstTime = TimeZoneInfo.ConvertTimeFromUtc(timeUtc, cstZone);
objDesignationMasterDTO.CreatedDate = cstTime;
objIDesignationMaster.InsertDesignation(objDesignationMasterDTO);
TempData["MessageRegistration"] = "Data Saved Successfully!";
return(RedirectToAction("Create"));
}
else
{
// TempData["MessageRegistration"] = "Please enter Division Name!";
ModelState.AddModelError("", "Please enter Designation Name ");
}
// ModelState.Remove("DivisionName");
return(View(objDesignationMasterDTO));
}
public static Designation ConvertRespondentInfoFromDTO(DesignationDTO desg)
{
AutoMapper.Mapper.CreateMap <DesignationDTO, Designation>().ConvertUsing(
m =>
{
return(new Designation
{
DesgCode = m.DesgCode,
DsgName = m.DsgName,
DsgId = m.DsgId,
DsgParentId = m.DsgParentId,
DesgLevelId = m.DesgLevelId,
DesgMaxPeriodDays = m.DesgMaxPeriodDays,
DesgOrder = m.DesgOrder,
LeaveApprove = m.LeaveApprove,
LeaveRecommendation = m.LeaveRecommendation,
AttendanceApprove = m.AttendanceApprove,
AttendanceRecommendation = m.AttendanceRecommendation,
DesgShortCode = m.DesgShortCode
});
});
return(AutoMapper.Mapper.Map <DesignationDTO, Designation>(desg));
}
public Result Save(ERPDTOBase obj)
{
DesignationDTO accountGroup = obj as DesignationDTO;
return(new DesignationDAL().Save(accountGroup));
}
