private void btnSubmit_Click(object sender, RoutedEventArgs e)
{
var _payrollPerson = new Data.PayrollPerson();
if (entityId != Guid.Empty)
{
_payrollPerson = Business.GetPayrollPersonBusiness().GetById(entityId);
}
if (FormIsValid() && PersonCode != null)
{
commitchange(_payrollPerson);
}
}
public IQueryable <Data.PayrollSentence> GetSentenceByUserId(Guid _Id)
{
try
{
return(Business.GetPayrollPersonBusiness().GetAll().Where(r => r.id == _Id).
Join(Business.GetPayrollPersonSentencesBusiness().GetAll(),
p => p.id, ps => ps.IDPayrollSentences, (p, ps) =>
new { PayrollPerson = p, PersonSentences = ps }).
Join(Business.GetPayrollSentencesBusiness().GetAll(),
ps => ps.PersonSentences.IDPayrollSentences, s => s.ID, (ps, s) =>
new { PayrollSentence = s }).Select(r => r.PayrollSentence));
}
catch
{
throw;
}
}
private void BtnDel_Click(object sender, RoutedEventArgs e)
{
var me = MessageBox.Show("آیا مایل به حذف هستید", "حذف", MessageBoxButton.YesNo);
if (me == MessageBoxResult.Yes)
{
try
{
Business.GetPayrollPersonBusiness().Delete(GetselectedValue());
loadGridLinq();
}
catch
{
throw;
}
}
}
private PayrollPerson GetselectedValue()
{
Guid id = Guid.Empty;
try
{
if (grdPerson.SelectedValue != null)
{
id = (grdPerson.SelectedValue as dynamic).id;
}
return(Business.GetPayrollPersonBusiness().GetById(id));
}
catch
{
return(null);
}
}
private void loadGridLinq()
{
var _result = Business.GetPayrollPersonBusiness().GetAll().
Where(o => o.PPerson_Code.Contains(txtSearch.Text) ||
o.PFristName.Contains(txtSearch.Text) ||
o.PLastName.Contains(txtSearch.Text) ||
o.PIdNational.Contains(txtSearch.Text)
);
grdPerson.ItemsSource = _result.ToList();
var v = _result;
cc = v.Count();
ss = new string[cc, 9];
int ii = 0;
foreach (var item in v)
{
// string Code = item.PId;
string Name = item.PFristName;
string Family = item.PLastName;
string N_Pedar = item.PFather;
string C_Melli = item.PIdNational;
string SH_SH = item.PSHSH;
string Tedad = item.PNumberChild.ToString();
string Tell = item.PPhoneHome;
string CodePosti = item.PIdPostal;
// ss[ii, 0] = Code;
ss[ii, 1] = Name;
ss[ii, 2] = Family;
ss[ii, 3] = N_Pedar;
ss[ii, 4] = C_Melli;
ss[ii, 5] = SH_SH;
ss[ii, 6] = Tedad;
ss[ii, 7] = Tell;
ss[ii, 8] = CodePosti;
ii++;
}
}
private void BtnPrint_Click(object sender, RoutedEventArgs e)
{
var v = Business.GetPayrollPersonBusiness().GetAll();
if (txtSearch.Text.Trim().Length > 0)
{
v = Business.GetPayrollPersonBusiness().GetAll().
Where(o => o.PPerson_Code.Contains(txtSearch.Text) ||
o.PFristName.Contains(txtSearch.Text) ||
o.PLastName.Contains(txtSearch.Text) ||
o.PIdNational.Contains(txtSearch.Text)
);
}
StiReport report = new StiReport();
report.Load(@"D:\New folder (2)\accountingKernel\AccountingKernel\Debug_AccountingKernel\Report\PersonInfoSubmit.mrt");
report.RegData("v", v);
report.Show();
}
private void commitchange(PayrollPerson payrollPerson)
{
payrollPerson.PFristName = txtFirstName.Text;
payrollPerson.PLastName = txtLastName.Text;
payrollPerson.PFather = txtFather.Text;
payrollPerson.PSex = cmbGender.SelectedValue.ToGUID();
payrollPerson.PIdNational = txtNationalCode.Text;
payrollPerson.PSHSH = txtSHSH.Text;
payrollPerson.PMarriage = cmbMarriageState.SelectedValue.ToGUID();
payrollPerson.PNumberChild = txtQTY.Text.ToInt();
payrollPerson.PPhoneWork = txtTelWork.Text;
payrollPerson.PPhoneHome = txtTelHome.Text;
payrollPerson.PMobile = txtMobile.Text;
payrollPerson.PIdPostal = txtPostalCode.Text;
payrollPerson.PBrithDate = pdcBirthDay.Text;
payrollPerson.PAddress = txtAddress.Text;
payrollPerson.PDescription = txtDesc.Text;
payrollPerson.Tax_madrak = (int)cmbProofTax.SelectedValue;
payrollPerson.Tax_onvanShoghl = (int)cmbJobTax.SelectedValue;
payrollPerson.Tax_serishenasnameh = (int)cmbSeriesTax.SelectedValue;
payrollPerson.Tax_vazmaskan = (int)cmbHouseStateTax.SelectedValue;
payrollPerson.Tax_meliat = (int)cmbNationalityTax.SelectedValue;
payrollPerson.Tax_namekeshvar = (int)cmbCountryTax.SelectedValue;
payrollPerson.Tax_nezamvazifeh = cmbMilitaryTax.SelectedValue.ToGUID();
payrollPerson.Tax_rasteshoghli = (int)cmbJobCategoriesTax.SelectedValue;
payrollPerson.Tax_vazmashin = (int)cmbCarStateTax.SelectedValue;
payrollPerson.code_moafiat_maliat = (int)cmbLoanInsurance.SelectedValue;
payrollPerson.Insurance_keshvar = (int)cmbCountryInsurance.SelectedValue;
payrollPerson.Insurance_shahr = (int)cmbPlaceOfIssue.SelectedValue;
payrollPerson.Insurance_mashagel = cmbJobsInsurance.SelectedValue.ToString();
payrollPerson.Insurance_tahsilat = (int)cmbEducationInsurance.SelectedValue;
payrollPerson.Insurance_reshteh = (int)cmbFieldOfStudyInsurance.SelectedValue;
payrollPerson.Insurance_meliat = cmbNationalityInsurance.SelectedValue.ToString();
payrollPerson.code_moafiat_bimeh = (int)cmbExemptionTax.SelectedValue;
payrollPerson.PPerson_Code = string.Format("{0}{1}", txtCodeF.Text, txtCodeS.Text);
string pname = string.Format("{0} {1}", txtFirstName.Text, txtLastName.Text);
Data.PersonStructureDefine _personDefine =
Business.GetPersonStructureDefineChildBusiness().GetStructure(Constants.CodeTitle.PersonIDGroup, pname, PersonParentID, payrollPerson.PPerson_Code);
payrollPerson.PPerson_Code = _personDefine.Code;
int Primerycodelen = (int)Business.GetCodeTitleBusiness().GetById(Constants.CodeTitle.PersonPrimeryGroup).CodeLen;
int Secendarycodelen = (int)Business.GetCodeTitleBusiness().GetById(Constants.CodeTitle.PersonPrimeryGroup).CodeLen;
string s = Business.GetPersonStructureDefineBusiness().GetMaxCode(PersonCode).Select(r => r.Code).FirstOrDefault();
_personDefine.Type = Constants.CodeTitle.PersonIDGroup;
using (var scope = new TransactionScope(TransactionScopeOption.Required, new TransactionOptions()
{
IsolationLevel = System.Transactions.IsolationLevel.ReadUncommitted,
Timeout = new TimeSpan(2, 0, 0)
}))
{
Business.GetPersonStructureDefineChildBusiness().SaveWithID(_personDefine);
payrollPerson.PersonStructerID = _personDefine.ID;
Business.GetPayrollPersonBusiness().Save(payrollPerson);
Business.GetPayrollPersonWorkDoneBusiness().Save(new PayrollPersonWorkDone()
{
IDPayrollPerson = payrollPerson.id
});
scope.Complete();
}
this.Close();
}
