public async Task Update(DesignationView entity)
{
try
{
var lstDesig = adbContext.designation.Where(x => x.Desig_Id == entity.Desig_Id).FirstOrDefault();
if (lstDesig != null)
{
lstDesig.Company_Id = entity.Company_Id;
lstDesig.Dept_Id = entity.Dept_Id;
lstDesig.Zone_Id = entity.Zone_Id;
lstDesig.Desig_Code = entity.Desig_Code;
lstDesig.Desig_Name = entity.Desig_Name;
lstDesig.Report_To = entity.Report_To;
lstDesig.AdditionalReport_To = entity.AdditionalReport_To;
lstDesig.Level = entity.Level;
lstDesig.isActive = entity.isActive;
lstDesig.UpdatedBy = entity.UpdatedBy;
lstDesig.UpdatedOn = DateTime.Now;
adbContext.designation.Update(lstDesig);
await Task.FromResult(adbContext.SaveChanges());
}
else
{
throw new Exception("Data Not Available");
}
}
catch (Exception ex)
{
throw ex;
}
}
public async Task Insert(DesignationView entity)
{
try
{
//Insert New Designation
var vList = new Designation
{
Company_Id = entity.Company_Id,
Dept_Id = entity.Dept_Id,
Zone_Id = entity.Zone_Id,
Desig_Code = entity.Desig_Code.Trim(),
Desig_Name = entity.Desig_Name.Trim(),
Report_To = entity.Report_To,
AdditionalReport_To = entity.AdditionalReport_To,
Level = entity.Level,
isActive = entity.isActive,
AddedBy = entity.AddedBy,
AddedOn = DateTime.Now
};
adbContext.designation.Add(vList);
await Task.FromResult(adbContext.SaveChanges());
}
catch (Exception ex)
{
throw ex;
}
}
public async Task <IActionResult> Edit(DesignationView designation)
{
ResponseHelper objHelper = new ResponseHelper();
if (!ModelState.IsValid)
{
objHelper.Status = StatusCodes.Status424FailedDependency;
objHelper.Message = ModelException.Errors(ModelState);
return(BadRequest(objHelper));
}
try
{
if (designationRepository.Exists(designation))
{
objHelper.Status = StatusCodes.Status200OK;
objHelper.Message = "Data already available";
return(Ok(objHelper));
}
await designationRepository.Update(designation);
objHelper.Status = StatusCodes.Status200OK;
objHelper.Message = "Saved Successfully";
objHelper.Data = designation;
return(Ok(objHelper));
}
catch (Exception ex)
{
objHelper.Status = StatusCodes.Status500InternalServerError;
objHelper.Message = ex.Message;
return(StatusCode(StatusCodes.Status500InternalServerError, objHelper));
}
}
public async Task <IActionResult> Add(DesignationView designation)
{
ResponseHelper objHelper = new ResponseHelper();
if (!ModelState.IsValid)
{
objHelper.Status = StatusCodes.Status424FailedDependency;
objHelper.Message = "Invalid Model State";
return(BadRequest(objHelper));
}
try
{
if (designationRepository.Exists(designation))
{
objHelper.Status = StatusCodes.Status200OK;
objHelper.Message = "Data already available";
return(Ok(objHelper));
}
await designationRepository.Insert(designation);
objHelper.Status = StatusCodes.Status200OK;
objHelper.Message = "Saved Successfully";
objHelper.Data = designation;
return(Ok(objHelper));
}
catch
{
objHelper.Status = StatusCodes.Status500InternalServerError;
objHelper.Message = "Get Unsuccessful";
return(StatusCode(StatusCodes.Status500InternalServerError, objHelper));
}
}
public bool Exists(DesignationView entity)
{
try
{
int intCount = 0;
if (entity.Desig_Id > 0) //Update Validation
{
intCount = adbContext.designation.Where(w => w.Desig_Id != entity.Desig_Id && (w.Desig_Code == entity.Desig_Code || w.Desig_Name == entity.Desig_Name)).Count();
}
else //Insert Validation
{
intCount = adbContext.designation.Where(w => w.Desig_Code == entity.Desig_Code || w.Desig_Name == entity.Desig_Name).Count();
}
return(intCount > 0 ? true : false);
}
catch (Exception ex)
{
throw ex;
}
}
public async void View_Designation()
{
if (selectDesignation.DESIGNATION_ID != null && selectDesignation.DESIGNATION_ID != 0)
{
App.Current.Properties["Action"] = "View";
HttpClient client = new HttpClient();
client.BaseAddress = new Uri(GlobalData.gblApiAdress);
client.DefaultRequestHeaders.Accept.Add(
new MediaTypeWithQualityHeaderValue("application/json"));
client.Timeout = new TimeSpan(500000000000);
HttpResponseMessage response = client.GetAsync("api/DesignationListAPI/DesignationEdit?id=" + selectDesignation.DESIGNATION_ID + "").Result;
if (response.IsSuccessStatusCode)
{
data = JsonConvert.DeserializeObject <DesignationModel[]>(await response.Content.ReadAsStringAsync());
if (data.Length > 0)
{
for (int i = 0; i < data.Length; i++)
{
selectDesignation.DESIGNATION_ID = data[i].DESIGNATION_ID;
selectDesignation.DESIGNATION_NAME = data[i].DESIGNATION_NAME;
selectDesignation.CREATED_BY = data[i].CREATED_BY;
selectDesignation.CREATED_DATE = data[i].CREATED_DATE;
selectDesignation.IS_DELETE = data[i].IS_DELETE;
selectDesignation.COMPANY_ID = data[i].COMPANY_ID;
selectDesignation.SORT_INDEX = data[i].SORT_INDEX;
selectDesignation.STATUS = data[i].STATUS;
}
App.Current.Properties["DesignationView"] = selectDesignation;
DesignationView IA = new DesignationView();
IA.Show();
}
}
}
else
{
MessageBox.Show("Select unit first", "Unit Selection", MessageBoxButton.OK, MessageBoxImage.Error);
return;
}
}
public JsonResult Save([Bind(Include = "Name,DesignationID,Description,IsActive,SetOn,SetBy")] DesignationView designationView, bool isInsert)
{
var designation = new Designation
{
DesignationID = Convert.ToByte(designationView.DesignationID),
Description = designationView.Description,
Name = designationView.Name,
IsActive = designationView.IsActive,
IsDelete = false,
SetOn = DateTime.Now,
SetBy = LoginInformation.UserID
};
if (!ModelState.IsValid)
{
return new JsonResult
{
Data =
_unitOfWork.DesignationRepository.GetByID(Convert.ToByte(designation.DesignationID))
.ToDesignationView()
}
}
;
if (isInsert)
{
_unitOfWork.DesignationRepository.Insert(designation);
}
else
{
_unitOfWork.DesignationRepository.Update(designation);
}
_unitOfWork.Save();
return(new JsonResult {
Data = _unitOfWork.DesignationRepository.GetByID(Convert.ToByte(designation.DesignationID)).ToDesignationView()
});
}
