private void btnCancel_Click(object sender, EventArgs e)
{
gridControl1.Enabled = true;
En = EnumCED.Cancel;
HelpClass1.ActiveButtons(panelControl2);
HelpClass1.ClearControls(panelControl1);
HelpClass1.InActiveControls(panelControl1);
btnDelete.Enabled = btnEdit.Enabled = btnLast.Enabled = btnNext.Enabled = btnPreview.Enabled = btnFirst.Enabled = false;
btnCreate.Focus();
}
private void btnCreate_Click(object sender, EventArgs e)
{
if (btnCreate.Enabled)
{
En = EnumCED.Create;
gridControl1.Enabled = false;
HelpClass1.InActiveButtons(panelControl2);
HelpClass1.ClearControls(panelControl1);
HelpClass1.ActiveControls(panelControl1);
txtName.Focus();
}
}
private void btnCreate_Click(object sender, EventArgs e)
{
if (btnCreate.Visible)
{
En = EnumCED.Create;
gridControl1.Enabled = false;
HelpClass1.InActiveButtons(panelControl2);
HelpClass1.ClearControls(xtraTabPage1);
HelpClass1.ActiveControls(xtraTabPage1);
btnNewCode_Click(null, null);
txtName.Focus();
}
}
private void btnCreate_Click(object sender, EventArgs e)
{
if (btnCreate.Visible)
{
En = EnumCED.Create;
gridControl1.Enabled = false;
FillcmbMajmoehaList();
HelpClass1.InActiveButtons(panelControl2);
HelpClass1.ClearControls(xtraTabPage1);
HelpClass1.ActiveControls(xtraTabPage1);
// txtCode.ReadOnly = true;
// xtraTabControl1.SelectedTabPageIndex = 0;
cmbMajmoehaList.Focus();
}
}
private void btnEdit_Click(object sender, EventArgs e)
{
if (btnEdit.Enabled)
{
if (gridView1.RowCount > 0)
{
gridControl1.Enabled = false;
EditRowIndex = gridView1.FocusedRowHandle;
En = EnumCED.Edit;
HelpClass1.InActiveButtons(panelControl2);
HelpClass1.ActiveControls(panelControl1);
txtId.Text = gridView1.GetFocusedRowCellValue("Id").ToString();
txtName.Text = gridView1.GetFocusedRowCellValue("Name").ToString();
txtName.Focus();
}
}
}
private void btnEdit_Click(object sender, EventArgs e)
{
if (btnEdit.Visible)
{
if (gridView1.RowCount > 0)
{
gridControl1.Enabled = false;
EditRowIndex = gridView1.FocusedRowHandle;
En = EnumCED.Edit;
HelpClass1.InActiveButtons(panelControl2);
HelpClass1.ActiveControls(xtraTabPage1);
// xtraTabControl1.SelectedTabPageIndex = 0;
txtId.Text = gridView1.GetFocusedRowCellValue("MsUserId").ToString();
txtCode.Text = gridView1.GetFocusedRowCellValue("UserCode").ToString();
txtName.Text = gridView1.GetFocusedRowCellValue("Name").ToString();
txtShenase.Text = gridView1.GetFocusedRowCellValue("Shenase").ToString();
txtPassword.Text = gridView1.GetFocusedRowCellValue("Password").ToString();
chkIsActive.Checked = Convert.ToBoolean(gridView1.GetFocusedRowCellValue("UserIsActive"));
if (txtName.Text == "مدیر سیستم")
{
chkEditCode.Enabled = false;
txtName.Enabled = false;
chkIsActive.Enabled = false;
labelControl5.Enabled = false;
}
else
{
chkEditCode.Enabled = true;
txtName.Enabled = true;
chkIsActive.Enabled = true;
labelControl5.Enabled = true;
}
CodeBeforeEdit = txtCode.Text;
NameBeforeEdit = txtName.Text;
ShenaseBeforEdit = txtShenase.Text;
IsActiveBeforeEdit = chkIsActive.Checked;
txtName.Focus();
}
}
}
private void btnEdit_Click(object sender, EventArgs e)
{
if (btnEdit.Visible)
{
if (gridView1.RowCount > 0)
{
gridControl1.Enabled = false;
EditRowIndex = gridView1.FocusedRowHandle;
En = EnumCED.Edit;
HelpClass1.InActiveButtons(panelControl2);
HelpClass1.ActiveControls(xtraTabPage1);
FillcmbMajmoehaList();
// xtraTabControl1.SelectedTabPageIndex = 0;
cmbMajmoehaList.EditValue = Convert.ToInt32(gridView1.GetFocusedRowCellValue("MsMajmoeId").ToString());
cmbVahedhaList.EditValue = Convert.ToInt32(gridView1.GetFocusedRowCellValue("MsVahedId").ToString());
cmbShobeList.EditValue = Convert.ToInt32(gridView1.GetFocusedRowCellValue("MsShobeId").ToString());
txtShobeCode.Text = gridView1.GetFocusedRowCellValue("DoreMaliCode").ToString().Substring(0, 6);
txtId.Text = gridView1.GetFocusedRowCellValue("MsDoreMaliId").ToString();
txtCode.Text = gridView1.GetFocusedRowCellValue("DoreMaliCode").ToString().Substring(6);
txtDoreMali.Text = gridView1.GetFocusedRowCellValue("DoreMali").ToString();
txtStartDore.EditValue = gridView1.GetFocusedRowCellValue("StartDoreMali").ToString().Substring(0, 10);
txtEndDore.EditValue = gridView1.GetFocusedRowCellValue("EndDoreMali").ToString().Substring(0, 10);
chkIsActive.Checked = Convert.ToBoolean(gridView1.GetFocusedRowCellValue("DoreMaliIsActive"));
chkDoreIsClose.Checked = Convert.ToBoolean(gridView1.GetFocusedRowCellValue("DoreIsClose"));
txtMaliat.Text = gridView1.GetFocusedRowCellValue("Maliat").ToString();
txtAvarez.Text = gridView1.GetFocusedRowCellValue("Avarez").ToString();
txtDoreMali.ReadOnly = false;
MajmoeIdBeforeEdit = Convert.ToInt32(cmbMajmoehaList.EditValue);
VahedIdBeforeEdit = Convert.ToInt32(cmbVahedhaList.EditValue);
ShobeIdBeforeEdit = Convert.ToInt32(cmbShobeList.EditValue);
CodeBeforeEdit = txtCode.Text;
NameBeforeEdit = txtDoreMali.Text;
IsActiveBeforeEdit = chkIsActive.Checked;
// txtCode.ReadOnly = true;
cmbMajmoehaList.Focus();
}
}
}
private void btnSave_Click(object sender, EventArgs e)
{
if (btnSave.Enabled)
{
_SalId = Convert.ToInt32(lblSalId.Text);
if (TextEditValidation())
{
if (En == EnumCED.Create)
{
using (var db = new MyContext())
{
try
{
EpNameShahrstan obj = new EpNameShahrstan();
obj.SalId = _SalId;
obj.Code = db.EpNameShahrstans.Any() ? db.EpNameShahrstans.Max(s => s.Code) + 1 : 1;
obj.Name = txtName.Text;
obj.NameOstan = cmbNameOstan.Text;
obj.NameOstanId = Convert.ToInt32(cmbNameOstan.EditValue);
db.EpNameShahrstans.Add(obj);
db.SaveChanges();
/////////////////////////////////////////////////////////////////////////////////////
//int _Code = Convert.ToInt32(txtCodeGroupTafsiliSandogh.Text + txtCode.Text);
//var q = db.EpAdressNames.FirstOrDefault(s => s.Code == _Code);
//////////////////////////////////////// اضافه کردن حساب کل به کلاس سطح دسترسی کدینگ حسابداری ////////////////////
//EpAllCodingHesabdari n1 = new EpAllCodingHesabdari();
//n1.KeyId = _Code;
//n1.ParentId = Convert.ToInt32(txtGroupCode.Text);
//n1.LevelName = txtName.Text;
//n1.HesabGroupId = q.GroupId;
//n1.HesabColId = q.Id;
//n1.IsActive = chkIsActive.Checked;
//db.EpAllCodingHesabdaris.Add(n1);
///////////////////////////////////////////////////////////////////////////////////////
//db.SaveChanges();
btnDisplyActiveList_Click(null, null);
//XtraMessageBox.Show("عملیات ایجاد با موفقیت انجام شد", "پیغام", MessageBoxButtons.OK, MessageBoxIcon.Information); ;
btnLast_Click(null, null);
btnCancel_Click(null, null);
En = EnumCED.Save;
}
catch (Exception ex)
{
XtraMessageBox.Show("عملیات با خطا مواجه شد" + "\n" + ex.Message, "پیغام", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
else if (En == EnumCED.Edit)
{
using (var db = new MyContext())
{
try
{
string _Name = txtName.Text;
int RowId = Convert.ToInt32(txtId.Text);
var q = db.EpNameShahrstans.FirstOrDefault(p => p.Id == RowId);
if (q != null)
{
q.Name = txtName.Text;
q.NameOstan = cmbNameOstan.Text;
q.NameOstanId = Convert.ToInt32(cmbNameOstan.EditValue);
/////////////////////////////////متد اصلاح کد و نام در لیست حساب معین WillCascadeOnUpdate ///////////////////////
/////////////////////////////// WillCascadeOnUpdate : EpHesabMoins /////////////////////////
//var q6 = db.EpHesabMoins.Where(s => s.ColId == RowId).ToList();
//if (q6.Count > 0)
//{
// q6.ForEach(item =>
// {
// if (CodeBeforeEdit != txtCode.Text)
// item.Code = Convert.ToInt32(item.Code.ToString().Substring(0, 2).Replace(item.Code.ToString().Substring(0, 2), _Code.ToString())
// + item.Code.ToString().Substring(2));
// if (NameBeforeEdit != txtName.Text)
// item.ColName = txtName.Text;
// if (IsActiveBeforeEdit != chkIsActive.Checked)
// item.IsActive = chkIsActive.Checked;
// });
//}
/////////////////////////////////متد اصلاح کد و نام در لیست سطح دسترسی به کدینگ حسابداری WillCascadeOnUpdate ///////////////////////
//var q8 = db.EpAllCodingHesabdaris.Where(s => s.HesabColId == RowId).ToList();
//if (q8.Count > 0)
//{
// q8.ForEach(item =>
// {
// if (item.HesabMoinId == 0)
// {
// if (GroupIdBeforeEdit != Convert.ToInt32(cmbListHesabGroup.EditValue) || CodeBeforeEdit != txtCode.Text)
// item.KeyId = Convert.ToInt32(txtGroupCode.Text + txtCode.Text);
// if (GroupIdBeforeEdit != Convert.ToInt32(cmbListHesabGroup.EditValue))
// item.ParentId = Convert.ToInt32(txtGroupCode.Text);
// if (NameBeforeEdit != txtName.Text)
// item.LevelName = txtName.Text;
// if (GroupIdBeforeEdit != Convert.ToInt32(cmbListHesabGroup.EditValue))
// item.HesabGroupId = _GroupId;
// if (IsActiveBeforeEdit != chkIsActive.Checked)
// item.IsActive = chkIsActive.Checked;
// }
// else
// {
// if (GroupIdBeforeEdit != Convert.ToInt32(cmbListHesabGroup.EditValue) || CodeBeforeEdit != txtCode.Text)
// item.KeyId = Convert.ToInt32(item.KeyId.ToString().Substring(0, 2).Replace(item.KeyId.ToString().Substring(0, 2), _Code.ToString())
// + item.KeyId.ToString().Substring(2));
// if (GroupIdBeforeEdit != Convert.ToInt32(cmbListHesabGroup.EditValue) || CodeBeforeEdit != txtCode.Text)
// item.ParentId = Convert.ToInt32(item.ParentId.ToString().Substring(0, 2).Replace(item.ParentId.ToString().Substring(0, 2), _Code.ToString())
// + item.ParentId.ToString().Substring(2));
// if (GroupIdBeforeEdit != Convert.ToInt32(cmbListHesabGroup.EditValue))
// item.HesabGroupId = _GroupId;
// if (IsActiveBeforeEdit != chkIsActive.Checked)
// item.IsActive = chkIsActive.Checked;
// }
// });
//}
///////////////////////////////////////////متد اصلاح کد و نام در جدول رابطه بین کاربران و لیست سطح دسترسی به کدینگ حسابداری WillCascadeOnUpdate//////////////////////////////////////
//var q9 = db.RmsUserBallCodingHesabdaris.Where(s => s.HesabColId == RowId).ToList();
//if (q9.Count > 0)
//{
// q9.ForEach(item =>
// {
// if (GroupIdBeforeEdit != Convert.ToInt32(cmbListHesabGroup.EditValue) || CodeBeforeEdit != txtCode.Text)
// item.KeyId = Convert.ToInt32(item.KeyId.ToString().Substring(0, 2).Replace(item.KeyId.ToString().Substring(0, 2), _Code.ToString())
// + item.KeyId.ToString().Substring(2));
// if (GroupIdBeforeEdit != Convert.ToInt32(cmbListHesabGroup.EditValue))
// item.HesabGroupId = _GroupId;
// if (IsActiveBeforeEdit != chkIsActive.Checked)
// item.IsActive = chkIsActive.Checked;
// });
//}
////////////////////////////////////////////////////////////////////////////////////////
//if (IsActiveBeforeEdit == false && chkIsActive.Checked == true)
//{
// var m = db.EpHesabGroups.FirstOrDefault(p => p.Id == _GroupId);
// var a1 = db.EpAllCodingHesabdaris.FirstOrDefault(p => p.HesabGroupId == _GroupId && p.HesabColId == 0);
// //var a2 = db.EpAllCodingHesabdaris.FirstOrDefault(p => p.HesabGroupId == _GroupId && p.HesabColId == RowId && p.HesabMoinId == 0);
// var b1 = db.RmsUserBallCodingHesabdaris.FirstOrDefault(p => p.HesabGroupId == _GroupId && p.HesabColId == 0);
// //var b2 = db.RmsUserBallCodingHesabdaris.FirstOrDefault(p => p.HesabGroupId == _GroupId && p.HesabColId == RowId && p.HesabMoinId == 0);
// if (m != null)
// m.IsActive = true;
// if (a1 != null)
// a1.IsActive = true;
// //if (a2 != null)
// // a2.IsActive = true;
// if (b1 != null)
// b1.IsActive = true;
// //if (b2 != null)
// // b2.IsActive = true;
//}
db.SaveChanges();
btnDisplyActiveList_Click(null, null);
//XtraMessageBox.Show("عملیات ویرایش با موفقیت انجام شد", "پیغام", MessageBoxButtons.OK, MessageBoxIcon.Information); ;
if (gridView1.RowCount > 0)
{
gridView1.FocusedRowHandle = EditRowIndex;
}
btnCancel_Click(null, null);
En = EnumCED.Save;
}
else
{
XtraMessageBox.Show("رکورد جاری در بانک اطلاعاتی موجود نیست", "پیغام", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
catch (Exception ex)
{
XtraMessageBox.Show("عملیات با خطا مواجه شد" + "\n" + ex.Message, "پیغام", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
}
}
}
private void btnSave_Click(object sender, EventArgs e)
{
if (btnSave.Enabled)
{
if (TextEditValidation())
{
if (En == EnumCED.Create)
{
using (var db = new MyContext())
{
try
{
MsDoreMali obj = new MsDoreMali();
obj.DoreMaliCode = Convert.ToInt32(txtShobeCode.Text + txtCode.Text);
obj.DoreMali = Convert.ToInt32(txtDoreMali.Text);
obj.StartDoreMali = Convert.ToDateTime(txtStartDore.Text);
obj.EndDoreMali = Convert.ToDateTime(txtEndDore.Text);
obj.MsMajmoeId = Convert.ToInt32(cmbMajmoehaList.EditValue);
obj.MajmoeName = cmbMajmoehaList.Text;
obj.MsVahedId = Convert.ToInt32(cmbVahedhaList.EditValue);
obj.VahedName = cmbVahedhaList.Text;
obj.MsShobeId = Convert.ToInt32(cmbShobeList.EditValue);
obj.ShobeName = cmbShobeList.Text;
obj.DoreMaliIsActive = chkIsActive.Checked;
obj.DoreIsClose = chkDoreIsClose.Checked;
obj.Maliat = Convert.ToSingle(txtMaliat.Text.Replace('/', '.') != "" ? txtMaliat.Text.Replace('/', '.') : "0");
obj.Avarez = Convert.ToSingle(txtAvarez.Text.Replace('/', '.') != "" ? txtAvarez.Text.Replace('/', '.') : "0");
db.MsDoreMalis.Add(obj);
db.SaveChanges();
////////////////////////////////////// اضافه کردن دوره های مالی به کلاس سطح دسترسی دفاتر مالی ////////////////////
int _code = Convert.ToInt32(txtShobeCode.Text + txtCode.Text);
var q = db.MsDoreMalis.FirstOrDefault(s => s.DoreMaliCode == _code);
MsAccessLevelDafaterMali n1 = new MsAccessLevelDafaterMali();
n1.KeyId = _code;
n1.ParentId = Convert.ToInt32(_code.ToString().Substring(0, 6));
n1.LevelName = txtDoreMali.Text;
n1.MajmoeId = q.MsMajmoeId;
n1.VahedId = q.MsVahedId;
n1.ShobeId = q.MsShobeId;
n1.DoreMaliId = q.MsDoreMaliId;
n1.IsActive = chkIsActive.Checked;
db.MsAccessLevelDafaterMalis.Add(n1);
db.SaveChanges();
/////////////////////////////////////////////////////////////////////////////////////
if (chkIsActive.Checked)
{
btnDisplyActiveList_Click(null, null);
}
else
{
btnDisplyNotActiveList_Click(null, null);
}
//XtraMessageBox.Show("عملیات باموفقیت انجام شد", "پیغام", MessageBoxButtons.OK, MessageBoxIcon.Information); ;
btnLast_Click(null, null);
En = EnumCED.Save;
btnCancel_Click(null, null);
}
catch (Exception ex)
{
XtraMessageBox.Show("عملیات با خطا مواجه شد" + "\n" + ex.Message, "پیغام", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
else if (En == EnumCED.Edit)
{
using (var db = new MyContext())
{
try
{
int RowId = Convert.ToInt32(txtId.Text);
var q = db.MsDoreMalis.FirstOrDefault(p => p.MsDoreMaliId == RowId);
if (q != null)
{
q.DoreMaliCode = Convert.ToInt32(txtShobeCode.Text + txtCode.Text);
q.DoreMali = Convert.ToInt32(txtDoreMali.Text);
q.StartDoreMali = Convert.ToDateTime(txtStartDore.Text);
q.EndDoreMali = Convert.ToDateTime(txtEndDore.Text);
q.MsMajmoeId = Convert.ToInt32(cmbMajmoehaList.EditValue);
q.MajmoeName = cmbMajmoehaList.Text;
q.MsVahedId = Convert.ToInt32(cmbVahedhaList.EditValue);
q.VahedName = cmbVahedhaList.Text;
q.MsShobeId = Convert.ToInt32(cmbShobeList.EditValue);
q.ShobeName = cmbShobeList.Text;
q.DoreMaliIsActive = chkIsActive.Checked;
q.DoreIsClose = chkDoreIsClose.Checked;
q.Maliat = Convert.ToSingle(txtMaliat.Text.Replace('/', '.') != "" ? txtMaliat.Text.Replace('/', '.') : "0");
q.Avarez = Convert.ToSingle(txtAvarez.Text.Replace('/', '.') != "" ? txtAvarez.Text.Replace('/', '.') : "0");
/////////////////////////////متد اصلاح کد و نام در لیست سطح دسترسی به دفاتر مالی WillCascadeOnUpdate ///////////////////////
var q8 = db.MsAccessLevelDafaterMalis.FirstOrDefault(s => s.DoreMaliId == RowId);
if (MajmoeIdBeforeEdit != Convert.ToInt32(cmbMajmoehaList.EditValue) || VahedIdBeforeEdit != Convert.ToInt32(cmbVahedhaList.EditValue) || ShobeIdBeforeEdit != Convert.ToInt32(cmbShobeList.EditValue) || CodeBeforeEdit != txtCode.Text)
{
q8.KeyId = Convert.ToInt32(txtShobeCode.Text + txtCode.Text);
}
if (MajmoeIdBeforeEdit != Convert.ToInt32(cmbMajmoehaList.EditValue) || VahedIdBeforeEdit != Convert.ToInt32(cmbVahedhaList.EditValue) || ShobeIdBeforeEdit != Convert.ToInt32(cmbShobeList.EditValue))
{
q8.ParentId = Convert.ToInt32(txtShobeCode.Text);
}
if (NameBeforeEdit != txtDoreMali.Text)
{
q8.LevelName = txtDoreMali.Text;
}
if (MajmoeIdBeforeEdit != Convert.ToInt32(cmbMajmoehaList.EditValue))
{
q8.MajmoeId = Convert.ToInt32(cmbMajmoehaList.EditValue);
}
if (VahedIdBeforeEdit != Convert.ToInt32(cmbVahedhaList.EditValue))
{
q8.VahedId = Convert.ToInt32(cmbVahedhaList.EditValue);
}
if (ShobeIdBeforeEdit != Convert.ToInt32(cmbShobeList.EditValue))
{
q8.ShobeId = Convert.ToInt32(cmbShobeList.EditValue);
}
if (IsActiveBeforeEdit != chkIsActive.Checked)
{
q8.IsActive = chkIsActive.Checked;
}
///////////////////////////////////////متد اصلاح کد و نام در جدول رابطه بین کاربران و سطح دسترسی لیست دفاتر مالی WillCascadeOnUpdate//////////////////////////////////////
var q9 = db.RmsUserBmsAccessLevelDafaterMalis.FirstOrDefault(s => s.DoreMaliId == RowId);
if (MajmoeIdBeforeEdit != Convert.ToInt32(cmbMajmoehaList.EditValue) || VahedIdBeforeEdit != Convert.ToInt32(cmbVahedhaList.EditValue) || ShobeIdBeforeEdit != Convert.ToInt32(cmbShobeList.EditValue) || CodeBeforeEdit != txtCode.Text)
{
q9.KeyId = Convert.ToInt32(txtShobeCode.Text + txtCode.Text);
}
if (MajmoeIdBeforeEdit != Convert.ToInt32(cmbMajmoehaList.EditValue))
{
q9.MajmoeId = Convert.ToInt32(cmbMajmoehaList.EditValue);
}
if (VahedIdBeforeEdit != Convert.ToInt32(cmbVahedhaList.EditValue))
{
q9.VahedId = Convert.ToInt32(cmbVahedhaList.EditValue);
}
if (ShobeIdBeforeEdit != Convert.ToInt32(cmbShobeList.EditValue))
{
q9.ShobeId = Convert.ToInt32(cmbShobeList.EditValue);
}
if (IsActiveBeforeEdit != chkIsActive.Checked)
{
q9.IsActive = chkIsActive.Checked;
}
/////////////////////////////////////////////////////////////////////////////
if (IsActiveBeforeEdit == false && chkIsActive.Checked == true)
{
int MajmoeId = Convert.ToInt32(cmbMajmoehaList.EditValue);
int VahedId = Convert.ToInt32(cmbVahedhaList.EditValue);
int ShobeId = Convert.ToInt32(cmbShobeList.EditValue);
var m = db.MsMajmoes.FirstOrDefault(p => p.MsMajmoeId == MajmoeId);
var v = db.MsVaheds.FirstOrDefault(p => p.MsVahedId == VahedId);
var s = db.MsShobes.FirstOrDefault(p => p.MsShobeId == ShobeId);
var a1 = db.MsAccessLevelDafaterMalis.FirstOrDefault(p => p.MajmoeId == MajmoeId && p.VahedId == 0);
var a2 = db.MsAccessLevelDafaterMalis.FirstOrDefault(p => p.MajmoeId == MajmoeId && p.VahedId == VahedId && p.ShobeId == 0);
var a3 = db.MsAccessLevelDafaterMalis.FirstOrDefault(p => p.MajmoeId == MajmoeId && p.VahedId == VahedId && p.ShobeId == ShobeId && p.DoreMaliId == 0);
//var a4 = db.MsAccessLevelDafaterMalis.FirstOrDefault(p => p.MajmoeId == MajmoeId && p.VahedId == VahedId && p.ShobeId == ShobeId && p.DoreMaliId == RowId);
var b1 = db.RmsUserBmsAccessLevelDafaterMalis.FirstOrDefault(p => p.MajmoeId == MajmoeId && p.VahedId == 0);
var b2 = db.RmsUserBmsAccessLevelDafaterMalis.FirstOrDefault(p => p.MajmoeId == MajmoeId && p.VahedId == VahedId && p.ShobeId == 0);
var b3 = db.RmsUserBmsAccessLevelDafaterMalis.FirstOrDefault(p => p.MajmoeId == MajmoeId && p.VahedId == VahedId && p.ShobeId == ShobeId && p.DoreMaliId == 0);
//var b4 = db.RmsUserBmsAccessLevelDafaterMalis.FirstOrDefault(p => p.MajmoeId == MajmoeId && p.VahedId == VahedId && p.ShobeId == ShobeId && p.DoreMaliId == RowId);
if (m != null)
{
m.MajmoeIsActive = true;
}
if (v != null)
{
v.VahedIsActive = true;
}
if (s != null)
{
s.ShobeIsActive = true;
}
if (a1 != null)
{
a1.IsActive = true;
}
if (a2 != null)
{
a2.IsActive = true;
}
if (a3 != null)
{
a3.IsActive = true;
}
//if (a4 != null)
// a4.IsActive = true;
if (b1 != null)
{
b1.IsActive = true;
}
if (b2 != null)
{
b2.IsActive = true;
}
if (b3 != null)
{
b3.IsActive = true;
}
//if (b4 != null)
// b4.IsActive = true;
}
db.SaveChanges();
if (IsActiveBeforeEdit)
{
btnDisplyActiveList_Click(null, null);
}
else
{
btnDisplyNotActiveList_Click(null, null);
}
//XtraMessageBox.Show("عملیات باموفقیت انجام شد", "پیغام", MessageBoxButtons.OK, MessageBoxIcon.Information);
if (gridView1.RowCount > 0)
{
gridView1.FocusedRowHandle = EditRowIndex;
}
En = EnumCED.Save;
btnCancel_Click(null, null);
}
else
{
XtraMessageBox.Show("رکورد جاری در بانک اطلاعاتی موجود نیست", "پیغام", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
catch (Exception ex)
{
XtraMessageBox.Show("عملیات با خطا مواجه شد" + "\n" + ex.Message, "پیغام", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
}
}
}
private void btnSave_Click(object sender, EventArgs e)
{
if (btnSave.Enabled)
{
if (TextEditValidation())
{
if (En == EnumCED.Create)
{
using (var db = new MyContext())
{
try
{
MsUser obj = new MsUser()
{
UserCode = Convert.ToInt32(txtCode.Text),
Name = txtName.Text,
Shenase = txtShenase.Text,
Password = txtPassword.Text,
UserIsActive = chkIsActive.Checked,
};
db.MsUsers.Add(obj);
db.SaveChanges();
}
catch (Exception ex)
{
XtraMessageBox.Show("عملیات با خطا مواجه شد" + "\n" + ex.Message, "پیغام", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
else if (En == EnumCED.Edit)
{
using (var db = new MyContext())
{
try
{
int RowId = Convert.ToInt32(txtId.Text);
var q = db.MsUsers.FirstOrDefault(p => p.MsUserId == RowId);
if (q != null)
{
q.UserCode = Convert.ToInt32(txtCode.Text);
q.Name = txtName.Text;
q.Shenase = txtShenase.Text;
q.Password = txtPassword.Text;
q.UserIsActive = Convert.ToBoolean(chkIsActive.Checked);
db.SaveChanges();
if (IsActiveBeforeEdit)
{
btnDisplyActiveList_Click(null, null);
}
else
{
btnDisplyNotActiveList_Click(null, null);
}
//XtraMessageBox.Show("عملیات باموفقیت انجام شد", "پیغام", MessageBoxButtons.OK, MessageBoxIcon.Information);
if (gridView1.RowCount > 0)
{
gridView1.FocusedRowHandle = EditRowIndex;
}
En = EnumCED.Save;
btnCancel_Click(null, null);
}
else
{
XtraMessageBox.Show("رکورد جاری در بانک اطلاعاتی موجود نیست", "پیغام", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
catch (Exception ex)
{
XtraMessageBox.Show("عملیات با خطا مواجه شد" + "\n" + ex.Message, "پیغام", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
}
}
}
