public void UpdateProviderExcel(ProviderExcelModel model)
{
var URL = string.Format($"{AppSettings.BaseApiUrl}{ApiUrls.SearchReportApiURL.ProviderExcelUpload}");
var Content = Post <string>(URL, model);
if (Content.IsSuccessful)
{
//return Content.Model;
}
else
{
//return new List<LossRatioReportModel>();
}
}
public void SaveProviderExcelUpload(ProviderExcelModel item)
{
DataTable dt = new DataTable();
dt.TableName = "ProviderReport";
dt.Columns.Add("ClaimNumber", typeof(string));
dt.Columns.Add("InsuredName", typeof(string));
dt.Columns.Add("PolicyCode", typeof(string));
dt.Columns.Add("Provider", typeof(string));
dt.Columns.Add("Visittype", typeof(string));
dt.Columns.Add("VisitDate", typeof(string));
dt.Columns.Add("PaymentInfo", typeof(string));
dt.Columns.Add("Status", typeof(string));
dt.Columns.Add("LastModified", typeof(string));
dt.Columns.Add("ProviderNotes", typeof(string));
dt.Columns.Add("AuditorNotes", typeof(string));
dt.Columns.Add("ServiceName", typeof(string));
dt.Columns.Add("ServiceType", typeof(string));
dt.Columns.Add("Servicesubtype", typeof(string));
dt.Columns.Add("Coshareamount", typeof(string));
dt.Columns.Add("Insured", typeof(string));
dt.Columns.Add("Price", typeof(string));
dt.Columns.Add("CoShareType", typeof(string));
dt.Columns.Add("CoShare", typeof(string));
dt.Columns.Add("ServiceStatus", typeof(string));
dt.Columns.Add("Symptoms", typeof(string));
dt.Columns.Add("InsuranceCompany", typeof(string));
dt.Columns.Add("PolicyNumber", typeof(string));
//dt.Columns.Add("SubPolicy", typeof(string));
dt.Columns.Add("PaymentStatus", typeof(string));
dt.Columns.Add("PaymentDate", typeof(string));
//dt.Columns.Add("DOB", typeof(string));
//dt.Columns.Add("VisitorName", typeof(string));
//dt.Columns.Add("PaymentLastmodifiedby", typeof(string));
dt.Columns.Add("PaymentDetails", typeof(string));
//dt.Columns.Add("PaymentLastmodifiedDate", typeof(string));
dt.Columns.Add("PaymentReference", typeof(string));
DataRow row = dt.NewRow();
row["ClaimNumber"] = item.ClaimNumber;
row["InsuredName"] = item.InsuredName;
row["PolicyCode"] = item.PolicyCode;
row["Provider"] = item.Provider;
row["Visittype"] = item.Visittype;
row["VisitDate"] = DateTime.Now;//item.VisitDate;
row["PaymentInfo"] = item.PaymentInfo;
row["Status"] = item.Status;
row["LastModified"] = DateTime.Now;//item.LastModified;
row["ProviderNotes"] = item.ProviderNotes;
row["AuditorNotes"] = item.AuditorNotes;
row["ServiceName"] = item.ServiceName;
row["ServiceType"] = item.ServiceType;
row["Servicesubtype"] = item.Servicesubtype;
row["Coshareamount"] = item.Coshareamount;
row["Insured"] = item.Insured;
row["Price"] = item.Price;
row["CoShareType"] = item.CoShareType;
row["CoShare"] = item.CoShare;
row["ServiceStatus"] = item.ServiceStatus;
row["Symptoms"] = item.Symptoms;
row["InsuranceCompany"] = item.InsuranceCompany;
row["PolicyNumber"] = item.PolicyNumber;
//row["SubPolicy"] = item.SubPolicy;
row["PaymentStatus"] = item.PaymentStatus;
//row["PaymentLastmodifiedby"] = item.PaymentLastmodifiedby;
row["PaymentDate"] = item.PaymentDate;
//row["PaymentLastmodifiedDate"] = item.PaymentLastmodifiedDate;
row["PaymentDetails"] = item.PaymentDetails;
row["PaymentReference"] = DateTime.Now; //item.PaymentDate;
dt.Rows.Add(row);
var ret = QueryExecutor.Query <string>(StoreProcedures.usp_InsertProviderClaimExcelData.ToString(), new { tblProviderExcelUpload = dt }, CommandType.StoredProcedure);
}
