public void Delete(AccountingMoeinDetail moi) { try { Table.Remove(moi); this.SubmitChanges(); } catch { throw; } }
public void Save(AccountingMoeinDetail entity) { try { this.Save(new List <Data.AccountingMoeinDetail>() { entity }); } catch { throw; } }
private void PrepareMoein(AccountingMoeinDetail item) { try { item.MDName = txt_moien.Text; item.MDNameEn = txt_name_latin_moien.Text; item.IdIn = txt_moien_code.Text; var view = Business.GetAccountingMoeinDetailBusiness().GetViewById(item.Id); if (view == null || view.IdIn != item.IdIn) { item.LastEdit = DateTime.Now; } } catch { throw; } }
private Data.AccountingMoeinDetail SaveGroup() { try { var accountingMoeinDetailBusiness = Business.GetAccountingMoeinDetailBusiness(); var groups = new List <Data.AccountingMoeinDetail>(); var group = new Data.AccountingMoeinDetail(); string oldGroupIdIn = null; //edit mode group = accountingMoeinDetailBusiness.GetByAccountingMoeinDetailId(AccountingMoeinId, Common.Constants.CodeTitle.Goruh).FirstOrDefault(); if (group == null) { group = new AccountingMoeinDetail() { IdAccountingMoein = AccountingMoeinId, IdCodeTitle = Common.Constants.CodeTitle.Goruh } } ; else { oldGroupIdIn = group.IdIn; } PrepareGroup(group); groups.Add(group); if (oldGroupIdIn != null) { var otherGroups = accountingMoeinDetailBusiness.GetByIdIn(oldGroupIdIn, Common.Constants.CodeTitle.Goruh).Where(r => r.IdAccountingMoein != AccountingMoeinId).ToList(); otherGroups.ForEach(r => PrepareGroup(r)); groups.AddRange(otherGroups); } accountingMoeinDetailBusiness.Save(groups); return(group); } catch { throw; } }
/// <summary> /// ثبت اطلاعات در جدول accountingMoien /// </summary> /// <param name="accountingMoienId"></param> /// <param name="grouhIdIn"></param> /// <param name="kolIdIn"></param> /// <param name="moienIdIn"></param> /// <param name="moienName"></param> /// <summary> ///بررسی جدول و پاک کردن رکورد در صورت تکراری بودن /// </summary> /// <param name="C_id_accounting_moien">کد معین ثبت شده</param> /// <param name="IdInGrouh">accountig moien گروه ثبت شده</param> /// <param name="IdInKol">accountig moien کل ثبت شده</param> /// <param name="IdInMoien">accountig moien معین ثبت شده</param> /// <returns></returns> private bool check_for_duplication_record(string C_id_accounting_moien, string IdInGrouh, string IdInKol, string IdInMoien) { int counter = 0; string[] sorted_idn = new string[3]; List <AccountingMoeinDetail> get_all_from_table = ak1.AccountingMoeinDetails.OrderBy(i => i.IdAccountingMoein).ToList(); /////////////////////////////////////////////////////////////////////// for (int i = 0; i <= get_all_from_table.Count - 1; i += 3) { for (int j = i; j <= (i + 3) - 1; j++) { if (get_all_from_table[j].IdCodeTitle == Common.Constants.CodeTitle.Goruh) { sorted_idn[0] = get_all_from_table[j].IdIn.ToString(); } if (get_all_from_table[j].IdCodeTitle == Common.Constants.CodeTitle.Kol) { sorted_idn[1] = get_all_from_table[j].IdIn.ToString(); } if (get_all_from_table[j].IdCodeTitle == Common.Constants.CodeTitle.Moein) { sorted_idn[2] = get_all_from_table[j].IdIn.ToString(); } } //////////////////////////////////////////////////////////////////// if (sorted_idn[0] == IdInGrouh && sorted_idn[1] == IdInKol && sorted_idn[2] == IdInMoien) { counter++; } if (sorted_idn[0] == "") { counter = 2; } } if (counter > 1) { /////// پاک کردن تمام رکوردهای ثبت شده Guid guid_id_moien = Guid.Parse(C_id_accounting_moien); AccountingMoeinDetail akm = ak1.AccountingMoeinDetails.First(i => i.IdAccountingMoein == guid_id_moien); ak1.AccountingMoeinDetails.Remove(akm); ak1.SaveChanges(); AccountingMoeinDetail akm1 = ak1.AccountingMoeinDetails.First(i => i.IdAccountingMoein == guid_id_moien); ak1.AccountingMoeinDetails.Remove(akm1); ak1.SaveChanges(); AccountingMoeinDetail akm2 = ak1.AccountingMoeinDetails.First(i => i.IdAccountingMoein == guid_id_moien); ak1.AccountingMoeinDetails.Remove(akm2); ak1.SaveChanges(); return(true); } return(false); }