public void AddGroup(object pp)
{
string Id = pp as string;
if (Id == "0")
{
if (SelectGm == null)
{
CustomDialogBox tempDB = new CustomDialogBox("Select Group", DialogType.Information);
tempDB.ShowDialog();
}
else
{
Import(null);
//if (ListOfAddGroup.Count == 0)
//{
// CustomDialogBox tempDB = new CustomDialogBox("No Data found.", DialogType.Information);
// tempDB.ShowDialog();
//}
//else
//{
// foreach (GroupDetail item in ListOfAddGroup)
// {
// if (item.IsSelect == true)
// {
// item.GroupMaster = SelectGm;
// item.GName = SelectGm.GroupName;
// item.IsSelect = false;
// }
// }
// FillAddGroup();
SelectGm = null;
CollectionViewSource.GetDefaultView(ListOfAddGroup).Refresh();
//}
}
}
else if (Id == "1")
{
if (ListOfAddGroup.Count == 0)
{
CustomDialogBox tempDB = new CustomDialogBox("No Data found.", DialogType.Information);
tempDB.ShowDialog();
}
else
{
foreach (GroupDetail item in ListOfAddGroup)
{
_Entities.Entry(item).State = EntityState.Modified;
}
_Entities.SaveChanges();
CollectionViewSource.GetDefaultView(ListOfGroupD).Refresh();
CustomDialogBox tempDB = new CustomDialogBox("Saved Successfully", DialogType.Information);
tempDB.ShowDialog();
SelectGm = null;
FillAddGroup();
FrmVis2 = "Hidden";
}
}
}
bool Cansave()
{
if (string.IsNullOrEmpty(Lable1))
{
CustomDialogBox tempDB = new CustomDialogBox("Enter Name.", DialogType.Information);
tempDB.ShowDialog();
return(false);
}
else
{
return(true);
}
}
private void btnNoPrint_Click(object sender, RoutedEventArgs e)
{
GroupDetail _Dm = dgUsers.SelectedItem as GroupDetail;
string Type = Check16.IsChecked == true ? "L16" : "L24";
if (string.IsNullOrEmpty(txtLabelNo.Text.Trim()))
{
CustomDialogBox tempDB = new CustomDialogBox("Enter LabelNo.", DialogType.Information);
tempDB.ShowDialog();
txtLabelNo.Focus();
}
else
{
//ReportWindow _ReportWindow = new ReportWindow(_Dm, txtLabelNo.Text, Type);
//_ReportWindow.Show();
//_ReportWindow.Closed += _ReportWindow_Closed;
}
}
public void Delete(object pp)
{
if (pp as string == "1")
{
if (ListOfGroupD.Where(a => a.IsCheck == true).Count() > 0)
{
ObservableCollection <GroupDetail> _GD = new ObservableCollection <GroupDetail>(ListOfGroupD.Where(w => w.IsCheck == true).ToList());
foreach (GroupDetail item in _GD)
{
item.IsDelete = true;
item.DeleteDate = DateTime.Now;
_Entities.Entry(item).State = EntityState.Modified;
_Entities.SaveChanges();
_ListOfGroupD.Remove(item);
}
CustomDialogBox tempDB = new CustomDialogBox("Successfully Delete.", DialogType.Information);
tempDB.ShowDialog();
}
else
{
CustomDialogBox tempDB = new CustomDialogBox("No Date Found.", DialogType.Information);
tempDB.ShowDialog();
}
}
else
{
GroupDetail _DD = pp as GroupDetail;
if (_DD != null)
{
CustomDialogBox tempDB = new CustomDialogBox("Are you sure ?", DialogType.Question);
bool? result = tempDB.ShowDialog();
if (result == true)
{
_DD.IsDelete = true;
_DD.DeleteDate = DateTime.Now;
_Entities.Entry(_DD).State = EntityState.Modified;
_Entities.SaveChanges();
_ListOfGroupD.Remove(_DD);
}
}
}
}
public void PrintGC(object pp)
{
if (NoLangthVis == "Visible")
{
string Id = pp as string;
if (Id == "2")
{
PrintSFrmVis = "Hidden";
NoLangthVis = "Hidden";
NoOfLable = "";
}
}
else
{
if (ListOfGroupD.Where(a => a.IsCheck == true).Count() > 0)
{
string Id = pp as string;
if (Id == "1")
{
PrintSFrmVis = "Visible";
NoLangthVis = "Hidden";
}
else if (Id == "2")
{
PrintSFrmVis = "Hidden";
NoLangthVis = "Hidden";
}
else if (Id == "3")
{
}
}
else
{
CustomDialogBox tempDB = new CustomDialogBox("No Date Found.", DialogType.Information);
tempDB.ShowDialog();
}
}
}
public void Print(object pp)
{
string type = "";
if (LableType == "Lable16")
{
type = "L16";
}
else if (LableType == "Lable24")
{
type = "L24";
}
else if (LableType == "Lable18")
{
type = "L18";
}
//PrintWindow _print = new PrintWindow(new ObservableCollection<object>(ListOfGroupD));
//_print.ShowDialog();
if (NoLangthVis == "Visible")
{
if (string.IsNullOrEmpty(LableType))
{
CustomDialogBox tempDB = new CustomDialogBox("Enter Lable.", DialogType.Information);
tempDB.ShowDialog();
}
else if (string.IsNullOrEmpty(NoOfLable))
{
CustomDialogBox tempDB = new CustomDialogBox("Enter LabelNo.", DialogType.Information);
tempDB.ShowDialog();
}
else if (string.IsNullOrEmpty(TextAlign))
{
CustomDialogBox tempDB = new CustomDialogBox("Select TextAlign.", DialogType.Information);
tempDB.ShowDialog();
}
else
{
GroupDetail _GRoupDetail = new GroupDetail();
ReportWindow _ReportWindow = new ReportWindow(PrintGD, ListOfGridSC, NoOfLable, type, TextAlign, FontStyle, FontWeight, Font);
_ReportWindow.ShowDialog();
}
}
else
{
if (ListOfGroupD.Where(a => a.IsCheck == true).Count() > 0)
{
if (string.IsNullOrEmpty(LableType))
{
CustomDialogBox tempDB = new CustomDialogBox("Enter Lable.", DialogType.Information);
tempDB.ShowDialog();
}
else if (string.IsNullOrEmpty(TextAlign))
{
CustomDialogBox tempDB = new CustomDialogBox("Select TextAlign.", DialogType.Information);
tempDB.ShowDialog();
}
else
{
ObservableCollection <GroupDetail> _GD = new ObservableCollection <GroupDetail>(ListOfGroupD.Where(w => w.IsCheck == true).ToList());
foreach (GroupDetail item in _GD)
{
item.Lable5 = item.Lable5;
}
ReportWindow _ReportWindow = new ReportWindow(ListOfGridSC, _GD, type, TextAlign, FontStyle, FontWeight, Font);
_ReportWindow.ShowDialog();
}
}
else
{
CustomDialogBox tempDB = new CustomDialogBox("No Date Found.", DialogType.Information);
tempDB.ShowDialog();
}
}
}
public void Import(object pp)
{
OpenFileDialog openFileDialog1 = new OpenFileDialog();
openFileDialog1.ShowDialog();
try
{
string strFileType;
strFileType = System.IO.Path.GetExtension(openFileDialog1.FileName).ToLower();
if (strFileType != "")
{
CustomDialogBox tempDB = new CustomDialogBox("Are you sure you want to ImportDate ?", DialogType.Question);
bool? result = tempDB.ShowDialog();
if (result == true)
{
if (strFileType != ".xlsx")
{
tempDB = new CustomDialogBox("ArePlease Select only Excel File with .xlsx Extension", DialogType.Information);
tempDB.ShowDialog();
openFileDialog1.ShowDialog();
strFileType = System.IO.Path.GetExtension(openFileDialog1.FileName).ToLower();
}
else
{
string path = openFileDialog1.FileName;
System.Data.DataTable dtExcel = new System.Data.DataTable();
dtExcel.TableName = "ImportPI";
string SourceConstr = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + path + ";Extended Properties=\"Excel 8.0;HDR=Yes;IMEX=1\"";
// string SourceConstr = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source='C:\Users\agite\Documents\Sheet1.xlsx';Extended Properties= 'Excel 8.0;HDR=Yes;IMEX=1'";
OleDbConnection con = new OleDbConnection(SourceConstr);
string query = " select Lable1,Lable2,Lable3,Lable4,Lable5,Lable6,Lable7,Lable8,Lable9,Lable10 from [Sheet1$]";
OleDbDataAdapter data = new OleDbDataAdapter(query, con);
data.Fill(dtExcel);
int res = 0;
List <GroupDetail> _GroupDetail = new List <GroupDetail>();
if (dtExcel.Rows.Count > 0)
{
foreach (DataRow row in dtExcel.Rows)
{
GroupDetail GroupDetail = new GroupDetail();
GroupDetail.GMId = SelectGm.GroupId;
GroupDetail.Lable1 = row["Lable1"].ToString();
GroupDetail.Lable2 = row["Lable2"].ToString();
GroupDetail.Lable3 = row["Lable3"].ToString();
GroupDetail.Lable4 = row["Lable4"].ToString();
GroupDetail.Lable5 = row["Lable5"].ToString();
GroupDetail.Lable6 = row["Lable6"].ToString();
GroupDetail.Lable7 = row["Lable7"].ToString();
GroupDetail.Lable8 = row["Lable8"].ToString();
GroupDetail.Lable9 = row["Lable9"].ToString();
GroupDetail.Lable10 = row["Lable10"].ToString();
GroupDetail.AddDate = DateTime.Now;
GroupDetail.IsDelete = false;
_Entities.GroupDetails.Add(GroupDetail);
_GroupDetail.Add(GroupDetail);
}
_Entities.SaveChanges();
CustomDialogBox tempDB1 = new CustomDialogBox("Imported Successfully.", DialogType.Information);
tempDB1.ShowDialog();
FillGroup();
FrmVis2 = "Hidden";
}
}
}
}
}
catch (Exception ex)
{
throw ex;
}
}
