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(); } }