public List <EstimationFileModel> GetFileListByID(EstimationFileModel model, Guid id)
{
List <EstimationFile> MasterDataList;
List <EstimationFileModel> filelist = new List <EstimationFileModel> ();
EstimationFileModel filetemplate = new EstimationFileModel();
try
{
MasterDataList = _dbContext.EstimationFiles.ToList();
if (MasterDataList != null)
{
foreach (EstimationFile a in MasterDataList)
{
if (a.EstimateID == id)
{
filetemplate = Mapper.Map <EstimationFile, EstimationFileModel> (a);
filelist.Add(filetemplate);
}
}
}
}
catch (Exception ex)
{
}
return(filelist);
}
/* Function to retrive a list of EstimationFiles by Estimaton ID in conjunction with EstimationDetails ID */
/* Programmed by Ashis Kr. Das */
public List <EstimationFileModel> GetEstimationFilesListByID(BaseViewModel model, string EstimationID, string EstimationDetailsID)
{
SqlCommand cmd;
SqlDataReader DataReader;
EstimationFileModel FileModel;
List <EstimationFileModel> FileList = new List <EstimationFileModel>();
try
{
_sqlConnService.OpenConnection();
cmd = new SqlCommand("SP_GetAllEstimationFiles", _sqlConnService.CreateConnection());
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@EstimateID", Guid.Parse(EstimationID));
cmd.Parameters.AddWithValue("@EstimateDetailsID", Guid.Parse(EstimationDetailsID));
DataReader = cmd.ExecuteReader();
while (DataReader.Read() == true)
{
FileModel = new EstimationFileModel();
FileModel.ID = Guid.Parse(DataReader["ID"].ToString());
FileModel.EstimateID = Guid.Parse(DataReader["EstimateID"].ToString());
FileModel.EstimateDetailsID = Guid.Parse(DataReader["EstimateDetailsID"].ToString());
FileModel.FileName = DataReader["FileName"].ToString();
FileModel.DownloadURL = DataReader["DownloadURL"].ToString();
FileModel.TranslationText = DataReader["TranslationText"].ToString();
FileModel.WordCount = Convert.ToInt32(DataReader["WordCount"].ToString());
FileList.Add(FileModel);
}
DataReader.Close();
}
catch (Exception ex)
{
IErrorLogService errorLog = new ErrorLogService();
string message = ex.InnerException != null ? ex.InnerException.Message : ex.Message;
errorLog.SetErrorLog(model.CurrentUserID, "Estimation", message);
throw new Exception(message);
}
finally
{
_sqlConnService.CloseConnection();
}
return(FileList);
}
public HttpResponseMessage GetFileList(EstimationFileModel model, Guid ID)
{
try
{
var estimation = _service.GetFileListByID(model, ID);
if (estimation != null)
{
return(Request.CreateResponse(HttpStatusCode.OK, estimation));
}
else
{
string message = "Error in getting Data";
return(Request.CreateErrorResponse(HttpStatusCode.Forbidden, message));
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, ex.Message));
}
}
