/// <summary>
/// make entry to database
/// </summary>
/// <param name="oldFileName"></param>
/// <param name="newFileName"></param>
/// <param name="filePath"></param>
/// <param name="workbasketId"></param>
/// <param name="discripanctCatgoryLkup"></param>
/// <param name="templateId"></param>
/// <param name="errorMessage"></param>
/// <returns></returns>
private bool SaveToDB(string oldFileName, string newFileName, string filePath, long workbasketId, long discripanctCatgoryLkup, long templateId, out string errorMessage)
{
bool isScuess = false;
DOGEN_BulkImport objDOGEN_BulkImport = new DOGEN_BulkImport();
errorMessage = string.Empty;
try
{
long loginUserID = currentUser.ADM_UserMasterId;
objDOGEN_BulkImport.WorkBasketLkup = workbasketId;
objDOGEN_BulkImport.DiscrepancyCategoryLkup = discripanctCatgoryLkup;
objDOGEN_BulkImport.GEN_BulkImportExcelTemplateMasterRef = templateId;
objDOGEN_BulkImport.ExcelFileName = oldFileName;
objDOGEN_BulkImport.DuplicateFileName = newFileName;
objDOGEN_BulkImport.ExcelFilelPath = filePath;
objDOGEN_BulkImport.ImportStatusLkup = (long)ImportStatus.ReadyForImport;
objDOGEN_BulkImport.IsActive = true;
ExceptionTypes result = _objBLBulkUpload.SaveBulkUpload(objDOGEN_BulkImport, loginUserID, out errorMessage);
if (result == ExceptionTypes.Success)
{
isScuess = true;
}
}
catch (Exception ex)
{
BLCommon.LogError(currentUser.ADM_UserMasterId, MethodBase.GetCurrentMethod().Name, (long)ErrorModuleName.BulkUpload, (long)ExceptionTypes.Uncategorized, string.Empty, ex.ToString());
throw ex;
}
return(isScuess);
}
public ExceptionTypes SaveBulkUpload(DOGEN_BulkImport objDOGEN_BulkImport, long loginUserID, out string errorMessage)
{
_lstParameters = new List <SqlParameter>();
SqlParameter sqlParam;
long lErrocode = 0;
long lErrorNumber = 0;
errorMessage = string.Empty;
long lRowsEffected = 0;
try
{
sqlParam = new SqlParameter();
sqlParam.ParameterName = "@WorkBasketLkup";
sqlParam.SqlDbType = SqlDbType.BigInt;
sqlParam.Value = objDOGEN_BulkImport.WorkBasketLkup;
_lstParameters.Add(sqlParam);
sqlParam = new SqlParameter();
sqlParam.ParameterName = "@DiscrepancyCategoryLkup";
sqlParam.SqlDbType = SqlDbType.BigInt;
sqlParam.Value = objDOGEN_BulkImport.DiscrepancyCategoryLkup;
_lstParameters.Add(sqlParam);
sqlParam = new SqlParameter();
sqlParam.ParameterName = "@GEN_BulkImportExcelTemplateMasterRef";
sqlParam.SqlDbType = SqlDbType.BigInt;
sqlParam.Value = objDOGEN_BulkImport.GEN_BulkImportExcelTemplateMasterRef;
_lstParameters.Add(sqlParam);
sqlParam = new SqlParameter();
sqlParam.ParameterName = "@ExcelFileName";
sqlParam.SqlDbType = SqlDbType.VarChar;
sqlParam.Value = objDOGEN_BulkImport.ExcelFileName;
_lstParameters.Add(sqlParam);
sqlParam = new SqlParameter();
sqlParam.ParameterName = "@DuplicateFileName";
sqlParam.SqlDbType = SqlDbType.VarChar;
sqlParam.Value = objDOGEN_BulkImport.DuplicateFileName;
_lstParameters.Add(sqlParam);
sqlParam = new SqlParameter();
sqlParam.ParameterName = "@ExcelFilelPath";
sqlParam.SqlDbType = SqlDbType.VarChar;
sqlParam.Value = objDOGEN_BulkImport.ExcelFilelPath;
_lstParameters.Add(sqlParam);
sqlParam = new SqlParameter();
sqlParam.ParameterName = "@ImportStatusLkup";
sqlParam.SqlDbType = SqlDbType.BigInt;
sqlParam.Value = objDOGEN_BulkImport.ImportStatusLkup;
_lstParameters.Add(sqlParam);
sqlParam = new SqlParameter();
sqlParam.ParameterName = "@LoginUserId";
sqlParam.SqlDbType = SqlDbType.BigInt;
sqlParam.Value = loginUserID;
_lstParameters.Add(sqlParam);
sqlParam = new SqlParameter();
sqlParam.ParameterName = "@GEN_BulkImportID";
sqlParam.SqlDbType = SqlDbType.BigInt;
sqlParam.Direction = ParameterDirection.Output;
_lstParameters.Add(sqlParam);
sqlParam = new SqlParameter();
sqlParam.ParameterName = "@ErrorMessage";
sqlParam.SqlDbType = SqlDbType.VarChar;
sqlParam.Value = string.Empty;
sqlParam.Direction = ParameterDirection.Output;
sqlParam.Size = 2000;
_lstParameters.Add(sqlParam);
long executionResult = _daHelper.ExecuteDMLSP(ConstantTexts.SP_APP_INS_GEN_BulkImport, _lstParameters.ToArray(), out lErrocode, out lErrorNumber, out lRowsEffected, out errorMessage);
sqlParam = _lstParameters.FirstOrDefault(x => x.ParameterName == "@ErrorMessage");
if (sqlParam != null && sqlParam.Value != null)
{
errorMessage += sqlParam.Value.ToString();
}
if (executionResult == (long)ExceptionTypes.Success && string.IsNullOrEmpty(errorMessage))
{
return(ExceptionTypes.Success);
}
else
{
return(ExceptionTypes.UnknownError);
}
}
catch (Exception ex)
{
errorMessage = ex.Message;
return(ExceptionTypes.UnknownError);
}
finally
{
_lstParameters = null;
}
}
public ExceptionTypes SaveBulkUpload(DOGEN_BulkImport objDOGEN_BulkImport, long loginUserID, DataTable dtFileData, out long GEN_BulkImportID, out string errorMessage)
{
retValue = new ExceptionTypes();
return(retValue = _objDALCommon.SaveBulkUpload(objDOGEN_BulkImport, loginUserID, dtFileData, out GEN_BulkImportID, out errorMessage));
}
public ExceptionTypes SaveBulkUpload(DOGEN_BulkImport objDOGEN_BulkImport, long loginUserID, out string errorMessage)
{
_exceptionTypes = new ExceptionTypes();
return(_exceptionTypes = objDALBulkUpload.SaveBulkUpload(objDOGEN_BulkImport, loginUserID, out errorMessage));
}
