public Response <PLRAssessmentDetail> SavePLR(PLRAssessmentDetail _PLRInvoiceObj, int userID, string userIP)
{
Response <PLRAssessmentDetail> response = new Response <PLRAssessmentDetail>();
PLRAssessmentDetail PLRAssessmentDetail = new PLRAssessmentDetail();
string message = string.Empty;
try
{
PLRAssessmentDetail = PLRDAO.SavePLRAssessment(_PLRInvoiceObj, userID, userIP);
if (PLRAssessmentDetail != null)
{
message = string.Format("PLR has been Saved.{0}PLR No {1}", Environment.NewLine, PLRAssessmentDetail.PlrNo);
}
response.Status = ResultStatus.Success;
response.Message = message;
response.Data = PLRAssessmentDetail;
}
catch (DbEntityValidationException e)
{
LoggerService.LogExceptionsToDebugConsole(e);
response.Status = ResultStatus.Error;
response.Message = "Error";
response.Data = PLRAssessmentDetail;
}
return(response);
}
public List <KeyValuePair <string, string> > GetALLFilesFromDB(string ClaimId, string Filter)
{
List <string> Entries = new List <string>();
List <KeyValuePair <string, string> > FileName = new List <KeyValuePair <string, string> >();
try
{
List <ImagesDetail> vAllFiles = FTPDAO.GetImagesDetail(Convert.ToInt32(ClaimId));
if (!string.IsNullOrEmpty(Filter))
{
vAllFiles = vAllFiles.Where(x => x.Status != null && x.Status.ToLower() == Filter).ToList();
}
foreach (ImagesDetail vfile in vAllFiles)
{
if (vfile.URL.ToLowerInvariant().EndsWith(".jpg", StringComparison.Ordinal) ||
vfile.URL.ToLowerInvariant().EndsWith(".jpeg", StringComparison.Ordinal) ||
vfile.URL.ToLowerInvariant().EndsWith(".png", StringComparison.Ordinal) ||
vfile.URL.ToLowerInvariant().EndsWith(".gif", StringComparison.Ordinal))
{
FileName.Add(new KeyValuePair <string, string>(vfile.Status, vfile.URL));
}
}
}
catch (WebException ex)
{
LoggerService.LogExceptionsToDebugConsole(ex);
throw ex;
}
return(FileName);
}
public List <KeyValuePair <string, string> > GetSelectedFilesFromFTP(string FTPAddress, string ClaimId, string foldername, FtpCredentials ftpCredentials)
{
List <string> Entries = new List <string>();
List <KeyValuePair <string, string> > FileName = new List <KeyValuePair <string, string> >();
try
{
NetworkCredential networkcredentials = new NetworkCredential(ftpCredentials.FTPUserName, ftpCredentials.FTPPassword);
//Create FTP Request.
string folderpath = string.Format("{0}/{1}/{2}", FTPAddress, ClaimId, foldername);
FtpWebRequest request = (FtpWebRequest)WebRequest.Create(folderpath);
request.Method = WebRequestMethods.Ftp.ListDirectoryDetails;
//Enter FTP Server credentials.
request.Credentials = networkcredentials;
request.UsePassive = true;
request.UseBinary = true;
request.EnableSsl = false;
request.KeepAlive = true;
//Fetch the Response and read it using StreamReader.
FtpWebResponse response = (FtpWebResponse)request.GetResponse();
using (StreamReader reader = new StreamReader(response.GetResponseStream()))
{
//Read the Response as String and split using New Line character.
Entries = reader.ReadToEnd().Split(new string[] { Environment.NewLine }, StringSplitOptions.RemoveEmptyEntries).ToList();
}
response.Close();
//Loop and add details of each File to the DataTable.
foreach (string entry in Entries)
{
string[] splits = entry.Split(new string[] { " ", }, StringSplitOptions.RemoveEmptyEntries);
//Determine whether entry is for File or Directory
bool isFile = splits[0].Substring(0, 1) != "d";
if (isFile)
{
if (splits.Count() >= 8)
{
FileName.Add(new KeyValuePair <string, string>(foldername, splits[8]));
}
}
}
}
catch (WebException ex)
{
LoggerService.LogExceptionsToDebugConsole(ex);
throw ex;
}
return(FileName);
}
private PLRTaxes GetTaxes(int ContactId)
{
PLRTaxes plrTaxes = new PLRTaxes();
try
{
int?RegionId = (from c in _context.CLA_Workshops_VW
where c.ContactId == ContactId
select c.TaxRegion_Id).FirstOrDefault();
string IsCompany = (from c in _context.CLA_Workshops_VW
where c.ContactId == ContactId
select c.isCompany).FirstOrDefault();
SLS_CheckFBRList_Claim_SP_Result Filer = _context.SLS_CheckFBRList_Claim_SP(ContactId).FirstOrDefault();
List <Surveyor_SalesTax_Result> Tax = _context.Surveyor_SalesTax(RegionId).ToList();
if (Filer != null && IsCompany == "Y")
{
List <Surveyor_SalesTax_Result> _res = Tax.Where(x => x.Name.Contains("WH_Labor_NTN_C") || x.Name.Contains("WH_Part_NTN_C") || x.Name.Contains("GST on Labour") || x.Name.Contains("WTax on GST Labor")).ToList();
plrTaxes.GstLaborRate = _res.Where(x => x.TaxName == "Lab_Reg_Gst_RTU").FirstOrDefault() == null ? 0 : _res.Where(x => x.TaxName == "Lab_Reg_Gst_RTU").FirstOrDefault().TaxPercentage;
plrTaxes.GstLaborTaxId = _res.Where(x => x.TaxName == "Lab_Reg_Gst_RTU").FirstOrDefault() == null ? 0 : _res.Where(x => x.TaxName == "Lab_Reg_Gst_RTU").FirstOrDefault().TaxId;
plrTaxes.GstLaborTaxPercentageId = _res.Where(x => x.TaxName == "Lab_Reg_Gst_RTU").FirstOrDefault() == null ? 0 : _res.Where(x => x.TaxName == "Lab_Reg_Gst_RTU").FirstOrDefault().TaxPercentageId;
plrTaxes.WHPartRate = Tax.Where(x => x.Name == "WH_Part_NTN_C").FirstOrDefault() == null ? 0 : Tax.Where(x => x.Name == "WH_Part_NTN_C").FirstOrDefault().TaxPercentage;
plrTaxes.WHTaxPartTaxId = Tax.Where(x => x.Name == "WH_Part_NTN_C").FirstOrDefault() == null ? 0 : Tax.Where(x => x.Name == "WH_Part_NTN_C").FirstOrDefault().TaxId;
plrTaxes.WHPartTaxPercentageId = Tax.Where(x => x.Name == "WH_Part_NTN_C").FirstOrDefault() == null ? 0 : Tax.Where(x => x.Name == "WH_Part_NTN_C").FirstOrDefault().TaxPercentageId;
plrTaxes.WHLaborRate = Tax.Where(x => x.Name == "WH_Labor_NTN_C").FirstOrDefault() == null ? 0 : Tax.Where(x => x.Name == "WH_Labor_NTN_C").FirstOrDefault().TaxPercentage;
plrTaxes.WHTaxLaborTaxId = Tax.Where(x => x.Name == "WH_Labor_NTN_C").FirstOrDefault() == null ? 0 : Tax.Where(x => x.Name == "WH_Labor_NTN_C").FirstOrDefault().TaxId;
plrTaxes.WHTaxLaborPercentageId = Tax.Where(x => x.Name == "WH_Labor_NTN_C").FirstOrDefault() == null ? 0 : Tax.Where(x => x.Name == "WH_Labor_NTN_C").FirstOrDefault().TaxPercentageId;
plrTaxes.GstWHLaborRate = Tax.Where(x => x.TaxName == "Lab_Reg_GstWH_RTU").FirstOrDefault() == null ? 0 : Tax.Where(x => x.TaxName == "Lab_Reg_GstWH_RTU").FirstOrDefault().TaxPercentage;
plrTaxes.GstWHLaborTaxId = Tax.Where(x => x.TaxName == "Lab_Reg_GstWH_RTU").FirstOrDefault() == null ? 0 : Tax.Where(x => x.TaxName == "Lab_Reg_GstWH_RTU").FirstOrDefault().TaxId;
plrTaxes.GstWHLaborTaxPercentageId = Tax.Where(x => x.TaxName == "Lab_Reg_GstWH_RTU").FirstOrDefault() == null ? 0 : Tax.Where(x => x.TaxName == "Lab_Reg_GstWH_RTU").FirstOrDefault().TaxPercentageId;
}
else if (Filer != null && IsCompany == "N")
{
List <Surveyor_SalesTax_Result> _res = Tax.Where(x => x.Name.Contains("WH_Labor_NTN_NC") || x.Name.Contains("WH_Part_NTN_NC") || x.Name.Contains("GST on Labour") || x.Name.Contains("WTax on GST Labor")).ToList();
plrTaxes.GstLaborRate = _res.Where(x => x.TaxName == "Lab_Reg_Gst").FirstOrDefault() == null ? 0 : _res.Where(x => x.TaxName == "Lab_Reg_Gst").FirstOrDefault().TaxPercentage;
plrTaxes.GstLaborTaxId = _res.Where(x => x.TaxName == "Lab_Reg_Gst").FirstOrDefault() == null ? 0 : _res.Where(x => x.TaxName == "Lab_Reg_Gst").FirstOrDefault().TaxId;
plrTaxes.GstLaborTaxPercentageId = _res.Where(x => x.TaxName == "Lab_Reg_Gst").FirstOrDefault() == null ? 0 : _res.Where(x => x.TaxName == "Lab_Reg_Gst").FirstOrDefault().TaxPercentageId;
plrTaxes.WHPartRate = Tax.Where(x => x.Name == "WH_Part_NTN_NC").FirstOrDefault() == null ? 0 : Tax.Where(x => x.Name == "WH_Part_NTN_NC").FirstOrDefault().TaxPercentage;
plrTaxes.WHTaxPartTaxId = Tax.Where(x => x.Name == "WH_Part_NTN_NC").FirstOrDefault() == null ? 0 : Tax.Where(x => x.Name == "WH_Part_NTN_NC").FirstOrDefault().TaxId;
plrTaxes.WHPartTaxPercentageId = Tax.Where(x => x.Name == "WH_Part_NTN_NC").FirstOrDefault() == null ? 0 : Tax.Where(x => x.Name == "WH_Part_NTN_NC").FirstOrDefault().TaxPercentageId;
plrTaxes.WHLaborRate = Tax.Where(x => x.Name == "WH_Labor_NTN_NC").FirstOrDefault() == null ? 0 : Tax.Where(x => x.Name == "WH_Labor_NTN_NC").FirstOrDefault().TaxPercentage;
plrTaxes.WHTaxLaborTaxId = Tax.Where(x => x.Name == "WH_Labor_NTN_NC").FirstOrDefault() == null ? 0 : Tax.Where(x => x.Name == "WH_Labor_NTN_NC").FirstOrDefault().TaxId;
plrTaxes.WHTaxLaborPercentageId = Tax.Where(x => x.Name == "WH_Labor_NTN_NC").FirstOrDefault() == null ? 0 : Tax.Where(x => x.Name == "WH_Labor_NTN_NC").FirstOrDefault().TaxPercentageId;
plrTaxes.GstWHLaborRate = Tax.Where(x => x.TaxName == "Lab_Reg_GstWH").FirstOrDefault() == null ? 0 : Tax.Where(x => x.TaxName == "Lab_Reg_GstWH").FirstOrDefault().TaxPercentage;
plrTaxes.GstWHLaborTaxId = Tax.Where(x => x.TaxName == "Lab_Reg_GstWH").FirstOrDefault() == null ? 0 : Tax.Where(x => x.TaxName == "Lab_Reg_GstWH").FirstOrDefault().TaxId;
plrTaxes.GstWHLaborTaxPercentageId = Tax.Where(x => x.TaxName == "Lab_Reg_GstWH").FirstOrDefault() == null ? 0 : Tax.Where(x => x.TaxName == "Lab_Reg_GstWH").FirstOrDefault().TaxPercentageId;
}
else if (Filer == null && IsCompany == "Y")
{
List <Surveyor_SalesTax_Result> _res = Tax.Where(x => x.Name.Contains("WH_Labor_woNTN_C") || x.Name.Contains("WH_Part_woNTN_C") ||
x.Name.Contains("GST on Labour") || x.Name.Contains("WTax on GST Labor")).ToList();
plrTaxes.GstLaborRate = _res.Where(x => x.TaxName == "Lab_UnReg_Gst_RTU").FirstOrDefault() == null ? 0 : _res.Where(x => x.TaxName == "Lab_UnReg_Gst_RTU").FirstOrDefault().TaxPercentage;
plrTaxes.GstLaborTaxId = _res.Where(x => x.TaxName == "Lab_UnReg_Gst_RTU").FirstOrDefault() == null ? 0 : _res.Where(x => x.TaxName == "Lab_UnReg_Gst_RTU").FirstOrDefault().TaxId;
plrTaxes.GstLaborTaxPercentageId = _res.Where(x => x.TaxName == "Lab_UnReg_Gst_RTU").FirstOrDefault() == null ? 0 : _res.Where(x => x.TaxName == "Lab_UnReg_Gst_RTU").FirstOrDefault().TaxPercentageId;
plrTaxes.WHPartRate = Tax.Where(x => x.Name == "WH_Part_woNTN_C").FirstOrDefault() == null ? 0 : Tax.Where(x => x.Name == "WH_Part_woNTN_C").FirstOrDefault().TaxPercentage;
plrTaxes.WHTaxPartTaxId = Tax.Where(x => x.Name == "WH_woPart_woNTN_C").FirstOrDefault() == null ? 0 : Tax.Where(x => x.Name == "WH_Part_woNTN_C").FirstOrDefault().TaxId;
plrTaxes.WHPartTaxPercentageId = Tax.Where(x => x.Name == "WH_Part_woNTN_C").FirstOrDefault() == null ? 0 : Tax.Where(x => x.Name == "WH_Part_woNTN_C").FirstOrDefault().TaxPercentageId;
plrTaxes.WHLaborRate = Tax.Where(x => x.Name == "WH_Labor_woNTN_C").FirstOrDefault() == null ? 0 : Tax.Where(x => x.Name == "WH_Labor_woNTN_C").FirstOrDefault().TaxPercentage;
plrTaxes.WHTaxLaborTaxId = Tax.Where(x => x.Name == "WH_Labor_woNTN_C").FirstOrDefault() == null ? 0 : Tax.Where(x => x.Name == "WH_Labor_woNTN_C").FirstOrDefault().TaxId;
plrTaxes.WHTaxLaborPercentageId = Tax.Where(x => x.Name == "WH_Labor_woNTN_C").FirstOrDefault() == null ? 0 : Tax.Where(x => x.Name == "WH_Labor_woNTN_C").FirstOrDefault().TaxPercentageId;
plrTaxes.GstWHLaborRate = Tax.Where(x => x.TaxName == "Lab_UnReg_GstWH_RTU").FirstOrDefault() == null ? 0 : Tax.Where(x => x.TaxName == "Lab_UnReg_GstWH_RTU").FirstOrDefault().TaxPercentage;
plrTaxes.GstWHLaborTaxId = Tax.Where(x => x.TaxName == "Lab_UnReg_GstWH_RTU").FirstOrDefault() == null ? 0 : Tax.Where(x => x.TaxName == "Lab_UnReg_GstWH_RTU").FirstOrDefault().TaxId;
plrTaxes.GstWHLaborTaxPercentageId = Tax.Where(x => x.TaxName == "Lab_UnReg_GstWH_RTU").FirstOrDefault() == null ? 0 : Tax.Where(x => x.TaxName == "Lab_UnReg_GstWH_RTU").FirstOrDefault().TaxPercentageId;
}
else if (Filer == null && IsCompany == "N")
{
List <Surveyor_SalesTax_Result> _res = Tax.Where(x => x.Name.Contains("WH_Labor_woNTN_NC") || x.Name.Contains("WH_Part_woNTN_NC") || x.Name.Contains("GST on Labour") || x.Name.Contains("WTax on GST Labor")).ToList();
plrTaxes.GstLaborRate = _res.Where(x => x.TaxName == "Lab_UnReg_Gst").FirstOrDefault() == null ? 0 : _res.Where(x => x.TaxName == "Lab_UnReg_Gst").FirstOrDefault().TaxPercentage;
plrTaxes.GstLaborTaxId = _res.Where(x => x.TaxName == "Lab_UnReg_Gst").FirstOrDefault() == null ? 0 : _res.Where(x => x.TaxName == "Lab_UnReg_Gst").FirstOrDefault().TaxId;
plrTaxes.GstLaborTaxPercentageId = _res.Where(x => x.TaxName == "Lab_UnReg_Gst").FirstOrDefault() == null ? 0 : _res.Where(x => x.TaxName == "Lab_UnReg_Gst").FirstOrDefault().TaxPercentageId;
plrTaxes.WHPartRate = Tax.Where(x => x.Name == "WH_Part_woNTN_NC").FirstOrDefault() == null ? 0 : Tax.Where(x => x.Name == "WH_Part_woNTN_NC").FirstOrDefault().TaxPercentage;
plrTaxes.WHTaxPartTaxId = Tax.Where(x => x.Name == "WH_Part_woNTN_NC").FirstOrDefault() == null ? 0 : Tax.Where(x => x.Name == "WH_Part_woNTN_NC").FirstOrDefault().TaxId;
plrTaxes.WHPartTaxPercentageId = Tax.Where(x => x.Name == "WH_Part_woNTN_NC").FirstOrDefault() == null ? 0 : Tax.Where(x => x.Name == "WH_Part_woNTN_NC").FirstOrDefault().TaxPercentageId;
plrTaxes.WHLaborRate = Tax.Where(x => x.Name == "WH_Labor_woNTN_NC").FirstOrDefault() == null ? 0 : Tax.Where(x => x.Name == "WH_Labor_woNTN_NC").FirstOrDefault().TaxPercentage;
plrTaxes.WHTaxLaborTaxId = Tax.Where(x => x.Name == "WH_Labor_woNTN_NC").FirstOrDefault() == null ? 0 : Tax.Where(x => x.Name == "WH_Labor_woNTN_NC").FirstOrDefault().TaxId;
plrTaxes.WHTaxLaborPercentageId = Tax.Where(x => x.Name == "WH_Labor_woNTN_NC").FirstOrDefault() == null ? 0 : Tax.Where(x => x.Name == "WH_Labor_woNTN_NC").FirstOrDefault().TaxPercentageId;
plrTaxes.GstWHLaborRate = Tax.Where(x => x.TaxName == "Lab_UnReg_GstWH").FirstOrDefault() == null ? 0 : Tax.Where(x => x.TaxName == "Lab_UnReg_GstWH").FirstOrDefault().TaxPercentage;
plrTaxes.GstWHLaborTaxId = Tax.Where(x => x.TaxName == "Lab_UnReg_GstWH").FirstOrDefault() == null ? 0 : Tax.Where(x => x.TaxName == "Lab_UnReg_GstWH").FirstOrDefault().TaxId;
plrTaxes.GstWHLaborTaxPercentageId = Tax.Where(x => x.TaxName == "Lab_UnReg_GstWH").FirstOrDefault() == null ? 0 : Tax.Where(x => x.TaxName == "Lab_UnReg_GstWH").FirstOrDefault().TaxPercentageId;
}
}
catch (Exception ex)
{
LoggerService.LogExceptionsToDebugConsole(ex);
}
return(plrTaxes);
}