private DataTable GetClaimUIDForClaim(List <string> ClaimList)
{
Billback.DataLayer.Billback obj = new Billback.DataLayer.Billback();
DataTable dt = obj.GetClaimInfoPRD(ClaimList);
return(dt);
}
private string GetClaimUIDForClaimClientID(string Claim, string ClientID)
{
Billback.DataLayer.Billback obj = new Billback.DataLayer.Billback();
List <string> ClaimList = new List <string>();
ClaimList.Add(Claim);
DataTable dt = obj.GetClaimInfoPRD(ClaimList);
string ClaimUID = "";
foreach (DataRow dr in dt.Rows)
{
if (dr["CLIENT_ID"].ToString() == ClientID)
{
ClaimUID = dr["CLAIM_UID"].ToString();
}
}
return(ClaimUID);
}
public void ProcessRequest(HttpContext context)
{
string strClientID = context.Request["term"] ?? ""; //return context.Request["term"] if it's not null otherwise return ""
List <string> listClients = new List <string>();
string strExMsg = "";
DataLayer.Billback obj = new DataLayer.Billback();
DataTable dtClients = obj.SearchClientData_By_ID_SP(strClientID, 0, out strExMsg);
foreach (DataRow dr in dtClients.Rows)
{
listClients.Add(dr["CONT_NUM"].ToString());
}
JavaScriptSerializer js = new JavaScriptSerializer();
context.Response.Write(js.Serialize(listClients));
}
private void CreateBillbackIntFile()
{
//Create Billback file in pipe delimitted format
// LoadFileFormatData();
strDate = DateTime.Now.ToString("yyyMMdd_HHmmss");
string sHDRLine = CreateHDRLine();
string[] sPMTLine = new string[dtClaimSearchData.Rows.Count];
string sTRLLine = CreateTRLLine();
int rownum = 0;
//loop through each row in dtClaimSearchData
string state = "";
//get Tax ID, Tax Sub ID from DB
Billback obj = new Billback();
string exMessage = "";
DataTable dt = obj.GetPayCodeLogic(this.ServiceType, out exMessage);
string TaxID = "****NEED TAX-ID***";
string TaxSubID = "****NEED TAX-SUB-ID***";
if (dt.Rows.Count > 0)
{
TaxID = dt.Rows[0]["TAXID"].ToString();
TaxSubID = dt.Rows[0]["TAXSUBID"].ToString();
}
foreach (DataRow row in dtClaimSearchData.Rows)
{
sPMTLine[rownum] = CreatePMTLine(row, TaxID, TaxSubID);
rownum++;
}
CreatePipeFile(sHDRLine, sPMTLine, sTRLLine);
// System.Diagnostics.Process.Start("explorer", @"c:\\");
}