public int insertGSTINData(string geoLocation, string gstin, string wentNotVerified, string appDateTime,
string addressStatus, string businessStatus, string registrationAccording, string other, string compounding,
string premises, string manufacturer, string turnOver, string versionName, string uploadStatus)
{
int insertId = 0;
try
{
GSTINModel tbl = new GSTINModel();
tbl.GeoLocation = geoLocation;
tbl.GSTINID = gstin;
tbl.WentNotVerified = wentNotVerified;
tbl.AppDateTime = appDateTime;
tbl.AddressStatus = addressStatus;
tbl.BusinessStatus = businessStatus;
tbl.RegistrationAccording = registrationAccording;
tbl.Other = other;
tbl.CompoundingEligible = compounding;
tbl.PremisesArea = premises;
tbl.ManufacturerOrTrader = manufacturer;
tbl.TurnOver = turnOver;
tbl.versionName = versionName;
tbl.UploadStatus = uploadStatus;
int i = db.Insert(tbl);
var data1 = db.Query <GSTINModel>("SELECT * from [GSTINModel]");
if (data1.Count > 0)
{
foreach (var val in data1)
{
insertId = val.Id;
}
}
return(insertId);
}
catch (Exception ex)
{ return(0); }
}
public async Task sendToServer()
{
List <GSTINVerFiles1> imageList = new List <GSTINVerFiles1>();
for (int i = 0; i < Utilities.imageList.Count; i++)
{
byte[] img = GetStreamFromFile(Utilities.imageList[i].ImagePath);
var url = await ic.UploadPhotoAsync(img, Utilities.imageList[i].ImagePath.Substring(Utilities.imageList[i].ImagePath.LastIndexOf("/") + 1));
if (url != null)
{
imageList.Add(new GSTINVerFiles1
{
VerFileName = url,
GeoLocation = geo.GetGeoLocation(Activity),
});
}
}
GSTINModel model = new GSTINModel();
model.GeoLocation = geo.GetGeoLocation(Activity);
model.GSTINID = GSTIN;
model.WentNotVerified = "";
model.AppDateTime = DateTime.Now.ToString("yyyy-MM-dd");
model.AddressStatus = address;
model.BusinessStatus = businessStatus;
model.RegistrationAccording = registration;
model.Other = other;
model.CompoundingEligible = compoundingEligible;
model.PremisesArea = premisesArea;
model.GSTINVerFiles = imageList;
model.ManufacturerOrTrader = combine;
model.TurnOver = turnOver;
PackageManager manager = Activity.PackageManager;
PackageInfo info = manager.GetPackageInfo(Activity.PackageName, 0);
model.versionName = info.VersionName.ToString();
string dt = JsonConvert.SerializeObject(model);
string response = "";
try
{
response = await restService.PostServiceMethod(Activity, "SetGSTINCertification", dt);
}catch (Exception ex)
{
}
if (response.Contains("Success"))
{
Toast.MakeText(Activity, "Data Submitted Successfully.", ToastLength.Long).Show();
GSTIN = "";
rg1.ClearCheck();
address = "";
rg2.ClearCheck();
businessStatus = "";
rg3.ClearCheck();
registration = "";
other = "";
otherText.Text = "";
checkValidate.Checked = false;
compoundingEligible = "";
premisesArea = "";
areaBusiness.Text = "";
turnoverText.Text = "";
Utilities.imageList.Clear();
combine = "";
turnOver = "";
submitDataVer.Enabled = true;
Manufacturer.Checked = false;
Trader.Checked = false;
ServiceDealer.Checked = false;
manuf = "";
trad = "";
dealer = "";
grid_adapter.NotifyDataSetChanged();
info.VersionName.ToString();
Utilities.GlobalBusinessList.Clear();
try
{
int i = dba.insertGSTINData(geo.GetGeoLocation(Activity), GSTIN, "", DateTime.Now.ToString("yyyy-MM-dd"),
address, businessStatus, registration, other, compoundingEligible, premisesArea,
combine, turnOver, info.VersionName.ToString(), "yes");
for (int j = 0; j < imageList.Count; j++)
{
dba.insertImageDetail(i, imageList[j].VerFileName, geo.GetGeoLocation(Activity));
}
}catch (Exception ex)
{
}
}
else
{
Toast.MakeText(Activity, "Something went wrong. Please try after sometime.", ToastLength.Long).Show();
submitDataVer.Enabled = true;
int i = dba.insertGSTINData(geo.GetGeoLocation(Activity), GSTIN, "", DateTime.Now.ToString("yyyy-MM-dd"),
address, businessStatus, registration, other, compoundingEligible, premisesArea,
combine, turnOver, info.VersionName.ToString(), "no");
for (int j = 0; j < Utilities.imageList.Count; j++)
{
dba.insertImageDetail(i, Utilities.imageList[j].ImagePath, geo.GetGeoLocation(Activity));
}
}
}
public async Task ManualSyncData()
{
try
{
List <GSTINModel> dataList = dba.getGSTINSurveyDetail("no");
if (dataList != null && dataList.Count > 0)
{
foreach (var val in dataList)
{
List <GSTINVerFiles1> imageList = new List <GSTINVerFiles1>();
int Id = val.Id;
List <GSTINVerFiles1> gstinImages = dba.getGSTINImages(Id);
for (int i = 0; i < gstinImages.Count; i++)
{
byte[] img = GetStreamFromFile(gstinImages[i].VerFileName);
var url = await ic.UploadPhotoAsync(img, gstinImages[i].VerFileName.Substring(gstinImages[i].VerFileName.LastIndexOf("/") + 1));
if (url != null)
{
imageList.Add(new GSTINVerFiles1
{
VerFileName = url,
GeoLocation = geo.GetGeoLocation(this),
});
}
}
GSTINModel model = new GSTINModel();
model.GeoLocation = val.GeoLocation;
model.GSTINID = val.GSTINID;
model.WentNotVerified = val.WentNotVerified;
model.AppDateTime = val.AppDateTime;
model.AddressStatus = val.AddressStatus;
model.BusinessStatus = val.BusinessStatus;
model.RegistrationAccording = val.RegistrationAccording;
model.Other = val.Other;
model.CompoundingEligible = val.CompoundingEligible;
model.PremisesArea = val.PremisesArea;
model.GSTINVerFiles = imageList;
model.ManufacturerOrTrader = val.ManufacturerOrTrader;
model.TurnOver = val.TurnOver;
model.versionName = val.versionName;
string dt = JsonConvert.SerializeObject(model);
string response = "";
try
{
response = await service.PostServiceMethod(this, "SetGSTINCertification", dt);
}
catch (Exception ex)
{
}
if (response.Contains("Success"))
{
trick = true;
Toast.MakeText(this, "Data Send Successfully.", ToastLength.Long).Show();
dba.updateGSTINStatus(Id);
}
}
}
}catch (Exception ex)
{
}
}
