public string GetNewCode(Guid codeTitleId, string prefixCode)
{
try
{
var codeTitleBusiness = Business.GetCodeTitleBusiness();
var codeTitle = Business.GetCodeTitleBusiness().GetById(codeTitleId);
var good = this.GetAll().Where(r => r.CodeTitleId == codeTitleId && r.Code.StartsWith(prefixCode)).
OrderByDescending(r => r.LastEdit).FirstOrDefault();
if (good == null)
{
return(codeTitle.CodeStart.ToInt().ToString().Calibrate('0', codeTitle.CodeLen.ToInt()));
}
var cdidin = (good.Code.Remove(0, prefixCode.Length)).ToInt() + 1;
string code = prefixCode + cdidin.ToString().Calibrate('0', codeTitle.CodeLen.ToInt());
while (this.GetByCode(code) != null)
{
code = prefixCode + (++cdidin).ToString().Calibrate('0', codeTitle.CodeLen.ToInt());
}
return(code.Remove(0, prefixCode.Length));
}
catch
{
throw;
}
}
public string GetNewCodeForHesab(Guid codeTitleId, Data.AccountingTafsillevelsDetail group)
{
try
{
var codeTitle = Business.GetCodeTitleBusiness().GetById(codeTitleId);
if (group == null)
{
return(codeTitle.CodeStart.ToInt().ToString().Calibrate('0', codeTitle.CodeLen.ToInt()));
}
var coIdAccountingTafsilLevels = this.GetByIdIn(group.IdIn, Common.Constants.CodeTitle.GoruheTafsili).Select(r => r.IdAccountingTafsilLevels).ToList();
var atld = this.GetAll().Where(r => r.IdCodeTitle == codeTitleId && coIdAccountingTafsilLevels.Contains(r.IdAccountingTafsilLevels)).
OrderByDescending(r => r.LastEdit).FirstOrDefault();
if (atld == null)
{
return(codeTitle.CodeStart.ToInt().ToString().Calibrate('0', codeTitle.CodeLen.ToInt()));
}
var idin = atld.IdIn.ToInt() + 1;
var code = idin.ToString().Calibrate('0', codeTitle.CodeLen.ToInt());
while (this.GetByIdIn(code, codeTitleId).Any())
{
code = (++idin).ToString().Calibrate('0', codeTitle.CodeLen.ToInt());
}
return(code);
}
catch
{
throw;
}
}
public string GetNewCode()
{
try
{
var codeTitle = Business.GetCodeTitleBusiness().GetById(Common.Constants.CodeTitle.Bank);
var fund = this.GetAll().Where(r => r.FType == Common.Constants.BankType.Bank).OrderByDescending(r => r.LastEdit).FirstOrDefault();
if (fund == null)
{
return(codeTitle.CodeStart.ToInt().ToString().Calibrate('0', codeTitle.CodeLen.ToInt()));
}
var cdidin = fund.FBankNO.ToInt() + 1;
string code = cdidin.ToString().Calibrate('0', codeTitle.CodeLen.ToInt());
while (this.GetByFbank(code).Any())
{
code = (++cdidin).ToString().Calibrate('0', codeTitle.CodeLen.ToInt());
}
return(code);
}
catch
{
throw;
}
}
public string GetNewCodeForGroup(Guid codeTitleId)
{
try
{
var codeTitle = Business.GetCodeTitleBusiness().GetById(codeTitleId);
var atld = this.GetAll().Where(r => r.IdCodeTitle == codeTitleId).OrderByDescending(r => r.LastEdit).FirstOrDefault();
if (atld == null)
{
return(codeTitle.CodeStart.ToInt().ToString().Calibrate('0', codeTitle.CodeLen.ToInt()));
}
var idin = atld.IdIn.ToInt() + 1;
var code = idin.ToString().Calibrate('0', codeTitle.CodeLen.ToInt());
while (this.GetByIdIn(code, codeTitleId).Any())
{
code = (++idin).ToString().Calibrate('0', codeTitle.CodeLen.ToInt());
}
return(code);
}
catch
{
throw;
}
}
public string GetNewCode(Guid codeTitleId)
{
try
{
var codeTitle = Business.GetCodeTitleBusiness().GetById(codeTitleId);
var baseInfoId = Common.Constants.TreasuryType.Payment;
if (codeTitleId == Common.Constants.CodeTitle.Recive)
{
baseInfoId = Common.Constants.TreasuryType.Recive;
}
var treasury = this.GetByBaseInfoId(baseInfoId).OrderByDescending(r => r.LastEdit).FirstOrDefault();
if (treasury == null)
{
return(codeTitle.CodeStart.ToInt().ToString().Calibrate('0', codeTitle.CodeLen.ToInt()));
}
var cdidin = treasury.TNO.ToInt() + 1;
string code = cdidin.ToString().Calibrate('0', codeTitle.CodeLen.ToInt());
while (this.GetByTNo(code, baseInfoId).Any())
{
code = (++cdidin).ToString().Calibrate('0', codeTitle.CodeLen.ToInt());
}
return(code);
}
catch
{
throw;
}
}
public MoeinStructureDefineBusiness()
{
GoruhLen = (int)Business.GetCodeTitleBusiness().GetById(Constants.CodeTitle.Goruh).CodeLen;
KolLen = (int)Business.GetCodeTitleBusiness().GetById(Constants.CodeTitle.Kol).CodeLen;
MoeinLen = (int)Business.GetCodeTitleBusiness().GetById(Constants.CodeTitle.Moein).CodeLen;
TafsilLen = (int)Business.GetCodeTitleBusiness().GetById(Constants.CodeTitle.Tafsil1).CodeLen;
}
public string GetNewCode(Guid codeTitleId, Data.AccountingMoeinDetail parentAmd)
{
try
{
IQueryable <Guid?> coParentAmdIds = null;
if (parentAmd != null)
{
// پیدا کردن رکوردهای هم کد با والد
coParentAmdIds = this.GetByIdIn(parentAmd.IdIn, parentAmd.IdCodeTitle.ToGUID()).Select(r => r.IdAccountingMoein);
}
var codeTitle = Business.GetCodeTitleBusiness().GetById(codeTitleId);
var amds = this.GetAll().Where(r => r.IdCodeTitle == codeTitle.Id);
if (coParentAmdIds != null && coParentAmdIds.Any())
{
amds = coParentAmdIds.Join(amds, o => o, i => i.IdAccountingMoein, (o, i) => new { i = i }).Select(r => r.i);
}
amds = amds.OrderByDescending(r => r.LastEdit);
var amd = amds.FirstOrDefault();
if (amd == null)
{
return(codeTitle.CodeStart.ToInt().ToString().Calibrate('0', codeTitle.CodeLen.ToInt()));
}
var idin = amd.IdIn.ToInt() + 1;
var code = idin.ToString().Calibrate('0', codeTitle.CodeLen.ToInt());
while (this.GetByIdIn(code, codeTitle.Id).Any())
{
code = (++idin).ToString().Calibrate('0', codeTitle.CodeLen.ToInt());
}
return(code);
}
catch
{
throw;
}
}
public CompanyStructureDefineBusiness()
{
MainLen = (int)Business.GetCodeTitleBusiness().GetById(Constants.CodeTitle.CompanyMainGroup).CodeLen;
SubsidiaryLen = (int)Business.GetCodeTitleBusiness().GetById(Constants.CodeTitle.CompanySubsidiaryGroup).CodeLen;
}
private void FormLoad(Data.PayrollPerson myData)
{
try
{
PrimeryLen = (int)Business.GetCodeTitleBusiness().GetById(Constants.CodeTitle.PersonPrimeryGroup).CodeLen;
SecenderyLen = (int)Business.GetCodeTitleBusiness().GetById(Constants.CodeTitle.PersonSecendryGroup).CodeLen;
PersonLen = (int)Business.GetCodeTitleBusiness().GetById(Constants.CodeTitle.PersonIDGroup).CodeLen;
txtCodeS.MaxLength = PersonLen;
var baseInfos = Business.GetBaseInfoBusiness().GetAll().Select(r => new { Id = r.Id, Name = r.AssignName, PId = r.PID }).ToList();
var payrolltaxCodeenum = Business.GetPayrollTaxCodeBusiness().GetAll().Select(r => new { MId = r.MCode, Id = r.SCode, Name = r.SDesc }).OrderBy(r => r.MId).ToList();
var payrollInsuranceCodeenum = Business.GetPayrollInsuranceCodeBusiness().GetAll().Select(r => new { MId = r.MCode, Id = r.SCode, Name = r.SDesc }).OrderBy(r => r.MId).ToList();
cmbGender.ItemsSource = baseInfos.FindAll(r => r.PId == Constants.BaseInfoType.Gender);
cmbMarriageState.ItemsSource = baseInfos.FindAll(r => r.PId == Constants.BaseInfoType.MarriageState);
cmbProofTax.ItemsSource = payrolltaxCodeenum.FindAll(r => r.MId == (int)PayrollTaxCodeEnum.Education);
cmbJobTax.ItemsSource = payrolltaxCodeenum.FindAll(r => r.MId == (int)PayrollTaxCodeEnum.Job);
cmbSeriesTax.ItemsSource = payrolltaxCodeenum.FindAll(r => r.MId == (int)PayrollTaxCodeEnum.SHSHSeries);
cmbHouseStateTax.ItemsSource = payrolltaxCodeenum.FindAll(r => r.MId == (int)PayrollTaxCodeEnum.HouseState);
cmbNationalityTax.ItemsSource = payrolltaxCodeenum.FindAll(r => r.MId == (int)PayrollTaxCodeEnum.Nationality);
cmbCountryTax.ItemsSource = payrolltaxCodeenum.FindAll(r => r.MId == (int)PayrollTaxCodeEnum.Country);
cmbMilitaryTax.ItemsSource = baseInfos.FindAll(r => r.PId == Constants.BaseInfoType.MilitaryStatus);
cmbJobCategoriesTax.ItemsSource = payrolltaxCodeenum.FindAll(r => r.MId == (int)PayrollTaxCodeEnum.JobCategories);
cmbCarStateTax.ItemsSource = payrolltaxCodeenum.FindAll(r => r.MId == (int)PayrollTaxCodeEnum.CarState);
cmbFieldOfStudyInsurance.ItemsSource = payrollInsuranceCodeenum.FindAll(r => r.MId == (int)PayrollInsuranceCodeEnum.FieldOfStudy);
cmbNationalityInsurance.ItemsSource = payrollInsuranceCodeenum.FindAll(r => r.MId == (int)PayrollInsuranceCodeEnum.Nationality);
cmbEducationInsurance.ItemsSource = payrollInsuranceCodeenum.FindAll(r => r.MId == (int)PayrollInsuranceCodeEnum.Education);
cmbJobsInsurance.ItemsSource = payrollInsuranceCodeenum.FindAll(r => r.MId == (int)PayrollInsuranceCodeEnum.Jobs);
cmbPlaceOfIssue.ItemsSource = payrollInsuranceCodeenum.FindAll(r => r.MId == (int)PayrollInsuranceCodeEnum.PlaceOfIssue);
cmbCountryInsurance.ItemsSource = payrollInsuranceCodeenum.FindAll(r => r.MId == (int)PayrollInsuranceCodeEnum.Country);
cmbExemptionTax.ItemsSource = Business.GetLoanTaxBusiness().GetAll().Select(r => new { Name = r.name_moafiat, Id = r.kod_moafiat }).ToList();
cmbLoanInsurance.ItemsSource = Business.GetLoanInsuranceBusiness().GetAll().Select(r => new { Name = r.name_moafiat, Id = r.kod_moafiat }).ToList();
if (myData == null)
{
return;
}
entityId = myData.id;
txtCodeF.Text = myData.PPerson_Code.Substring(0, 6);
txtFirstName.Text = myData.PFristName;
txtLastName.Text = myData.PLastName;
txtFather.Text = myData.PFather;
cmbGender.SelectedValue = myData.PSex;
txtNationalCode.Text = myData.PIdNational;
txtSHSH.Text = myData.PSHSH;
cmbMarriageState.SelectedValue = myData.PMarriage;
txtQTY.Text = myData.PNumberChild.ToString();
txtTelWork.Text = myData.PPhoneWork;
txtTelHome.Text = myData.PPhoneHome;
txtMobile.Text = myData.PMobile;
txtPostalCode.Text = myData.PIdPostal;
pdcBirthDay.Text = myData.PBrithDate;
txtAddress.Text = myData.PAddress;
txtTelWork.Text = myData.PDescription;
//imgPerson.StreamSource =myData.PImage;
////imgPerson.Source = myData.PImage
////pic
//FileStream fs = new FileStream(myData.PImage);
////byte[] data = new byte[fs.Length];
////fs.Read(data, 0, System.Convert.ToInt32(fs.Length));
////fs.Close();
cmbProofTax.SelectedValue = myData.Tax_madrak;
txtProofTax.Text = myData.Tax_madrak == null ? string.Empty : myData.Tax_madrak.Value.ToString();
cmbJobTax.SelectedValue = myData.Tax_onvanShoghl;
txtJobTax.Text = myData.Tax_onvanShoghl == null ? string.Empty : myData.Tax_onvanShoghl.Value.ToString();
cmbSeriesTax.SelectedValue = myData.Tax_serishenasnameh;
txtSeriesTax.Text = myData.Tax_serishenasnameh == null ? string.Empty : myData.Tax_serishenasnameh.Value.ToString();
cmbHouseStateTax.SelectedValue = myData.Tax_vazmaskan;
txtHouseStateTax.Text = myData.Tax_vazmaskan == null ? string.Empty : myData.Tax_vazmaskan.Value.ToString();
cmbNationalityTax.SelectedValue = myData.Tax_meliat;
txtNationalityTax.Text = myData.Tax_meliat == null ? string.Empty : myData.Tax_meliat.Value.ToString();
cmbCountryTax.SelectedValue = myData.Tax_namekeshvar;
txtCountryTax.Text = myData.Tax_namekeshvar == null ? string.Empty : myData.Tax_namekeshvar.Value.ToString();
cmbMilitaryTax.SelectedValue = myData.Tax_nezamvazifeh;
cmbJobCategoriesTax.SelectedValue = myData.Tax_rasteshoghli;
txtJobCategoriesTax.Text = myData.Tax_rasteshoghli == null ? string.Empty : myData.Tax_rasteshoghli.Value.ToString();
cmbExemptionTax.SelectedValue = myData.code_moafiat_maliat;
txtExemptionTax.Text = myData.code_moafiat_maliat == null ? string.Empty : myData.code_moafiat_maliat.Value.ToString();
cmbCarStateTax.SelectedValue = myData.Tax_vazmashin;
txtCarStateTax.Text = myData.Tax_vazmashin == null ? string.Empty : myData.Tax_vazmashin.Value.ToString();
cmbLoanInsurance.SelectedValue = myData.code_moafiat_bimeh;
txtLoanInsurance.Text = myData.code_moafiat_bimeh == null ? string.Empty : myData.code_moafiat_bimeh.ToString();
cmbCountryInsurance.SelectedValue = myData.Insurance_keshvar;
txtCountryInsurance.Text = myData.Insurance_keshvar == null ? string.Empty : myData.Insurance_keshvar.Value.ToString();
cmbPlaceOfIssue.SelectedValue = myData.Insurance_shahr;
txtPlaceOfIssue.Text = myData.Insurance_shahr == null ? string.Empty : myData.Insurance_shahr.Value.ToString();
cmbJobsInsurance.SelectedValue = myData.Insurance_mashagel;
txtJobsInsurance.Text = myData.Insurance_mashagel == null ? string.Empty : myData.Insurance_mashagel;
cmbEducationInsurance.SelectedValue = myData.Insurance_tahsilat;
txtEducationInsurance.Text = myData.Insurance_tahsilat == null ? string.Empty : myData.Insurance_tahsilat.ToString();
cmbFieldOfStudyInsurance.SelectedValue = myData.Insurance_reshteh;
txtFieldOfStudyInsurance.Text = myData.Insurance_reshteh == null ? string.Empty : myData.Insurance_reshteh.ToString();
cmbNationalityInsurance.SelectedValue = myData.Insurance_meliat;
txtNationalityInsurance.Text = myData.Insurance_meliat == null ? string.Empty : myData.Insurance_meliat.ToString();
}
catch
{
throw;
}
}
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();
}
public TafsilStructureDefineBussiness()
{
TafsilGroupLen = (int)Business.GetCodeTitleBusiness().GetById(Constants.CodeTitle.TafsilGroup).CodeLen;
AccountLen = (int)Business.GetCodeTitleBusiness().GetById(Constants.CodeTitle.AccountGroup).CodeLen;
}
public PersonStructureDefineChildBusiness()
{
PrimeryLen = (int)Business.GetCodeTitleBusiness().GetById(Constants.CodeTitle.PersonPrimeryGroup).CodeLen;
SecendryLen = (int)Business.GetCodeTitleBusiness().GetById(Constants.CodeTitle.PersonSecendryGroup).CodeLen;
PersonLen = (int)Business.GetCodeTitleBusiness().GetById(Constants.CodeTitle.PersonIDGroup).CodeLen;
}
