public static BillReturnViewModel getBillReturnObject(string BillNo)
{
using (SqlConnection conn = new SqlConnection(GlobalClass.TConnectionString))
{
BillReturnViewModel bvm = conn.Query <BillReturnViewModel>("SELECT BILLTOPAN buyer_pan, F.FYNAME fiscal_year, BILLTO buyer_name, BillNo credit_note_number, RefBillNo ref_invoice_number, Remarks reason_for_return, RIGHT(TMiti, 4) + '.' + SUBSTRING(TMiti,4,2) + '.' + LEFT(TMiti, 2) credit_note_date, GrossAmount total_sales, TAXABLE taxable_sales_vat, NonTaxable tax_exempted_sales, VAT vat, GETDATE() dateTimeClient FROM ParkingSales PS JOIN tblFiscalYear F ON PS.FYID = F.FYID WHERE BillNo = @BillNo AND PS.FYID = @FYID", new { BillNo, GlobalClass.FYID }).FirstOrDefault();
bvm.seller_pan = CbmsTest ? "999999999" : GlobalClass.CompanyPan;
bvm.isrealtime = true;
return(bvm);
}
}
public static async Task <bool> SyncSalesReturnData(BillReturnViewModel SalesReturnModel, byte isRealTime = 0)
{
try
{
SalesReturnModel.username = username;
SalesReturnModel.password = password;
var request = (HttpWebRequest)WebRequest.Create(Url + "/billreturn");
var data = Encoding.ASCII.GetBytes(JsonConvert.SerializeObject(SalesReturnModel));
request.Method = "POST";
request.ContentType = "application/json";
request.ContentLength = data.Length;
using (var stream = (await request.GetRequestStreamAsync()))
{
stream.Write(data, 0, data.Length);
}
var response = (HttpWebResponse)await request.GetResponseAsync();
var responseString = new System.IO.StreamReader(response.GetResponseStream()).ReadToEnd();
byte status = 0;
switch (responseString)
{
case "200":
case "101":
responseString = "200 : Success [" + responseString + "]";
status = 1;
break;
case "102":
responseString = "102 : Exception while saving bill details";
status = 0;
break;
case "103":
responseString = "103 : Unknown exceptions";
status = 0;
break;
case "100":
responseString = "100 : API credentials do not match";
status = 0;
break;
case "105":
responseString = "105 : Bill does not exists";
status = 0;
break;
}
await LogSyncStatus(SalesReturnModel.credit_note_number, SalesReturnModel.fiscal_year, JsonConvert.SerializeObject(SalesReturnModel), status, responseString, isRealTime);
return(status == 1);
}
catch (WebException ex)
{
if (ex.Status == WebExceptionStatus.ProtocolError)
{
string Response = new System.IO.StreamReader(ex.Response.GetResponseStream()).ReadToEnd();
FunctionResponse res = JsonConvert.DeserializeObject <FunctionResponse>(Response);
if (res != null)
{
await LogSyncStatus(SalesReturnModel.credit_note_number, SalesReturnModel.fiscal_year, JsonConvert.SerializeObject(SalesReturnModel), 0, res.result.ToString());
}
else
{
await LogSyncStatus(SalesReturnModel.credit_note_number, SalesReturnModel.fiscal_year, JsonConvert.SerializeObject(SalesReturnModel), 0, Response);
}
}
else
{
await LogSyncStatus(SalesReturnModel.credit_note_number, SalesReturnModel.fiscal_year, JsonConvert.SerializeObject(SalesReturnModel), 0, ex.GetBaseException().Message);
}
return(false);
}
catch (Exception ex)
{
await LogSyncStatus(SalesReturnModel.credit_note_number, SalesReturnModel.fiscal_year, JsonConvert.SerializeObject(SalesReturnModel), 0, ex.GetBaseException().Message);
return(false);
}
}
public string bill()
{
var client = new HttpClient();
client.DefaultRequestHeaders.Accept.Clear();
client.DefaultRequestHeaders.Accept.Add(new MediaTypeWithQualityHeaderValue("application/json"));
BillReturnViewModel P = new BillReturnViewModel
{
username = "******",
//username = "******",
password = "******",
seller_pan = "999999999",
buyer_pan = "123456789",
buyer_name = "",
fiscal_year = "2073.074",
invoice_date = "2074.07.16",
total_sales = 20000,
vat = 1000,
excisable_amount = 0,
excise = 0,
taxable_sales_hst = 0,
hst = 0,
amount_for_esf = 0,
esf = 0,
export_sales = 0,
tax_exempted_sales = 0,
isrealtime = true,
datetimeClient = DateTime.Now
};
P.invoice_number = Console.ReadLine();
client.BaseAddress = new Uri("http://202.166.207.75:9050");
try
{
var response = client.PostAsJsonAsync("api/bill", P).Result;
if (response.IsSuccessStatusCode)
{
var result = response.Content.ReadAsStringAsync();
string c = result.Result;
switch (c)
{
case "104":
return("Model Invalid. " + c);
case "200":
return("Bill Successfully written. " + c);
case "102":
return("Exception while saving bill : Please check fields. " + c);
case "101":
return("Bill already exists! " + c);
case "100":
return("API credential Error " + c);
case "103":
return("Unknown Exception occured Server Side. " + c);
case "105":
return("Bill already exists! " + c);
default:
return("API return ID not recognized " + c);
}
}
else
{
return("Unknown Error");
}
}
catch (Exception ex) { return(Convert.ToString(ex)); Console.ReadKey(); }
}
