public List <TrainingPartnerDO> SearchTrainingPartner(TrainingPartnerDO objDO)
{
List <TrainingPartnerDO> objList = new List <TrainingPartnerDO>();
var result = db.stp_tblTrainingPartner_Search(objDO.TrainingPartnerName, objDO.TrainingPartnerCode, objDO.StateId, objDO.City).ToList();
if (result != null)
{
foreach (var item in result)
{
TrainingPartnerDO objNew = new TrainingPartnerDO();
objNew.TrainingPartnerId = item.TrainingPartnerId;
objNew.TrainingPartnerName = item.TrainingPartnerName;
objNew.TrainingPartnerCode = item.TrainingPartnerCode;
objNew.POCName = item.POCName;
objNew.TPAddress = item.TPAddress;
objNew.TPDescription = item.TPDescription;
objNew.NoOfCenters = Convert.ToInt32(item.NoOfCenters);
objNew.POCMobileNo = item.POCMobileNo;
objNew.StateId = Convert.ToInt32(item.StateId);
objNew.City = item.City;
objList.Add(objNew);
}
}
return(objList);
}
public int UpdateJobRoleDetailsForTP(TrainingPartnerDO objDO)
{
//var result = db.STP_tblOnlinetestDetailsLatest_Update(objDO.OnlineTestDetailsId, objDO.OnlineTestId, objDO.questionBankId, objDO.topicId, objDO.chapterId, null, null, 0, 0, 0, objDO.marks, objDO.createdBy, DateTime.Now);
var result = 0;
return(result);
}
public TrainingPartnerDO GetTPDetailsById(int TrainingPartnerId)
{
TrainingPartnerDO objDO = new TrainingPartnerDO();
objDO = objDAL.GetTPDetailsById(TrainingPartnerId);
return(objDO);
}
public List <TrainingPartnerDO> SearchTrainingPartner(TrainingPartnerDO objDO)
{
List <TrainingPartnerDO> objList = new List <TrainingPartnerDO>();
objList = objDAL.SearchTrainingPartner(objDO);
return(objList);
}
public int SaveJobRoleDetailsForTP(TrainingPartnerDO objDO)
{
var result = db.stp_tbltpjobroles_Insert(objDO.TrainingPartnerId, 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 int UpdateTPDetails(TrainingPartnerDO objDO)
{
var result = db.stp_tblTrainingPartner_Update(objDO.TrainingPartnerId, objDO.TrainingPartnerName, objDO.TrainingPartnerCode,
objDO.POCName, objDO.TPAddress, objDO.TPDescription, objDO.NoOfCenters, objDO.POCMobileNo, objDO.StateId,
objDO.City, objDO.Createddate, objDO.CreatedBy, objDO.Updatedate, objDO.Updatedby);
var returnStatus = 0;
if (result != null)
{
foreach (var item in result)
{
returnStatus = item.Value;
}
}
return(returnStatus);
}
public int SaveTPDetails(TrainingPartnerDO od)
{
int resultstatus = 0;
var partner = db.stp_tblTrainingPartner_Insert(od.TrainingPartnerName, od.TrainingPartnerCode, od.POCName, od.TPAddress, od.TPDescription,
od.NoOfCenters, od.POCMobileNo, od.StateId, od.City, od.Createddate, od.CreatedBy, od.Updatedate, od.Updatedby);
if (partner > 0)
{
resultstatus = 1;
}
else
{
resultstatus = partner;
}
return(resultstatus);
}
public ActionResult UpdateTrainingPartner(int TrainingPartnerId)
{
GetStateList();
var instanceId = Session["InstanceId"];
if (instanceId != null)
{
GetSSCList(instanceId.ToString());
}
else
{
}
if (TrainingPartnerId == 0)
{
ViewData["UpdateTrainingPartner"] = null;
}
else
{
TrainingPartnerBL objBl = new TrainingPartnerBL();
TrainingPartnerDO objDO = new TrainingPartnerDO();
objDO = objBl.GetTPDetailsById(TrainingPartnerId);
if (objDO != null)
{
ViewData["TPDetails"] = objDO;
}
else
{
ViewData["TPDetails"] = null;
ViewData["UpdateTrainingPartner"] = null;
}
}
return(View());
}
public int SaveTrainingPartner(TrainingPartnerDO od)
{
int returnstatus = 0;
int InstanceId = Convert.ToInt32(Session["InstanceId"].ToString());
TrainingPartnerDO ob = new TrainingPartnerDO();
ob.TrainingPartnerId = od.TrainingPartnerId;
ob.TrainingPartnerName = od.TrainingPartnerName;
ob.TrainingPartnerCode = od.TrainingPartnerCode;
ob.POCName = od.POCName;
ob.TPAddress = od.TPAddress;
ob.TPDescription = od.TPDescription;
ob.NoOfCenters = od.NoOfCenters;
ob.POCMobileNo = od.POCMobileNo;
ob.StateId = od.StateId;
ob.City = od.City;
ob.Createddate = od.Createddate;
ob.CreatedBy = 1194;
ob.Updatedate = od.Updatedate;
ob.Updatedby = 1195;
int result = 0;
TrainingPartnerBL objBL = new TrainingPartnerBL();
result = objBL.SaveTPDetails(ob);
if (result == 1)
{
returnstatus = 1;
}
else
{
returnstatus = -1;
}
return(returnstatus);
}
public TrainingPartnerDO GetTPDetailsById(int TrainingPartnerId)
{
TrainingPartnerDO objDO = new TrainingPartnerDO();
var result = db.stp_tblTrainingPartnerDetails_SELById(TrainingPartnerId);
if (result != null)
{
foreach (var item in result)
{
objDO.TrainingPartnerId = item.TrainingPartnerId;
objDO.TrainingPartnerName = item.TrainingPartnerName;
objDO.TrainingPartnerCode = item.TrainingPartnerCode;
objDO.POCName = item.POCName;
objDO.TPAddress = item.TPAddress;
objDO.TPDescription = item.TPDescription;
objDO.NoOfCenters = Convert.ToInt32(item.NoOfCenters);
objDO.POCMobileNo = item.POCMobileNo;
objDO.StateId = Convert.ToInt32(item.StateId);
objDO.City = item.City;
}
}
return(objDO);
}
public List <TrainingPartnerDO> GetJobRoleDetailsByTpId(int InstanceId, int TrainingPartnerId)
{
List <TrainingPartnerDO> objList = new List <TrainingPartnerDO>();
var result = db.stp_GetJobRoleDetails(InstanceId, TrainingPartnerId).ToList();
if (result != null)
{
if (result.Count > 0)
{
foreach (var item in result)
{
TrainingPartnerDO objNewDO = new TrainingPartnerDO();
objNewDO.ClassificationName = item.ClassificationName;
objNewDO.SubClassificationName = item.SubClassificationName;
objNewDO.Description = item.Description;
objList.Add(objNewDO);
}
}
}
return(objList);
}
public int SaveJobRoleDetailsForTP(TrainingPartnerDO objDO)
{
return(objDAL.SaveJobRoleDetailsForTP(objDO));
}
public int UpdateTPDetails(TrainingPartnerDO objDO)
{
return(objDAL.UpdateTPDetails(objDO));
}
public int SaveTPDetails(TrainingPartnerDO od)
{
return(objDAL.SaveTPDetails(od));
}