internal string SaveMapping(PLOToPEO PLOToPEO, string name)
{
try
{
PLOToPEO.PLO = PLOService.FindById(PLOToPEO.PLO.Id, name);
if (PLOToPEO.MapPEOLists.Count > 0)
{
foreach (var item in PLOToPEO.MapPEOLists)
{
PLOToPEOMapping PLOToPEOMapping = new PLOToPEOMapping()
{
PLO = PLOToPEO.PLO,
PEO = PEOService.FindById(item.PEO.Id, name),
Points = item.Points
};
if (!IsExistMapping(PLOToPEOMapping, name))
{
Save(PLOToPEOMapping, name);
}
}
return(null);
}
else
{
return(Messages.InvalidField);
}
}
catch (Exception ex)
{
Logger.Log(ex);
return(ex.Message);
}
}
public bool Update(PLOToPEOMapping PLOToPEOMapping)
{
int status = 0;
using (connection = Database.GetConnection())
{
try
{
using (command = new MySqlCommand(Procedures.UpdatePLOToPEOMapping, connection))
{
command.CommandType = CommandType.StoredProcedure;
command.Parameters.Add(new MySqlParameter("@Id", PLOToPEOMapping.Id));
SetAllParameters(PLOToPEOMapping);
connection.Open();
status = command.ExecuteNonQuery();
}
}
catch (Exception ex)
{
Logger.Log(ex);
}
}
return((status > 0) ? true : false);
}
public string Delete(int Id, string CurrentUsername)
{
PLOToPEOMapping PLOToPEOMapping = FindById(Id, CurrentUsername);
if (PLOToPEOMapping != null)
{
return(PLOToPEOMappingRepository.Delete(Id) ? null : Messages.IssueInDatabase);
}
else
{
return(Messages.NotFound);
}
}
private bool IsExistMapping(PLOToPEOMapping PLOToPEOMapping, string name)
{
try
{
var ExistmapPEOs = FindByPLOId(PLOToPEOMapping.PLO.Id, name).MapPEOLists.FindAll(st => st.PEO.Id == PLOToPEOMapping.PEO.Id);
return((ExistmapPEOs.Count > 0) ? true : false);
}
catch (Exception ex)
{
Logger.Log(ex);
return(false);
}
}
internal string UpdateMapping(PLOToPEO PLOToPEO, string name)
{
try
{
if (PLOToPEO.MapPEOLists.Count > 0)
{
PLOToPEO.PLO = PLOService.FindById(PLOToPEO.PLO.Id, name);
if (PLOToPEO != null)
{
foreach (var item in PLOToPEO.MapPEOLists)
{
PLOToPEOMapping PLOToPEOMapping = new PLOToPEOMapping()
{
PLO = PLOToPEO.PLO,
PEO = PEOService.FindById(item.PEO.Id, name),
Points = item.Points
};
if (!IsExistMapping(PLOToPEOMapping, name))
{
Save(PLOToPEOMapping, name);
}
else
{
var deleteorUpdate = FindAll(name).Find(mp => mp.PLO.Id == PLOToPEOMapping.PLO.Id && mp.PEO.Id == PLOToPEOMapping.PEO.Id);
PLOToPEOMapping.Id = deleteorUpdate.Id;
Update(PLOToPEOMapping, name);
}
}
return(null);
}
else
{
return(Messages.PLONotFound);
}
}
else
{
return(Messages.InvalidField);
}
}
catch (Exception ex)
{
Logger.Log(ex);
return(ex.Message);
}
}
private string IsValidPLOToPEOMapping(PLOToPEOMapping PLOToPEOMapping, string currentUsername)
{
if (PLOService.FindById(PLOToPEOMapping.PLO.Id, currentUsername) != null)
{
if (PEOService.FindById(PLOToPEOMapping.PEO.Id, currentUsername) != null)
{
return(null);
}
else
{
return(Messages.PEONotFound);
}
}
else
{
return(Messages.PLONotFound);
}
}
public string Update(PLOToPEOMapping PLOToPEOMapping, string CurrentUsername)
{
string message = IsValidPLOToPEOMapping(PLOToPEOMapping, CurrentUsername);
if (FindById(PLOToPEOMapping.Id, CurrentUsername) != null)
{
if (String.IsNullOrEmpty(message))
{
return(PLOToPEOMappingRepository.Update(PLOToPEOMapping) ? null : Messages.IssueInDatabase);
}
else
{
return(Messages.PLONotFound);
}
}
else
{
return(Messages.NotFound);
}
}
public List <PLOToPEOMapping> FindAll()
{
List <PLOToPEOMapping> allPLOToPEOMapping = new List <PLOToPEOMapping>();
try
{
using (connection = Database.GetConnection())
{
using (command = new MySqlCommand(Views.ALLPLOToPEOMapping, connection))
{
command.CommandType = CommandType.Text;
connection.Open();
using (reader = command.ExecuteReader())
{
while (reader.Read())
{
PLOToPEOMapping PLOToPEOMapping = new PLOToPEOMapping
{
Id = reader.GetInt32("id"),
PLO = new PLO()
{
Id = reader.GetInt32("plo_id")
},
PEO = new PEO()
{
Id = reader.GetInt32("peo_id")
},
Points = reader.GetFloat("points")
};
allPLOToPEOMapping.Add(PLOToPEOMapping);
}
}
}
}
}
catch (Exception ex)
{
Logger.Log(ex);
}
return(allPLOToPEOMapping);
}
public PLOToPEOMapping FindById(int id, string CurrentUsername)
{
PLOToPEOMapping PLOToPEOMapping = FindAll(CurrentUsername).Find(mtp => mtp.Id == id);
return(PLOToPEOMapping);
}
private void SetAllParameters(PLOToPEOMapping PLOToPEOMapping)
{
command.Parameters.Add(new MySqlParameter("@PLOId", PLOToPEOMapping.PLO.Id));
command.Parameters.Add(new MySqlParameter("@PEOId", PLOToPEOMapping.PEO.Id));
command.Parameters.Add(new MySqlParameter("@Points", PLOToPEOMapping.Points));
}
