public TrainingCenterDO GetTCDetailsById(int TrainingCenterId)
{
TrainingCenterDO objNew = new TrainingCenterDO();
var result = db.stp_tblTrainingCenterDetails_SELById(TrainingCenterId);
if (result != null)
{
foreach (var item in result)
{
objNew.TrainingCenterId = item.TrainingCenterId;
objNew.TrainingCenterName = item.TrainingCenterName;
objNew.TrainingPartnerId = item.TrainingPartnerId;
objNew.TrainingCenterIDSmartID = item.TrainingCenterIDSmartID;
objNew.SDMSID = item.SDMSID;
objNew.CenterAddress = item.CenterAddress;
objNew.CenterDescription = item.CenterDescription;
objNew.StartDate = item.TrainingCenterApprovalStartDate.ToString();
objNew.PocName = item.PocName;
objNew.PocMobileNo = item.PocMobileNo;
objNew.StateId = Convert.ToInt32(item.StateId);
objNew.City = item.City;
}
}
return(objNew);
}
public TrainingCenterDO GetTCDetailsById(int TrainingCenterId)
{
TrainingCenterDO objDO = new TrainingCenterDO();
objDO = objDAL.GetTCDetailsById(TrainingCenterId);
return(objDO);
}
public List <TrainingCenterDO> SearchTrainingCenter(TrainingCenterDO objDO)
{
List <TrainingCenterDO> objList = new List <TrainingCenterDO>();
var result = db.stp_tblTrainingCenter_Search(objDO.TrainingCenterName, objDO.TrainingPartnerId, objDO.TrainingCenterIDSmartID, objDO.SDMSID, objDO.StateId, objDO.City).ToList();
if (result != null)
{
foreach (var item in result)
{
TrainingCenterDO objNew = new TrainingCenterDO();
objNew.TrainingCenterId = item.TrainingCenterId;
objNew.TrainingCenterName = item.TrainingCenterName;
objNew.TrainingPartnerId = item.TrainingPartnerId;
objNew.TrainingCenterIDSmartID = item.TrainingCenterIDSmartID;
objNew.SDMSID = item.SDMSID;
objNew.CenterAddress = item.CenterAddress;
objNew.CenterDescription = item.CenterDescription;
objNew.StartDate = item.TrainingCenterApprovalStartDate.ToString();
objNew.PocName = item.PocName;
objNew.PocMobileNo = item.PocMobileNo;
objNew.StateId = Convert.ToInt32(item.StateId);
objNew.City = item.City;
objList.Add(objNew);
}
}
return(objList);
}
public List <TrainingCenterDO> SearchTrainingCenter(TrainingCenterDO objDO)
{
List <TrainingCenterDO> objList = new List <TrainingCenterDO>();
objList = objDAL.SearchTrainingCenter(objDO);
return(objList);
}
public ActionResult UpdateTrainingCenter(int TrainingCenterId)
{
GetStateList();
var instanceId = Session["InstanceId"];
GetSSCList(instanceId.ToString());
if (instanceId != null)
{
if (TrainingCenterId == 0)
{
ViewData["UpdateTrainingCenter"] = null;
}
else
{
TrainingCenterBL objBl = new TrainingCenterBL();
TrainingCenterDO objDO = new TrainingCenterDO();
objDO = objBl.GetTCDetailsById(TrainingCenterId);
if (objDO != null)
{
ViewData["TCDetails"] = objDO;
}
else
{
ViewData["TCDetails"] = null;
ViewData["UpdateTrainingCenter"] = null;
}
}
}
else
{
}
return(View());
}
public int SaveJobRoleDetailsForTC(TrainingCenterDO objDO)
{
var result = db.stp_tbltcjobroles_Insert(objDO.TrainingCenterId, 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 UpdateTCDetails(TrainingCenterDO objDO)
{
var result = db.stp_tblTrainingCenter_Update(objDO.TrainingCenterId, objDO.TrainingCenterName, objDO.TrainingPartnerId,
objDO.TrainingCenterIDSmartID, objDO.SDMSID, objDO.CenterAddress, objDO.CenterDescription, Convert.ToDateTime(objDO.StartDate), objDO.PocName,
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 SaveTcDetails(TrainingCenterDO od)
{
int resultstatus = 0;
var center = db.stp_tblTrainingCenter_Insert(od.TrainingCenterName, od.TrainingPartnerId, od.TrainingCenterIDSmartID, od.SDMSID, od.CenterAddress, od.CenterDescription,
Convert.ToDateTime(od.StartDate), od.PocName, od.PocMobileNo, od.StateId, od.City, od.Createddate, od.CreatedBy, od.Updatedate, od.Updatedby);
if (center > 0)
{
resultstatus = 1;
}
else
{
resultstatus = center;
}
return(resultstatus);
}
public int SaveTrainingCenter(TrainingCenterDO od)
{
int returnstatus = 0;
int InstanceId = Convert.ToInt32(Session["InstanceId"].ToString());
TrainingCenterDO ob = new TrainingCenterDO();
ob.TrainingCenterId = od.TrainingCenterId;
ob.TrainingCenterName = od.TrainingCenterName;
ob.TrainingPartnerId = od.TrainingPartnerId;
ob.TrainingCenterIDSmartID = od.TrainingCenterIDSmartID;
ob.SDMSID = od.SDMSID;
ob.CenterAddress = od.CenterAddress;
ob.CenterDescription = od.CenterDescription;
ob.StartDate = od.StartDate;
ob.PocName = od.PocName;
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;
TrainingCenterBL objBL = new TrainingCenterBL();
result = objBL.SaveTcDetails(ob);
if (result == 1)
{
returnstatus = 1;
}
else
{
returnstatus = -1;
}
return(returnstatus);
}
public List <TrainingCenterDO> GetJobRoleDetailsByTcId(int InstanceId, int TrainingCenterId)
{
List <TrainingCenterDO> objList = new List <TrainingCenterDO>();
var result = db.stp_GetJobRoleDetails_Center(InstanceId, TrainingCenterId).ToList();
if (result != null)
{
if (result.Count > 0)
{
foreach (var item in result)
{
TrainingCenterDO objNewDO = new TrainingCenterDO();
objNewDO.ClassificationName = item.ClassificationName;
objNewDO.SubClassificationName = item.SubClassificationName;
objNewDO.Description = item.Description;
objList.Add(objNewDO);
}
}
}
return(objList);
}
public int SaveJobRoleDetailsForTC(TrainingCenterDO objDO)
{
return(objDAL.SaveJobRoleDetailsForTC(objDO));
}
public int UpdateTCDetails(TrainingCenterDO objDO)
{
return(objDAL.UpdateTCDetails(objDO));
}
public int SaveTcDetails(TrainingCenterDO od)
{
return(objDAL.SaveTcDetails(od));
}
