// Insert Data In FireBase DataBase ... // public async void FireBase_Insert(Employee_Receipt Employee_Receipt) { IFirebaseConfig Config = new FirebaseConfig { AuthSecret = "VH1rdiDgj2hzD0WN5JZ67BSXTN7OdOeM0fnry50G", BasePath = "https://ctm-db.firebaseio.com/" }; IFirebaseClient Client = new FireSharp.FirebaseClient(Config); var Employee_Receipt_Data = new FireBase_Employee_Receipt { Number = Employee_Receipt.Get_Number(), Book = Employee_Receipt.Get_Book(), Owner = Employee_Receipt.Get_Owner(), Date = Employee_Receipt.Get_Date(), Name = Employee_Receipt.Get_Name(), Sallary = Employee_Receipt.Get_Sallary(), Discount = Employee_Receipt.Get_Discount(), Total = Employee_Receipt.Get_Total(), Detail = Employee_Receipt.Get_Detail(), Employee_Number = Employee_Receipt.Get_Employee_Number() }; SetResponse Respose = await Client.SetTaskAsync("Employee_Receipt/" + Employee_Receipt.Get_Number(), Employee_Receipt_Data); return; }
// Read Movement Receipt Where Type From Sql Data Base ... // public List <Employee_Receipt> Sql_Select(string Employee_Number) { SqlConnection Connect = new SqlConnection(@"Server=localhost\sqlexpress; DataBase=CTM_DB; Integrated Security=true;"); SqlCommand Cmd = new SqlCommand("Select * From Employee_Receipt_Table", Connect); SqlDataReader Read; List <Employee_Receipt> Employee_Receipts = new List <Employee_Receipt>(); try { Connect.Open(); Read = Cmd.ExecuteReader(); while (Read.Read()) { if (Read["Employee_Number"].ToString() == Employee_Number) { Employee_Receipt Employee_Receipt = new Employee_Receipt(Read["Number"].ToString(), Read["Book"].ToString(), Read["Owner"].ToString(), Read["Date"].ToString(), Read["Name"].ToString(), Read["Sallary"].ToString(), Read["Discount"].ToString(), Read["Total"].ToString(), Read["Detail"].ToString(), Read["Employee_Number"].ToString()); Employee_Receipts.Add(Employee_Receipt); } } } finally { Connect.Close(); } return(Employee_Receipts); }
// Read All Employee From Sql Data Base ... // public List <Employee> Sql_Select() { SqlConnection Connect = new SqlConnection(@"Server=localhost\sqlexpress; DataBase=CTM_DB; Integrated Security=true;"); SqlCommand Cmd = new SqlCommand("Select * From Employee_Table", Connect); SqlDataReader Read; List <Employee> Employees = new List <Employee>(); try { Connect.Open(); Read = Cmd.ExecuteReader(); while (Read.Read()) { Employee_Receipt Employee_Receipt = new Employee_Receipt(); List <Employee_Receipt> Employee_Receipts = Employee_Receipt.Sql_Select(Read["Number"].ToString()); Employee Employee = new Employee(Read["Number"].ToString(), Read["Name"].ToString(), Read["Connect1"].ToString(), Read["Connect2"].ToString(), Read["Children"].ToString(), Read["Type"].ToString(), Read["Class"].ToString(), Read["Number_Hour"].ToString(), Read["Detail"].ToString(), Employee_Receipts); Employees.Add(Employee); } } finally { Connect.Close(); } return(Employees); }
// Insert Employee Receipt Into Sql DataBase ... // public void Sql_Insert(Employee_Receipt Employee_Receipt) { SqlConnection Connect = new SqlConnection(@"Server=localhost\sqlexpress; DataBase=CTM_DB; Integrated Security=true;"); SqlCommand Cmd = new SqlCommand("Insert into Employee_Receipt_Table(Number, Book, Owner, Date, Name, Sallary, Discount, Total, Detail, Employee_Number) values('" + Employee_Receipt.Number + "','" + Employee_Receipt.Book + "','" + Employee_Receipt.Owner + "','" + Employee_Receipt.Date + "','" + Employee_Receipt.Name + "','" + Employee_Receipt.Sallary + "','" + Employee_Receipt.Discount + "','" + Employee_Receipt.Total + "', '" + Employee_Receipt.Detail + "', '" + Employee_Receipt.Employee_Number + "')", Connect); try { Connect.Open(); Cmd.ExecuteNonQuery(); } finally { Connect.Close(); } return; }
// Delete Employee From Sql DataBase Using Id // public void Sql_Delete(string Employee_Number) { SqlConnection Connect = new SqlConnection(@"Server=localhost\sqlexpress; DataBase=CTM_DB; Integrated Security=true;"); SqlCommand Cmd = new SqlCommand("Delete From Employee_Table Where Number='" + Employee_Number + "'", Connect); try { Employee_Receipt Employee_Receipt = new Employee_Receipt(); Employee_Receipt.Sql_Delete(Employee_Number); Connect.Open(); Cmd.ExecuteNonQuery(); } finally { Connect.Close(); } return; }
public void Set_Employee_Receipt_Info(List <TextBox> TextBox, ref Employee_Receipt Employee_Receipt) { Employee_Receipt = new Employee_Receipt(TextBox[0].Text, TextBox[1].Text, TextBox[2].Text, TextBox[3].Text, TextBox[4].Text, TextBox[5].Text, TextBox[6].Text, TextBox[7].Text, TextBox[8].Text, ""); }
public async void Excute_Process(Process Process) { IFirebaseConfig Config = new FirebaseConfig { AuthSecret = "VH1rdiDgj2hzD0WN5JZ67BSXTN7OdOeM0fnry50G", BasePath = "https://ctm-db.firebaseio.com/" }; IFirebaseClient Client = new FireSharp.FirebaseClient(Config); if (Process.Code == "S1") { FirebaseResponse Respose = await Client.GetTaskAsync("Student/" + Process.Record_Id); FireBase_Student Data = Respose.ResultAs <FireBase_Student>(); Student Student = new Student(Data.Id, Data.First_Name, Data.Last_Name, Data.Father_Name, Data.Birth, Data.Type, Data.Connect1, Data.Connect2, Data.Class, Data.Registration, Data.School_Name, Data.Transportation, Data.City, Data.Block, Data.Street, Data.Detail, Data.Account_Number, Data.File_Number, Data.Note, Data.File_Stutus, Data.Picture); Student.Sql_Insert(Student); return; } else if (Process.Code == "S2") { Student Student = new Student(); Student.Sql_Delete(Process.Record_Id); return; } else if (Process.Code == "S3") { return; } else if (Process.Code == "R1") { FirebaseResponse Respose = await Client.GetTaskAsync("Receipt/" + Process.Record_Id); FireBase_Receipt Data = Respose.ResultAs <FireBase_Receipt>(); Receipt Receipt = new Receipt(Data.Number, Data.Book, Data.Branch, Data.Recipient, Data.First_Name, Data.Last_Name, Data.Amount_Paid, Data.Date, Data.For, Data.Account_Number); Receipt.Sql_Insert(Receipt); return; } else if (Process.Code == "R2") { Receipt Receipt = new Receipt(); Receipt.Sql_Delete(Process.Record_Id); } else if (Process.Code == "R3") { return; } else if (Process.Code == "A1") { FirebaseResponse Respose = await Client.GetTaskAsync("Account/" + Process.Record_Id); FireBase_Account Data = Respose.ResultAs <FireBase_Account>(); Respose = await Client.GetTaskAsync("Number_Account_Detail/" + "Now"); FireBase_Account_Detail_Counter Counter_Data = Respose.ResultAs <FireBase_Account_Detail_Counter>(); List <Receipt> Receipts = new List <Receipt>(); int Number_Detail = int.Parse(Counter_Data.Counter); List <Account_Detail> Detail = new List <Account_Detail>(); for (int i = 1; i < Number_Detail; i++) { Respose = await Client.GetTaskAsync("Account_Detail/" + i.ToString()); FireBase_Account_Detail Detail_Data = Respose.ResultAs <FireBase_Account_Detail>(); if (Detail_Data.Account_Id == Process.Record_Id) { Account_Detail Account_Detail = new Account_Detail(Detail_Data.Account_Id, Detail_Data.Student_Name, Detail_Data.Class, Detail_Data.Registration_Fee, Detail_Data.Study_Fee, Detail_Data.Transportaion_Fee, Detail_Data.Extra_Fee, Detail_Data.Total); Detail.Add(Account_Detail); } } Account Account = new Account(Data.Number, Data.Name, Data.Type, Data.Connect1, Data.Connect2, Data.Whats_App, Data.Total, Data.Amount_Paid, Data.Remender, Receipts, Detail); Account.Sql_Insert(Account); return; } else if (Process.Code == "A2") { Account Account = new Account(); Account.Sql_Delete(Process.Record_Id); Account_Detail Account_Detail = new Account_Detail(); Account_Detail.Sql_Delete(Process.Record_Id); return; } else if (Process.Code == "A3") { return; } else if (Process.Code == "E1") { FirebaseResponse Respose = await Client.GetTaskAsync("Employee/" + Process.Record_Id); FireBase_Employee Data = Respose.ResultAs <FireBase_Employee>(); List <Employee_Receipt> Employee_Receipt = new List <Employee_Receipt>(); Employee Employee = new Employee(Data.Number, Data.Name, Data.Connect1, Data.Connect2, Data.Children, Data.Type, Data.Class, Data.Number_Hour, Data.Detail, Employee_Receipt); Employee.Sql_Insert(Employee); return; } else if (Process.Code == "E2") { Employee Employee = new Employee(); Employee.Sql_Delete(Process.Record_Id); return; } else if (Process.Code == "E3") { return; } else if (Process.Code == "SA1") { FirebaseResponse Respose = await Client.GetTaskAsync("Employee_Receipt/" + Process.Record_Id); FireBase_Employee_Receipt Data = Respose.ResultAs <FireBase_Employee_Receipt>(); Employee_Receipt Employee_Receipt = new Employee_Receipt(Data.Number, Data.Book, Data.Owner, Data.Date, Data.Name, Data.Sallary, Data.Discount, Data.Total, Data.Detail, Data.Employee_Number); Employee_Receipt.Sql_Insert(Employee_Receipt); return; } else if (Process.Code == "SA2") { return; } else if (Process.Code == "SA3") { return; } else if (Process.Code == "MR1") { FirebaseResponse Respose = await Client.GetTaskAsync("Movement_Receipt/" + Process.Record_Id); FireBase_Movement_Receipt Data = Respose.ResultAs <FireBase_Movement_Receipt>(); Movement_Receipt Movement_Receipt = new Movement_Receipt(Data.Number, Data.Book, Data.Type, Data.Owner, Data.Kind, Data.Amount, Data.Date, Data.Detail); Movement_Receipt.Sql_Insert(Movement_Receipt); return; } else if (Process.Code == "MR2") { return; } else if (Process.Code == "MR3") { return; } }