public void read(ref List<string> grpname , ref List<string> path)
{
createfile objcf = new createfile();
Excel.Application xlApp;
Excel.Workbook xlWorkBook;
Excel.Worksheet xlWorkSheet;
Excel.Range range;
object missing = System.Reflection.Missing.Value;
xlApp = new Excel.Application();
xlWorkBook = xlApp.Workbooks.Open(@"d:\database\Group.xlsx", 0, false, 5, "", "", true, Microsoft.Office.Interop.Excel.XlPlatform.xlWindows, "\t", true, true, 0, true, 1, 0);
xlWorkSheet = (Excel.Worksheet)xlWorkBook.Worksheets.get_Item(1);
range = xlWorkSheet.UsedRange;
int i = 0;
string str,str1;
for (int rCnt = 1; rCnt <= range.Rows.Count; rCnt++)
{
str = (string)(range.Cells[rCnt, 1] as Excel.Range).Value2;
str1 = (string)(range.Cells[rCnt, 2] as Excel.Range).Value2;
grpname.Add(str);
path.Add(str1);
}
xlWorkBook.Close(true, null, null);
xlApp.Quit();
objcf.releaseObject(xlWorkSheet);
objcf.releaseObject(xlWorkBook);
objcf.releaseObject(xlApp);
}
public void add(string path, string name, string phoneno,string Email,string type,string gname)
{
createfile objcf = new createfile();
Excel.Application xlApp;
Excel.Workbook xlWorkBook;
Excel.Worksheet xlWorkSheet;
Excel.Range range;
object missing = System.Reflection.Missing.Value;
xlApp = new Excel.Application();
xlWorkBook = xlApp.Workbooks.Open(path, 0, false, 5, "", "", true, Microsoft.Office.Interop.Excel.XlPlatform.xlWindows, "\t", true, true, 0, true, 1, 0);
xlWorkSheet = (Excel.Worksheet)xlWorkBook.Worksheets.get_Item(1);
range = xlWorkSheet.UsedRange;
// MessageBox.Show(_lastRow.ToString());
xlWorkSheet.Cells[range.Rows.Count+1, 1] = name;
xlWorkSheet.Cells[range.Rows.Count+1, 2] = phoneno;
xlWorkSheet.Cells[range.Rows.Count+1, 3] = Email;
xlWorkSheet.Cells[range.Rows.Count+1, 4] = type;
xlWorkSheet.Cells[range.Rows.Count+1, 5] = gname;
xlWorkBook.Save();
xlWorkBook.Close();
xlApp.Quit();
objcf.releaseObject(xlWorkSheet);
objcf.releaseObject(xlWorkBook);
objcf.releaseObject(xlApp);
}
public void update(string gname, string path)
{
createfile objcf = new createfile();
Excel.Application xlApp;
Excel.Workbook xlWorkBook;
Excel.Worksheet xlWorkSheet;
Excel.Range range;
object missing = System.Reflection.Missing.Value;
xlApp = new Excel.Application();
xlWorkBook = xlApp.Workbooks.Open(@"d:\database\Group.xlsx", 0, false, 5, "", "", true, Microsoft.Office.Interop.Excel.XlPlatform.xlWindows, "\t", true, true, 0, true, 1, 0);
xlWorkSheet = (Excel.Worksheet)xlWorkBook.Worksheets.get_Item(1);
range = xlWorkSheet.UsedRange;
xlWorkSheet.Cells[range.Rows.Count + 1, 1] = gname;
xlWorkSheet.Cells[range.Rows.Count + 1, 2] = path;
xlWorkBook.Save();
xlWorkBook.Close();
xlApp.Quit();
objcf.releaseObject(xlWorkSheet);
objcf.releaseObject(xlWorkBook);
objcf.releaseObject(xlApp);
}
public void read(ref List <string> grpname, ref List <string> path)
{
createfile objcf = new createfile();
Excel.Application xlApp;
Excel.Workbook xlWorkBook;
Excel.Worksheet xlWorkSheet;
Excel.Range range;
object missing = System.Reflection.Missing.Value;
xlApp = new Excel.Application();
xlWorkBook = xlApp.Workbooks.Open(@"d:\database\Group.xlsx", 0, false, 5, "", "", true, Microsoft.Office.Interop.Excel.XlPlatform.xlWindows, "\t", true, true, 0, true, 1, 0);
xlWorkSheet = (Excel.Worksheet)xlWorkBook.Worksheets.get_Item(1);
range = xlWorkSheet.UsedRange;
int i = 0;
string str, str1;
for (int rCnt = 1; rCnt <= range.Rows.Count; rCnt++)
{
str = (string)(range.Cells[rCnt, 1] as Excel.Range).Value2;
str1 = (string)(range.Cells[rCnt, 2] as Excel.Range).Value2;
grpname.Add(str);
path.Add(str1);
}
xlWorkBook.Close(true, null, null);
xlApp.Quit();
objcf.releaseObject(xlWorkSheet);
objcf.releaseObject(xlWorkBook);
objcf.releaseObject(xlApp);
}
public void read(string path, ref List<string> name, ref List<string> phone, ref List<string> email,ref List<string> gname)
{
createfile objcf = new createfile();
Excel.Application xlApp;
Excel.Workbook xlWorkBook;
Excel.Worksheet xlWorkSheet;
Excel.Range range;
object missing = System.Reflection.Missing.Value;
xlApp = new Excel.Application();
xlWorkBook = xlApp.Workbooks.Open(path, 0, false, 5, "", "", true, Microsoft.Office.Interop.Excel.XlPlatform.xlWindows, "\t", true, true, 0, true, 1, 0);
xlWorkSheet = (Excel.Worksheet)xlWorkBook.Worksheets.get_Item(1);
range = xlWorkSheet.UsedRange;
string str,str1,str2,str3;
for (int rCnt = 1; rCnt <= range.Rows.Count; rCnt++)
{
str = (string)(range.Cells[rCnt, 1] as Excel.Range).Value2;
str1 = (string)((range.Cells[rCnt, 2] as Excel.Range).Value2).ToString();
str2 = (string)(range.Cells[rCnt, 3] as Excel.Range).Value2;
str3 = (string)(range.Cells[rCnt, 5] as Excel.Range).Value2;
name.Add(str);
phone.Add(str1);
email.Add(str2);
gname.Add(str3);
}
xlWorkBook.Close(true, null, null);
xlApp.Quit();
objcf.releaseObject(xlWorkSheet);
objcf.releaseObject(xlWorkBook);
objcf.releaseObject(xlApp);
}
private void addmember_Click(object sender, RoutedEventArgs e)
{
addmember objaddmem = new addmember();
appendfile objappend = new appendfile();
int res= objaddmem.check(combogroup.Text,combotype.Text);
string pt;
if (combotype.Text.Equals("Student"))
{
pt = @"d:\database\Student\" + combogroup.Text + ".xlsx";
}
else
{
pt = @"d:\database\Faculty\" + combogroup.Text + ".xlsx";
}
// MessageBox.Show(pt);
// MessageBox.Show(res.ToString());
if(res==0)
{
// MessageBox.Show("file create");
createfile objcreate = new createfile();
objcreate.create(@pt, nametxt.Text, phonetxt.Text, emailtxt.Text, combotype.Text, combogroup.Text);
}
else
{
objappend.add(@pt, nametxt.Text, phonetxt.Text, emailtxt.Text, combotype.Text, combogroup.Text);
}
}
private void addmember_Click(object sender, RoutedEventArgs e)
{
addmember objaddmem = new addmember();
appendfile objappend = new appendfile();
int res = objaddmem.check(combogroup.Text, combotype.Text);
string pt;
if (combotype.Text.Equals("Student"))
{
pt = @"d:\database\Student\" + combogroup.Text + ".xlsx";
}
else
{
pt = @"d:\database\Faculty\" + combogroup.Text + ".xlsx";
}
// MessageBox.Show(pt);
// MessageBox.Show(res.ToString());
if (res == 0)
{
// MessageBox.Show("file create");
createfile objcreate = new createfile();
objcreate.create(@pt, nametxt.Text, phonetxt.Text, emailtxt.Text, combotype.Text, combogroup.Text);
}
else
{
objappend.add(@pt, nametxt.Text, phonetxt.Text, emailtxt.Text, combotype.Text, combogroup.Text);
}
}
public void update(string gname,string path)
{
createfile objcf = new createfile();
Excel.Application xlApp;
Excel.Workbook xlWorkBook;
Excel.Worksheet xlWorkSheet;
Excel.Range range;
object missing = System.Reflection.Missing.Value;
xlApp = new Excel.Application();
xlWorkBook = xlApp.Workbooks.Open(@"d:\database\Group.xlsx", 0, false, 5, "", "", true, Microsoft.Office.Interop.Excel.XlPlatform.xlWindows, "\t", true, true, 0, true, 1, 0);
xlWorkSheet = (Excel.Worksheet)xlWorkBook.Worksheets.get_Item(1);
range = xlWorkSheet.UsedRange;
xlWorkSheet.Cells[range.Rows.Count + 1, 1] = gname;
xlWorkSheet.Cells[range.Rows.Count + 1, 2] = path;
xlWorkBook.Save();
xlWorkBook.Close();
xlApp.Quit();
objcf.releaseObject(xlWorkSheet);
objcf.releaseObject(xlWorkBook);
objcf.releaseObject(xlApp);
}
public void read(string path, ref List <string> name, ref List <string> phone, ref List <string> email, ref List <string> gname)
{
createfile objcf = new createfile();
Excel.Application xlApp;
Excel.Workbook xlWorkBook;
Excel.Worksheet xlWorkSheet;
Excel.Range range;
object missing = System.Reflection.Missing.Value;
xlApp = new Excel.Application();
xlWorkBook = xlApp.Workbooks.Open(path, 0, false, 5, "", "", true, Microsoft.Office.Interop.Excel.XlPlatform.xlWindows, "\t", true, true, 0, true, 1, 0);
xlWorkSheet = (Excel.Worksheet)xlWorkBook.Worksheets.get_Item(1);
range = xlWorkSheet.UsedRange;
string str, str1, str2, str3;
for (int rCnt = 1; rCnt <= range.Rows.Count; rCnt++)
{
str = (string)(range.Cells[rCnt, 1] as Excel.Range).Value2;
str1 = (string)((range.Cells[rCnt, 2] as Excel.Range).Value2).ToString();
str2 = (string)(range.Cells[rCnt, 3] as Excel.Range).Value2;
str3 = (string)(range.Cells[rCnt, 5] as Excel.Range).Value2;
name.Add(str);
phone.Add(str1);
email.Add(str2);
gname.Add(str3);
}
xlWorkBook.Close(true, null, null);
xlApp.Quit();
objcf.releaseObject(xlWorkSheet);
objcf.releaseObject(xlWorkBook);
objcf.releaseObject(xlApp);
}
public void add(string path, string name, string phoneno, string Email, string type, string gname)
{
createfile objcf = new createfile();
Excel.Application xlApp;
Excel.Workbook xlWorkBook;
Excel.Worksheet xlWorkSheet;
Excel.Range range;
object missing = System.Reflection.Missing.Value;
xlApp = new Excel.Application();
xlWorkBook = xlApp.Workbooks.Open(path, 0, false, 5, "", "", true, Microsoft.Office.Interop.Excel.XlPlatform.xlWindows, "\t", true, true, 0, true, 1, 0);
xlWorkSheet = (Excel.Worksheet)xlWorkBook.Worksheets.get_Item(1);
range = xlWorkSheet.UsedRange;
// MessageBox.Show(_lastRow.ToString());
xlWorkSheet.Cells[range.Rows.Count + 1, 1] = name;
xlWorkSheet.Cells[range.Rows.Count + 1, 2] = phoneno;
xlWorkSheet.Cells[range.Rows.Count + 1, 3] = Email;
xlWorkSheet.Cells[range.Rows.Count + 1, 4] = type;
xlWorkSheet.Cells[range.Rows.Count + 1, 5] = gname;
xlWorkBook.Save();
xlWorkBook.Close();
xlApp.Quit();
objcf.releaseObject(xlWorkSheet);
objcf.releaseObject(xlWorkBook);
objcf.releaseObject(xlApp);
}
