public void dete()
{
Network_App.LibraryWords library = new Network_App.LibraryWords();
Network_App.DataSql DataSql = new Network_App.DataSql();
DataSql.process(library.File(2), library.DELETE(1), DataSql_Parameters(text));
}
public void Uplod(string[] eb)
{
DataSql = new DataSql();
// DataSql.close();
DataSql.process(library.File(2), library.Upload(), DataSql_Parameters(eb));
}
public void remove(string eb)
{
DataSql = new DataSql();
// DataSql.close();
DataSql.process(library.File(2), library.DELETE(1), DataSql_Parameters(eb));
}
public List <int> Retdatainger(int row, int table) //retturn int
{
// DataSql.datainger.Clear();
DataSql dataSql = new DataSql();
List <int> Data = new List <int>();
// data();
dataSql.Rowdata(row);
dataSql.lop = "int";
dataSql.process(library.File(2), library.SELECT(table), null);
Data = dataSql.return_Intger();
return(Data);
}
void alertsure(string mess)
{
Action <UIAlertAction> okaction = null;
Action <UIAlertAction> Cancelaction = null;
switch (mess)
{
case "Save": { okaction = (UIAlertAction => { saveFilesGarelly(); });
Cancelaction = (UIAlertAction => {
// Nettab.bar.changebuttonclick();
ViewDidLoad();
}); } break;
case "Delete All": { okaction = (UIAlertAction => {
DataSql.process(library.File(2), library.detleteAll(), null);
ViewDidLoad();
_Select = false;
});//end
Cancelaction = (UIAlertAction => { _Select = false; }); } break;
case "Delete": { okaction = (UIAlertAction => { DeleteSection(); });
Cancelaction = (UIAlertAction => {
// Nettab.bar.changebuttonclick();
ViewDidLoad();
}); } break;
}
var alert = UIAlertController.Create(string.Empty, "are you sure" + " " + mess, UIAlertControllerStyle.Alert);
var ok = UIAlertAction.Create("Ok", UIAlertActionStyle.Default, okaction);
var Cancel = UIAlertAction.Create("Cancel", UIAlertActionStyle.Cancel, Cancelaction);
alert.AddAction(ok);
alert.AddAction(Cancel);
PresentViewController(alert, true, null);
} //messgebox ask are you sure
public List <byte[]> retDataByet(int row, int table) //retturn byet
{
DataSql.databyet.Clear();
List <byte[]> Data = new List <byte[]>();
DataSql dataSql = new DataSql();
// data();
dataSql.Rowdata(row);
dataSql.lop = "byte";
// DataSql dataSql = new DataSql();
dataSql.process(library.File(2), library.SELECT(table), null);
Data = dataSql.return_byet();
return(Data);
}
public List <string> retDataString(int row, int table) //retturn string
{
List <string> Datastring = new List <string>();
// data();
DataSql dataSql = new DataSql();
// DataSql.data.Clear();
dataSql.Rowdata(row);
dataSql.lop = "string";
// DataSql dataSql = new DataSql();
dataSql.process(library.File(2), library.SELECT(table), null);
Datastring = dataSql.return_string();
return(Datastring);
}
void todatabese()
{
List <byte[]> Imagebyeds = new List <byte[]>();
List <string> strimg = new List <string>();
foreach (UIImage image1 in Imagedata)
{
DataSql = new DataSql();
Byte[] myByteArray;
using (NSData imageData = image1.AsPNG())
{
myByteArray = new Byte[imageData.Length];
System.Runtime.InteropServices.Marshal.Copy(imageData.Bytes, myByteArray, 0, Convert.ToInt32(imageData.Length));
}
string random = GeneratePassword(7);
Imagebyeds.Add(myByteArray);
strimg.Add(random);
DataSql.process(library.File(2), library.INSERT(2), DataSql_Parameters(random, myByteArray, "jpg/png"));
}
foreach (string stringUrl in UrlVideoString)
{
DataSql = new DataSql();
byte[] myByteArray;
using (NSData data = NSData.FromUrl(NSUrl.FromString(stringUrl)))
{
myByteArray = new byte[data.Length];
System.Runtime.InteropServices.Marshal.Copy(data.Bytes, myByteArray, 0, Convert.ToInt32(data.Length));
}
string random = GeneratePassword(7);
// this.Title = videoUrl.ToString(); ;
DataSql.process(library.File(2), library.INSERT(2), DataSql_Parameters(random, myByteArray, "mov"));
}
reload();
//cal.addbutton(Imagebyeds, strimg);
// Imagebyeds.Clear();
// strimg.Clear();
UrlVideoString.Clear();
Imagedata.Clear();
}
private void Btn_Clicked(object sender, int d)
{
UITextField field = new UITextField();
UITextField field2 = new UITextField();
if (d == 0)
{
//throw new NotImplementedException();
var messbox = UIAlertController.Create(library.Messages(0), string.Empty, UIAlertControllerStyle.Alert);
messbox.View.BackgroundColor = UIColor.White;
// UITextField field = null;
// UITextField field2 = null;
messbox.AddTextField((textField1) =>
{
field = textField1;
//field.Text = "5564";
// field.Text = "";
// Initialize field
// field.Placeholder = placeholder;
field.Placeholder = library.Messages(0);
// field.BackgroundColor = UIColor.Yellow;
// field.Layer.BorderColor = UIColor.Gray.CGColor;
field.Font = library.Font();
field.Layer.BorderWidth = 1;
// field.Layer.CornerRadius = 20;
// field = new UITextField(new CoreGraphics.CGRect(10, 60, 300, 60));
// field.SecureTextEntry = true;
});
var frame = new CGRect(40, 40, 300, 60);
messbox.AddTextField((text) =>
{
field2 = text;
txtport = text.Text;
field2.Frame = frame;
// field2.Placeholder = "100";
// field2.KeyboardType = UIKeyboardType.Default;
// field2 = new UITextField(new CoreGraphics.CGRect(10, 40, 30, 10));
// field2.Layer.BackgroundColor = UIColor.Red.CGColor;
field2.Layer.BorderWidth = 1;
field2.Font = library.Font();
field2.Text = 9.ToString();
// field.Layer.CornerRadius = 40;
// field2.SecureTextEntry = true;
});
//Add Actions
var cancelAction = UIAlertAction.Create(library.StrForm(4), UIAlertActionStyle.Cancel, alertAction => { });
var okayAction = UIAlertAction.Create(library.StrForm(3), UIAlertActionStyle.Default, alertAction => {
int j;
if (Int32.TryParse(field2.Text, out j))
{
txt = field.Text;
txtport = field2.Text;
// field.Text = txt;
DataSql dataSql = new DataSql();
dataSql.process(library.File(2), library.INSERT(1), DataSql_Parameters());
//listdns.Add(field.Text);
Sourcetabview();
}
else
{
var armAlert = UIAlertController.Create(library.ErorMessages(0), string.Empty, UIAlertControllerStyle.Alert);
var cancelAction1 = UIAlertAction.Create(library.StrForm(3), UIAlertActionStyle.Cancel, alertAction1 => { });
armAlert.AddAction(cancelAction1);
PresentViewController(armAlert, true, null);
}
// tabview.InsertRows(new NSIndexPath[] { }, UITableViewRowAnimation.Fade);
});
messbox.AddAction(cancelAction);
messbox.AddAction(okayAction);
//Present Alert
PresentViewController(messbox, true, null);
}
}
public void Delete_all()
{
DataSql.process(library.File(2), library.detleteAll(), null);
}