/// <summary>
/// Get Headcount by Id
/// </summary>
/// <param name="r"></param>
/// <returns></returns>
public HeadCountDTO Get(HeadCountList r)
{
HeadCount headcount = null;
List <UploadFileDetail> uploadedFiles = null;
using (var dbCmd = Db.CreateCommand())
{
dbCmd.CommandType = CommandType.StoredProcedure;
dbCmd.CommandTimeout = 300;
dbCmd.Parameters.Add(new SqlParameter("@Id", r.Id));
dbCmd.CommandText = "sp_GetHeadcountDetailById";
using (var reader = dbCmd.ExecuteReader())
{
headcount = reader.ConvertTo <HeadCount>();
}
}
var result = new HeadCountDTO();
result.HeadCountItem = headcount == null ? new HeadCount() : headcount;
//Get File Name with Id
using (var dbCmd = Db.CreateCommand())
{
dbCmd.CommandType = CommandType.StoredProcedure;
dbCmd.CommandTimeout = 300;
dbCmd.Parameters.Add(new SqlParameter("@Id", r.Id));
dbCmd.CommandText = "sp_GetUploadedFilesByHeadcountId";
using (var reader = dbCmd.ExecuteReader())
{
uploadedFiles = reader.ConvertToList <UploadFileDetail>();
}
}
if (uploadedFiles.Count > 0)
{
result.UploadFileDetails = uploadedFiles;
}
else
{
result.UploadFileDetails = new List <UploadFileDetail>();
}
return(result);
}
public HeadCountDTO Put(HeadCountUpdate req)
{
List <UploadFileDetail> uploadedFiles = null;
req.Headcount.UpdatedBy = WindowsHelper.WindowsUserName;
req.Headcount.UpdatedDate = DateTime.Now;
Db.Update <HeadCount>(req.Headcount);
Db.Delete <UploadFileDetail>(x => x.HeadCountID == req.Headcount.Id);
foreach (var item in req.UploadFileDetailList)
{
Db.Save <UploadFileDetail>(item);
}
//Get File Name with Id
using (var dbCmd = Db.CreateCommand())
{
dbCmd.CommandType = CommandType.StoredProcedure;
dbCmd.CommandTimeout = 300;
dbCmd.Parameters.Add(new SqlParameter("@Id", req.Headcount.Id));
dbCmd.CommandText = "sp_GetUploadedFilesByHeadcountId";
using (var reader = dbCmd.ExecuteReader())
{
uploadedFiles = reader.ConvertToList <UploadFileDetail>();
}
}
var result = new HeadCountDTO
{
HeadCountItem = Db.GetById <HeadCount>(req.Headcount.Id)
};
if (uploadedFiles.Count > 0)
{
result.UploadFileDetails = uploadedFiles;
}
else
{
result.UploadFileDetails = new List <UploadFileDetail>();
}
return(result);
}
