public SaveTrainerDO GetTrainerDetailsById(int TrainerId)
{
SaveTrainerDO objDO = new SaveTrainerDO();
var result = db.stp_tblMasterTrainer_SELById(TrainerId);
if (result != null)
{
foreach (var item in result)
{
objDO.TrainerId = item.TrainerId;
objDO.TrainerName = item.TrainerName;
objDO.Gender = item.Gender;
objDO.DateofBirth = item.DateofBirth;
objDO.AadhaarNumber = Convert.ToInt32(item.AadhaarNumber);
objDO.EducationAttained = item.EducationAttained;
objDO.Industryexperience = Convert.ToInt32(item.Industryexperience);
objDO.TrainingExperience = Convert.ToInt32(item.TrainingExperience);
objDO.TrainingType = Convert.ToInt32(item.TrainingType);
objDO.MobileNumber = item.MobileNumber;
objDO.LandlineNumber = item.LandlineNumber;
objDO.EmailAddress = item.EmailAddress;
objDO.ParentType = Convert.ToInt32(item.ParentType);
objDO.NameofParent = item.NameofParent;
objDO.NameofTrainingPartner = item.NameofTrainingPartner;
objDO.SPOCMobileNumber = item.SPOCMobileNumber;
objDO.Scheme = item.Scheme;
objDO.Sector = item.Sector;
objDO.State = Convert.ToInt32(item.State);
objDO.City = item.City;
}
}
return(objDO);
}
public ActionResult UpdateTrainerDetails(int TrainerId)
{
GetStateList();
var instanceId = Session["InstanceId"];
if (instanceId != null)
{
GetSSCList(instanceId.ToString());
if (TrainerId == 0)
{
ViewData["UpdateMasterTrainer"] = null;
}
else
{
TrainerBL objBL = new TrainerBL();
SaveTrainerDO objDO = new SaveTrainerDO();
objDO = objBL.GetTrainerDetailsById(TrainerId);
if (objDO != null)
{
ViewData["TrainerDetails"] = objDO;
}
else
{
ViewData["TrainerDetails"] = null;
ViewData["UpdateMasterTrainer"] = null;
}
}
}
else
{
}
return(View());
}
public SaveTrainerDO GetTrainerDetailsById(int TrainerId)
{
SaveTrainerDO objDO = new SaveTrainerDO();
objDO = objDAL.GetTrainerDetailsById(TrainerId);
return(objDO);
}
public JsonResult SaveTraninerDetails(List <SaveTrainerDO> SaveTrainer)
{
int returnStatus = 0;
JsonResult result = new JsonResult();
TrainerBL objBL = new TrainerBL();
SaveTrainerDO objDO = new SaveTrainerDO();
foreach (var item in SaveTrainer)
{
objDO.TrainerId = item.TrainerId;
objDO.TrainerName = item.TrainerName;
objDO.Gender = item.Gender;
objDO.DateofBirth = item.DateofBirth;
objDO.AadhaarNumber = item.AadhaarNumber;
objDO.EducationAttained = item.EducationAttained;
objDO.Industryexperience = item.Industryexperience;
objDO.TrainingExperience = item.TrainingExperience;
objDO.TrainingType = item.TrainingType;
objDO.MobileNumber = item.MobileNumber;
objDO.LandlineNumber = item.LandlineNumber;
objDO.EmailAddress = item.EmailAddress;
objDO.ParentType = item.ParentType;
objDO.NameofParent = item.NameofParent;
objDO.NameofTrainingPartner = item.NameofTrainingPartner;
objDO.SPOCMobileNumber = item.SPOCMobileNumber;
objDO.Scheme = item.Scheme;
objDO.DOA = item.DOA;
objDO.EmploymentState = item.EmploymentState;
objDO.Sector = item.Sector;
objDO.DomainJobRole = item.DomainJobRole;
objDO.OtherJobRole = item.OtherJobRole;
objDO.State = item.State;
objDO.City = item.City;
objDO.TOTalDates = item.TOTalDates;
objDO.Createddate = item.Createddate;
objDO.CreatedBy = item.CreatedBy;
objDO.Updatedate = item.Updatedate;
objDO.Updatedby = item.Updatedby;
int obj = 0;
obj = objBL.SaveTraninerDetail(objDO);
if (obj == 1)
{
returnStatus = 1;
}
else
{
returnStatus = -1;
}
result.Data = obj;
}
return(result);
}
public int SaveTrainerDetails(SaveTrainerDO objDO)
{
int resultStatus = 0;
var Traning = db.stp_tblMasterTrainer_Insert(objDO.TrainerId, objDO.TrainerName, objDO.Gender, objDO.DateofBirth, objDO.AadhaarNumber, objDO.EducationAttained, objDO.Industryexperience, objDO.TrainingExperience, objDO.TrainingType, objDO.MobileNumber, objDO.LandlineNumber, objDO.EmailAddress, objDO.ParentType, objDO.NameofParent, objDO.NameofTrainingPartner, objDO.SPOCMobileNumber, objDO.Scheme, objDO.DOA, objDO.EmploymentState, objDO.Sector, objDO.DomainJobRole, objDO.OtherJobRole, objDO.State, objDO.City, objDO.SSCId, objDO.JobRole, objDO.TOTalDates, DateTime.Now, objDO.CreatedBy, objDO.Updatedate, objDO.Updatedby);
if (Traning > 0)
{
resultStatus = 1;
}
else
{
resultStatus = Traning;
}
return(resultStatus);
}
public int UpdateTrainerDetails(SaveTrainerDO objDO)
{
var result = db.stp_tblMasterTrainer_Update(objDO.TrainerId, objDO.TrainerName, objDO.Gender, objDO.DateofBirth, objDO.AadhaarNumber, objDO.EducationAttained, objDO.Industryexperience, objDO.TrainingExperience, objDO.TrainingType, objDO.MobileNumber, objDO.LandlineNumber, objDO.EmailAddress, objDO.ParentType, objDO.NameofParent, objDO.NameofTrainingPartner, objDO.SPOCMobileNumber, objDO.Scheme, objDO.DOA, objDO.EmploymentState, objDO.Sector, objDO.DomainJobRole, objDO.OtherJobRole, objDO.State, objDO.City, objDO.TOTalDates, DateTime.Now, objDO.CreatedBy, objDO.Updatedate, objDO.Updatedby);
var returnStatus = 0;
if (result != null)
{
foreach (var item in result)
{
returnStatus = item.Value;
}
}
return(returnStatus);
}
public int SaveJobRoleDetailsForMasterTrainers(SaveTrainerDO objDO)
{
var result = db.stp_tblmtjobroles_Insert(objDO.TrainerId, objDO.SSCId, Convert.ToInt32(objDO.JobRole), "", objDO.CreatedBy, DateTime.Now, null, null);
int resultstatus = 0;
if (result > 0)
{
resultstatus = 1;
}
else
{
resultstatus = result;
}
return(resultstatus);
}
public List <SaveTrainerDO> GetJobRoleDetailsBySSCId(int InstanceId, int Instanceclassificationid)
{
List <SaveTrainerDO> objList = new List <SaveTrainerDO>();
var result = db.stp_GetJobRoles(InstanceId, @Instanceclassificationid).ToList();
if (result != null)
{
if (result.Count > 0)
{
foreach (var item in result)
{
SaveTrainerDO objNewDO = new SaveTrainerDO();
objNewDO.SSCId = item.InstanceSubClassificationId;
objNewDO.JobRole = item.SubClassificationName;
objList.Add(objNewDO);
}
}
}
return(objList);
}
public List <SaveTrainerDO> GetJobRoleDetailsByTrainerId(int InstanceId, int MasterTrainnersID)
{
List <SaveTrainerDO> objList = new List <SaveTrainerDO>();
var result = db.stp_GetJobRoleDetailsMT(InstanceId, MasterTrainnersID).ToList();
if (result != null)
{
if (result.Count > 0)
{
foreach (var item in result)
{
SaveTrainerDO objNewDO = new SaveTrainerDO();
objNewDO.ClassificationName = item.ClassificationName;
objNewDO.SubClassificationName = item.SubClassificationName;
objNewDO.Description = item.Description;
objList.Add(objNewDO);
}
}
}
return(objList);
}
public int SaveJobRoleDetailsForMasterTrainers(SaveTrainerDO objDO)
{
return(objDAL.SaveJobRoleDetailsForMasterTrainers(objDO));
}
public int UpdateTrainerDetails(SaveTrainerDO objDO)
{
return(objDAL.UpdateTrainerDetails(objDO));
}
public int SaveTraninerDetail(SaveTrainerDO objDO)
{
return(objDAL.SaveTrainerDetails(objDO));
}
