private void LoadDefaultData(CodeFrm.TableNames TableName)
{
switch (TableName)
{
case CodeFrm.TableNames.CDAlsofof:
repositoryItemGridLookUpEditalsofof_code.DataSource = FXFW.SqlDB.LoadDataTable(@"Select alsofof_code, alsofof_name, alsofof_name_e FROM CDAlsofof");
break;
case CodeFrm.TableNames.CDEFasl:
repositoryItemGridLookUpEditfasl_code.DataSource = FXFW.SqlDB.LoadDataTable(@"SELECT fasl_code, fasl_name, fasl_name_e FROM CDEFasl");
break;
case CodeFrm.TableNames.All:
repositoryItemGridLookUpEditalsofof_code.DataSource = FXFW.SqlDB.LoadDataTable(@"Select alsofof_code, alsofof_name, alsofof_name_e FROM CDAlsofof");
repositoryItemGridLookUpEditfasl_code.DataSource = FXFW.SqlDB.LoadDataTable(@"SELECT fasl_code, fasl_name, fasl_name_e FROM CDEFasl");
repositoryItemGridLookUpEditEmpID.DataSource = FXFW.SqlDB.LoadDataTable(@"SELECT EmpID,
ISNULL(EMP_FIRST_NAME, '') + ' ' + ISNULL(EMP_FATHER_NAME, '') + ' ' + ISNULL(EMP_FAM_NAME, '') + ' ' + ISNULL(EMP_FOURTH_NAME, '') AS emp_name
FROM TBL_Emp");
repositoryItemGridLookUpEditEmpID.DisplayMember = "emp_name";
repositoryItemGridLookUpEditEmpID.ValueMember = "EmpID";
repositoryItemGridLookUpEditSubjectId.DataSource = FXFW.SqlDB.LoadDataTable(@"SELECT SubjectId, Subject, Subject_e FROM CD_Subject");
break;
default:
break;
}
}
public void LoadCD_Asasetime()
{
foreach (DockPanel pnl in dockManagerMain.Panels)
pnl.Enabled = false;
repositoryItemLookUpEditasase_code.DataSource = FXFW.SqlDB.LoadDataTable(@"SELECT asase_code, asase_year, SPOS,
(Select SCHOOL From TBLSCHOOL Where SPOS = CD_Asasetime.SPOS) AS SCHOOL, school_allcode FROM CD_Asasetime ORDER BY asase_code DESC");
DataTable dt = (DataTable)repositoryItemLookUpEditasase_code.DataSource;
if (dt.Rows.Count == 0)
{
CodeFrm FrmCode = new CodeFrm(CodeFrm.TableNames.CD_Asasetime) { Icon = FXFW.SqlDB.MakeIcon(imageCollection32.Images["CD_Asasetime.png"], 32, false) };
FrmCode.ExitAfterSave = true;
FrmCode.ShowDialog();
}
else
{
barEditItemasase_code.EditValue = dt.Rows[0]["asase_code"];
DevExpress.XtraEditors.Controls.ButtonPredefines btn = new DevExpress.XtraEditors.Controls.ButtonPredefines();
btn = DevExpress.XtraEditors.Controls.ButtonPredefines.OK;
repositoryItemLookUpEditasase_code_ButtonClick(repositoryItemLookUpEditasase_code, new DevExpress.XtraEditors.Controls.ButtonPressedEventArgs(new DevExpress.XtraEditors.Controls.EditorButton(btn)));
}
}
private void LoadDefaultData(CodeFrm.TableNames TableName)
{
switch (TableName)
{
case CodeFrm.TableNames.CD_AgazaType:
repositoryItemGridLookUpEditagaza_type_code.DataSource = SqlDB.LoadDataTable(@"SELECT AgazaTypeId, AgazaTypeName, AgazaTypeName_e FROM CD_AgazaType");
repositoryItemGridLookUpEditagaza_type_code.DisplayMember = "AgazaTypeName";
repositoryItemGridLookUpEditagaza_type_code.ValueMember = "AgazaTypeId";
break;
case CodeFrm.TableNames.All:
//CD_Specialization
repositoryItemGridLookUpEditagaza_type_code.DataSource = SqlDB.LoadDataTable(@"SELECT AgazaTypeId, AgazaTypeName, AgazaTypeName_e FROM CD_AgazaType");
repositoryItemGridLookUpEditagaza_type_code.DisplayMember = "AgazaTypeName";
repositoryItemGridLookUpEditagaza_type_code.ValueMember = "AgazaTypeId";
//TBL_Emp
repositoryItemGridLookUpEditEmpID.DataSource = SqlDB.LoadDataTable(@"SELECT EmpID, Isnull(EMP_FIRST_NAME, '') + ' ' + Isnull(EMP_FATHER_NAME, '') + ' ' + Isnull(EMP_FAM_NAME, '') + ' ' + Isnull(EMP_FOURTH_NAME, '') AS Emp_Name FROM TBL_Emp");
repositoryItemGridLookUpEditEmpID.DisplayMember = "Emp_Name";
repositoryItemGridLookUpEditEmpID.ValueMember = "EmpID";
break;
default:
break;
}
}
private void repositoryItemGridLookUpEditagaza_type_code_ButtonClick(object sender, DevExpress.XtraEditors.Controls.ButtonPressedEventArgs e)
{
if (e.Button.Kind != DevExpress.XtraEditors.Controls.ButtonPredefines.Plus)
return;
CodeFrm FrmCode = new CodeFrm(CodeFrm.TableNames.CD_AgazaType);
FrmCode.ShowDialog();
LoadDefaultData(CodeFrm.TableNames.CD_AgazaType);
}
private void LoadDefaultData(CodeFrm.TableNames TableName)
{
switch (TableName)
{
case CodeFrm.TableNames.CDDayname:
repositoryItemGridLookUpEditdaycode.DataSource = FXFW.SqlDB.LoadDataTable(@"SELECT daycode, dayname, dayname_e FROM CDDayname");
LUEDays.Properties.DataSource = FXFW.SqlDB.LoadDataTable(@"SELECT daycode, dayname, dayname_e FROM CDDayname");
LUEDays.Properties.DisplayMember = "dayname";
LUEDays.Properties.ValueMember = "daycode";
break;
case CodeFrm.TableNames.CDAlhasas:
repositoryItemGridLookUpEdithasa_code.DataSource = FXFW.SqlDB.LoadDataTable(@"SELECT hasa_code, hasa_name, hasa_name_e FROM CDAlhasas");
break;
case CodeFrm.TableNames.All:
repositoryItemGridLookUpEditdaycode.DataSource = FXFW.SqlDB.LoadDataTable(@"SELECT daycode, dayname, dayname_e FROM CDDayname");
repositoryItemGridLookUpEdithasa_code.DataSource = FXFW.SqlDB.LoadDataTable(@"SELECT hasa_code, hasa_name, hasa_name_e FROM CDAlhasas");
LUEDays.Properties.DataSource = FXFW.SqlDB.LoadDataTable(@"SELECT daycode, dayname, dayname_e FROM CDDayname");
LUEDays.Properties.DisplayMember = "dayname";
LUEDays.Properties.ValueMember = "daycode";
repositoryItemGridLookUpEditEmpID.DataSource = FXFW.SqlDB.LoadDataTable(@"SELECT EmpID,
ISNULL(EMP_FIRST_NAME, '') + ' ' + ISNULL(EMP_FATHER_NAME, '') + ' ' + ISNULL(EMP_FAM_NAME, '') + ' ' + ISNULL(EMP_FOURTH_NAME, '') AS emp_name
FROM TBL_Emp");
repositoryItemGridLookUpEditEmpID.DisplayMember = "emp_name";
repositoryItemGridLookUpEditEmpID.ValueMember = "EmpID";
LUEEmp.Properties.DataSource = FXFW.SqlDB.LoadDataTable(@"SELECT EmpID,
ISNULL(EMP_FIRST_NAME, '') + ' ' + ISNULL(EMP_FATHER_NAME, '') + ' ' + ISNULL(EMP_FAM_NAME, '') + ' ' + ISNULL(EMP_FOURTH_NAME, '') AS emp_name
FROM TBL_Emp");
LUEEmp.Properties.DisplayMember = "emp_name";
LUEEmp.Properties.ValueMember = "EmpID";
break;
default:
break;
}
}
private void navBarItemTimeTBL_Priority_LinkClicked(object sender, NavBarLinkEventArgs e)
{
CodeFrm FrmCode = new CodeFrm(CodeFrm.TableNames.TBL_Priority) { MdiParent = this, Icon = FXFW.SqlDB.MakeIcon(imageCollection32.Images["TBL_Priority.png"], 32, false) };
FrmCode.Show();
}
private void navBarItemTimeCD_Specialization_LinkClicked(object sender, NavBarLinkEventArgs e)
{
CodeFrm FrmCode = new CodeFrm(CodeFrm.TableNames.CD_Specialization) { MdiParent = this, Icon = FXFW.SqlDB.MakeIcon(imageCollection32.Images["CD_Specialization.png"], 32, false) };
FrmCode.Show();
}
private void LoadDefaultData(CodeFrm.TableNames TableName)
{
switch (TableName)
{
case CodeFrm.TableNames.CDAlsofof:
repositoryItemGridLookUpEditalsofof_code.DataSource = FXFW.SqlDB.LoadDataTable(@"Select alsofof_code, alsofof_name, alsofof_name_e FROM CDAlsofof");
break;
case CodeFrm.TableNames.CDEFasl:
repositoryItemGridLookUpEditfasl_code.DataSource = FXFW.SqlDB.LoadDataTable(@"SELECT fasl_code, fasl_name, fasl_name_e FROM CDEFasl");
break;
case CodeFrm.TableNames.CDDayname:
repositoryItemGridLookUpEditdaycode.DataSource = FXFW.SqlDB.LoadDataTable(@"SELECT daycode, dayname, dayname_e FROM CDDayname");
break;
case CodeFrm.TableNames.CDAlhasas:
repositoryItemGridLookUpEdithasa_code.DataSource = FXFW.SqlDB.LoadDataTable(@"SELECT hasa_code, hasa_name, hasa_name_e FROM CDAlhasas");
break;
case CodeFrm.TableNames.CDPlace:
repositoryItemGridLookUpEditplacecd.DataSource = FXFW.SqlDB.LoadDataTable(@"SELECT placecd, place FROM gdw.CDPlace");
LuePlace.Properties.DataSource = FXFW.SqlDB.LoadDataTable(@"SELECT placecd, place FROM gdw.CDPlace");
LuePlaceShare.Properties.DataSource = FXFW.SqlDB.LoadDataTable(@"SELECT placecd, place FROM gdw.CDPlace");
break;
case CodeFrm.TableNames.All:
repositoryItemGridLookUpEditalsofof_code.DataSource = FXFW.SqlDB.LoadDataTable(@"Select alsofof_code, alsofof_name, alsofof_name_e FROM CDAlsofof");
repositoryItemGridLookUpEditfasl_code.DataSource = FXFW.SqlDB.LoadDataTable(@"SELECT fasl_code, fasl_name, fasl_name_e FROM CDEFasl");
repositoryItemGridLookUpEditdaycode.DataSource = FXFW.SqlDB.LoadDataTable(@"SELECT daycode, dayname, dayname_e FROM CDDayname");
repositoryItemGridLookUpEdithasa_code.DataSource = FXFW.SqlDB.LoadDataTable(@"SELECT hasa_code, hasa_name, hasa_name_e FROM CDAlhasas");
repositoryItemGridLookUpEditplacecd.DataSource = FXFW.SqlDB.LoadDataTable(@"SELECT placecd, place FROM gdw.CDPlace");
DataTable dt = FXFW.SqlDB.LoadDataTable(@"SELECT EmpID,
ISNULL(EMP_FIRST_NAME, '') + ' ' + ISNULL(EMP_FATHER_NAME, '') + ' ' + ISNULL(EMP_FAM_NAME, '') + ' ' + ISNULL(EMP_FOURTH_NAME, '') AS emp_name
FROM TBL_Emp");
LUEEmp.Properties.DataSource = dt;
repositoryItemGridLookUpEditEmpID.DataSource = dt;
repositoryItemGridLookUpEditEmpID.DisplayMember = "emp_name";
repositoryItemGridLookUpEditEmpID.ValueMember = "EmpID";
repositoryItemGridLookUpEditSubjectId.DataSource = FXFW.SqlDB.LoadDataTable(@"SELECT SubjectId, Subject, Subject_e FROM CD_Subject");
LuePlace.Properties.DataSource = FXFW.SqlDB.LoadDataTable(@"SELECT placecd, place FROM gdw.CDPlace");
LuePlaceShare.Properties.DataSource = FXFW.SqlDB.LoadDataTable(@"SELECT placecd, place FROM gdw.CDPlace");
break;
default:
break;
}
}
