/// <summary>
/// This methoda is used for sav the employee details with education experince and ids.
/// Added by Jiya
/// addedWehn 28 July 2019
/// </summary>
/// <param name="entity"></param>
/// <returns></returns>
public int UpdateEmployeeDetails(EmployeeDetailsSaveSchemaModel entity)
{
int returnValue = 0;
using (GEEDbContext context = new GEEDbContext())
{
var P1 = new SqlParameter("@EmployeeDetailsXML", entity.EmployeeDetailsXML);
var P2 = new SqlParameter("@EducationItemXML", entity.EducationItemXML);
var P3 = new SqlParameter("@ExperinceItemXML", entity.ExperinceItemXML);
var P4 = new SqlParameter("@EmployeeIdItemXML", entity.EmployeeIdItemXML);
var P5 = new SqlParameter("@modifiedBy", entity.ModifiedBy);
var P6 = new SqlParameter("@EmployeeMasterID", entity.EmployeeMasterID);
returnValue = context.Database.ExecuteSqlCommand("InsertEmployeeDetails @EmployeeDetailsXML, @EducationItemXML,@ExperinceItemXML,@EmployeeIdItemXML,@modifiedBy,EmployeeMasterID", P1, P2, P3, P4, P5, P6);
}
return(returnValue);
}
public async Task <JsonResult> Create(EmployeeDetailsSchemaModel collection)
{
try
{
//Demo-Implementing Permission
//We aresending three parameter to check the permission
//GroupID-This is coming from session object(collection)
//Menu Code: From constants file MenuCodePermissionConstants.each action have its menu code.
//PERMISSION: from constant file MenuCodePermissionConstants. each permission have name same as database permission name.
bool isValid = true;//await objCommoWebLib.IsValidPermission(Convert.ToInt32(collection.EmployeeMasterModel.GroupID), MenuCodePermissionConstants.EMPLOYEE_MASTER_MENUCODE, MenuCodePermissionConstants.PERMISSION_ADD);
if (isValid)
{
List <EmployeeMasterModel> objMasterList = new List <EmployeeMasterModel>();
objMasterList.Add(collection.EmployeeMasterModel);
CommonWebLibrary objCommon = new CommonWebLibrary();
EmployeeDetailsSaveSchemaModel objSchema = new EmployeeDetailsSaveSchemaModel();
objSchema.EmployeeDetailsXML = objCommon.ToListTOTableString(objMasterList);
objSchema.EducationItemXML = objCommon.ToListTOTableString(collection.EmployeeEducationDetailModelList);
objSchema.ExperinceItemXML = objCommon.ToListTOTableString(collection.EmployeeExperienceModelList);
objSchema.EmployeeIdItemXML = objCommon.ToListTOTableString(collection.EmployeeIDdetailModelList);
objSchema.EmployeeMasterID = collection.EmployeeMasterModel.EmployeeMasterID;
objSchema.ModifiedBy = collection.EmployeeMasterModel.CreatedBy_ID;
// var token = Request.Headers["Authorization"];
var stringContent = new StringContent(JsonConvert.SerializeObject(objSchema).ToString(), Encoding.UTF8, "application/json");
var status = await service.Save(stringContent);
return(new JsonResult {
Data = new { status = status, IsSaved = true, Message = "Successfully Saved." }
});
}
else
{
return(new JsonResult {
Data = new { status = true, IsSaved = false, Message = "You don't have sufficient permission to this action." }
});
}
}
catch (Exception ex)
{
return(new JsonResult {
Data = new { status = false }
});
}
}
// [Authorize(Roles = HRConstant.EMPLOYEE_POST_ROLE)]
public HttpResponseMessage Save(EmployeeDetailsSaveSchemaModel data)
{
try
{
if (_employee.SaveEmployeeDetails(data) > 0)
{
return(Request.CreateResponse(HttpStatusCode.OK, "Data Saved"));
}
else
{
Common.MyLogger.Error("data not saved return value is " + _employee.SaveEmployeeDetails(data).ToString());
return(Request.CreateResponse(HttpStatusCode.BadRequest, "Error"));
}
}
catch (Exception ex)
{
Common.MyLogger.Error(ex.Message + ex.StackTrace + ex.InnerException.ToString());
return(Request.CreateResponse(HttpStatusCode.BadRequest, "Error"));
}
}
