/// <summary> /// دريافت ليست گروه هاي اشخاص /// </summary> /// <param name="_pageNo"> /// شماره صفحه /// </param> /// <param name="_seedNumber"> /// تعداد ركوردهاي مدنظر براي مشاهده در خروجي /// </param> /// <returns></returns> public Models.SelectResultModelBinding <Models.PeopleGroup> GetPeopleGroup(short _pageNo = 0, short _seedNumber = 10, string search = null) { try { using (var repo = new Repository.Repository(this, "usp_getPeopleGroupList", true)) { pageNo = _pageNo; seedNumber = _seedNumber; repo.cmd.Parameters.AddWithValue("@search", search); repo.ExecuteAdapter(); var info = repo.ds.Tables[0].AsEnumerable(); return(new Models.SelectResultModelBinding <Models.PeopleGroup> { Body = info.Select(i => new Models.PeopleGroup { Id = Convert.ToInt32(i.Field <object>("id")), Code = Convert.ToString(i.Field <object>("code")), Title = Convert.ToString(i.Field <object>("title")), SaveDateTime = Convert.ToDateTime(i.Field <object>("save_datetime")) }).ToList(), TotalCount = repo.totalCount }); } } catch (Exception c) { System.Windows.MessageBox.Show(c.Message); return(null); } }
/// <summary> /// دريافت ليست انواع اسناد /// </summary> /// <param name="_pageNo"> /// شماره صفحه /// </param> /// <param name="_seedNumber"> /// تعداد ركوردهاي مدنظر براي مشاهده در خروجي /// </param> /// <returns></returns> public Models.SelectResultModelBinding <Models.PublicResultModel> GettDocumentTypes(short _pageNo = 0, short _seedNumber = 10, string search = null) { try { using (var repo = new Repository.Repository(this, "usp_getDocumentTypeList", true)) { pageNo = _pageNo; seedNumber = _seedNumber; repo.ExecuteAdapter(); var info = repo.ds.Tables[0].AsEnumerable(); return(new Models.SelectResultModelBinding <Models.PublicResultModel> { Body = info.Select(i => new Models.PublicResultModel() { Id = Convert.ToInt32(i.Field <object>("id")), Title = Convert.ToString(i.Field <object>("title")), }).ToList(), TotalCount = repo.totalCount }); } } catch (Exception c) { System.Windows.MessageBox.Show(c.Message); return(null); } }
/// <summary> /// دریافت لیست موجودیت های سیستم /// </summary> /// <returns></returns> public Models.SelectResultModelBinding <Models.EntityModelBinding> GetEntities() { using (var repo = new Repository.Repository(this, "usp_getEntityList", true)) { repo.pageNo = 0; repo.seedNumber = 10; repo.ExecuteAdapter(); var data = repo.ds.Tables[0].AsEnumerable(); return(new Models.SelectResultModelBinding <Models.EntityModelBinding> { Body = data.Select(c => new Models.EntityModelBinding { Id = Convert.ToInt32(c.Field <object>("id")), Title = c.Field <object>("title").ToString() }).ToList(), TotalCount = repo.totalCount }); } }
public List <Models.Nature> GetNatures() { try { using (var repo = new Repository.Repository(this, "usp_getNatureList", true)) { repo.ExecuteAdapter(); var info = repo.ds.Tables[0].AsEnumerable(); return((info.Select(i => new Models.Nature { Id = Convert.ToInt16(i.Field <object>("id")), Title = Convert.ToString(i.Field <object>("title")) })).ToList()); } } catch (Exception c) { MessageBox.Show(c.Message); return(null); } }
/// <summary> /// دريافت ليست حسابهای معین /// </summary> /// <param name="_pageNo"> /// شماره صفحه /// </param> /// <param name="_seedNumber"> /// تعداد ركوردهاي مدنظر براي مشاهده در خروجي /// </param> /// <returns></returns> public Models.SelectResultModelBinding <Models.Moin> GetMoinAccounts(short _pageNo = 0, short _seedNumber = 10, string search = null) { try { using (var repo = new Repository.Repository(this, "usp_getAccountingMoinList", true)) { pageNo = _pageNo; seedNumber = _seedNumber; repo.cmd.Parameters.AddWithValue("@search", search); repo.ExecuteAdapter(); var info = repo.ds.Tables[0].AsEnumerable(); var tafsiliGroupList = repo.ds.Tables[1].AsEnumerable(); return(new Models.SelectResultModelBinding <Models.Moin> { Body = info.Select(i => new Models.Moin() { Id = Convert.ToInt32(i.Field <object>("moinId")), Code = Convert.ToString(i.Field <object>("moinCode")), Title = Convert.ToString(i.Field <object>("moinTitle")), IsDefault = Convert.ToBoolean(i.Field <object>("moinIsDefault")), NatureId = Convert.ToInt16(i.Field <object>("moinNature")), NatureTitle = Convert.ToString(i.Field <object>("moinNatureTitle")), KolId = Convert.ToInt32(i.Field <object>("kolId")), KolTitle = Convert.ToString(i.Field <object>("kolTitle")), KolCode = Convert.ToString(i.Field <object>("kolCode")), MoinMap = Convert.ToString(i.Field <object>("moinMap")), TafsiliGroupBinding = SetDataTable(tafsiliGroupList.Where(m => Convert.ToInt32(m.Field <object>("moinId")) == Convert.ToInt32(i.Field <object>("moinId"))).Select(c => Convert.ToInt64(c.Field <object>("id"))).ToList()), TafsiliGroupBindingString = string.Join(",", tafsiliGroupList.Where(m => Convert.ToInt32(m.Field <object>("moinId")) == Convert.ToInt32(i.Field <object>("moinId"))).Select(c => c.Field <object>("title")).ToList()) }).ToList(), TotalCount = repo.totalCount }); } } catch (Exception c) { System.Windows.MessageBox.Show(c.Message); return(null); } }
/// <summary> /// دريافت ليست حسابهای تفصیل /// </summary> /// <param name="_pageNo"> /// شماره صفحه /// </param> /// <param name="_seedNumber"> /// تعداد ركوردهاي مدنظر براي مشاهده در خروجي /// </param> /// <returns></returns> public Models.SelectResultModelBinding <Models.Tafsil> GetTafsilAccounts(short _pageNo = 0, short _seedNumber = 10, string search = null) { try { using (var repo = new Repository.Repository(this, "usp_getTafsilAccountList", true)) { pageNo = _pageNo; seedNumber = _seedNumber; repo.cmd.Parameters.AddWithValue("@search", search); repo.ExecuteAdapter(); var info = repo.ds.Tables[0].AsEnumerable(); var tafsiliGroupList = repo.ds.Tables[1].AsEnumerable(); var peopleGroupList = repo.ds.Tables[2].AsEnumerable(); return(new Models.SelectResultModelBinding <Models.Tafsil> { Body = info.Select(i => new Models.Tafsil() { Id = Convert.ToInt32(i.Field <object>("id")), Code = Convert.ToString(i.Field <object>("code")), Title = Convert.ToString(i.Field <object>("title")), TafsilMap = tafsiliGroupList.Where(t => Convert.ToInt32(t.Field <object>("TafsilId")) == Convert.ToInt32(i.Field <object>("id"))).Select(h => h.Field <object>("full_path").ToString()).FirstOrDefault(), TitleInAutomateDocument = Convert.ToString(i.Field <object>("automate_document_title")), IsActive = Convert.ToBoolean(i.Field <object>("active")), IsCostCenter = Convert.ToBoolean(i.Field <object>("cost_center")), EntityTypeId = Convert.ToInt32(i.Field <object>("entityId")), TafsiliGroupBindingString = string.Join(",", tafsiliGroupList.Where(m => Convert.ToInt32(m.Field <object>("TafsilId")) == Convert.ToInt32(i.Field <object>("id"))).Select(c => c.Field <object>("title")).ToList()) }).ToList(), TotalCount = repo.totalCount }); } } catch (Exception c) { System.Windows.MessageBox.Show(c.Message); return(null); } }
/// <summary> /// دريافت ليست الگوی اسناد /// </summary> /// <param name="_pageNo"> /// شماره صفحه /// </param> /// <param name="_seedNumber"> /// تعداد ركوردهاي مدنظر براي مشاهده در خروجي /// </param> /// <returns></returns> public Models.SelectResultModelBinding <Models.DocumnetTemplateModelBinding> GettDocumentTemplates(int docTypeId, short _pageNo = 0, short _seedNumber = 10, string search = null) { try { using (var repo = new Repository.Repository(this, "usp_getTafsilAccountList", true)) { pageNo = _pageNo; seedNumber = _seedNumber; repo.cmd.Parameters.AddWithValue("@docTopId", docTypeId); repo.ExecuteAdapter(); var info = repo.ds.Tables[0].AsEnumerable(); return(new Models.SelectResultModelBinding <Models.DocumnetTemplateModelBinding> { Body = info.Select(i => new Models.DocumnetTemplateModelBinding() { Id = Convert.ToInt32(i.Field <object>("id")), Title = Convert.ToString(i.Field <object>("title")), TafsilCode = Convert.ToString(i.Field <object>("fk_account_code")), DescriptionHeader = i.Field <object>("description_head").ToString(), DescriptionRow = Convert.ToString(i.Field <object>("description_row")), DocumentTypeId = Convert.ToInt32(i.Field <object>("docTypeId")), DocumentTypeTitle = Convert.ToString(i.Field <object>("docTypeTitle")), NatureId = Convert.ToString(i.Field <object>("fk_nature_id")), NatureTitle = i.Field <object>("natureTitle").ToString() }).ToList(), TotalCount = repo.totalCount }); } } catch (Exception c) { System.Windows.MessageBox.Show(c.Message); return(null); } }
/// <summary> /// دريافت ليست سال های مالی /// </summary> /// <param name="_pageNo"> /// شماره صفحه /// </param> /// <param name="_seedNumber"> /// تعداد ركوردهاي مدنظر براي مشاهده در خروجي /// </param> /// <returns></returns> public Models.SelectResultModelBinding <Models.FiscalYear> GetFiscalYears(short _pageNo = 0, short _seedNumber = 10, string search = null) { try { using (var repo = new Repository.Repository(this, "usp_getFiscalYearList", true)) { pageNo = _pageNo; seedNumber = _seedNumber; repo.ExecuteAdapter(); var info = repo.ds.Tables[0].AsEnumerable(); return(new Models.SelectResultModelBinding <Models.FiscalYear> { Body = info.Select(i => new Models.FiscalYear() { Id = Convert.ToInt32(i.Field <object>("id")), Title = Convert.ToString(i.Field <object>("title")), StartDate = Convert.ToString(i.Field <object>("startDate")), EndDate = Convert.ToString(i.Field <object>("endDate")), Taxable = Convert.ToBoolean(i.Field <object>("taxable")), Taxes = Convert.ToDecimal(i.Field <object>("taxes")), Duties = Convert.ToDecimal(i.Field <object>("duties")), IsActive = Convert.ToBoolean(i.Field <object>("is_active")), Status = Convert.ToString(i.Field <object>("status")), }).ToList(), TotalCount = repo.totalCount }); } } catch (Exception c) { System.Windows.MessageBox.Show(c.Message); return(null); } }
/// <summary> /// دريافت ليست حسابهای کل /// </summary> /// <param name="_pageNo"> /// شماره صفحه /// </param> /// <param name="_seedNumber"> /// تعداد ركوردهاي مدنظر براي مشاهده در خروجي /// </param> /// <returns></returns> public Models.SelectResultModelBinding <Models.Kol> GetKolAccounts(short _pageNo = 0, short _seedNumber = 10, string search = null) { try { using (var repo = new Repository.Repository(this, "usp_getAccountKolList", true)) { pageNo = _pageNo; seedNumber = _seedNumber; repo.cmd.Parameters.AddWithValue("@search", search); repo.ExecuteAdapter(); var info = repo.ds.Tables[0].AsEnumerable(); return(new Models.SelectResultModelBinding <Models.Kol> { Body = info.Select(i => new Models.Kol() { Id = Convert.ToInt32(i.Field <object>("id")), Code = Convert.ToString(i.Field <object>("code")), Title = Convert.ToString(i.Field <object>("title")), IsDefault = Convert.ToBoolean(i.Field <object>("is_default")), NatureId = Convert.ToInt16(i.Field <object>("fk_nature_id")), NatureTitle = Convert.ToString(i.Field <object>("natureTitle")), GroupId = Convert.ToInt32(i.Field <object>("groupId")), GroupTitle = Convert.ToString(i.Field <object>("groupTitle")), GroupCode = Convert.ToString(i.Field <object>("groupCode")), }).ToList(), TotalCount = repo.totalCount }); } } catch (Exception c) { System.Windows.MessageBox.Show(c.Message); return(null); } }
/// <summary> /// دريافت ليست الگوهای تعرف شده /// </summary> /// <param name="_pageNo"> /// شماره صفحه /// </param> /// <param name="_seedNumber"> /// تعداد ركوردهاي مدنظر براي مشاهده در خروجي /// </param> /// <returns></returns> public Models.SelectResultModelBinding <Models.TafsilAccountTemplateModelBinding> GetTafsilAccountTemplateList(short _pageNo = 0, short _seedNumber = 10, string search = null) { try { using (var repo = new Repository.Repository(this, "usp_getTafsilAccountTemplateList", true)) { pageNo = _pageNo; seedNumber = _seedNumber; //repo.cmd.Parameters.AddWithValue("@search", search); repo.ExecuteAdapter(); var info = repo.ds.Tables[0].AsEnumerable(); return(new Models.SelectResultModelBinding <Models.TafsilAccountTemplateModelBinding> { Body = info.Select(i => new Models.TafsilAccountTemplateModelBinding() { Id = Convert.ToInt32(i.Field <object>("id")), EntityId = Convert.ToInt32(i.Field <object>("entityTypeId")), EntityTitle = Convert.ToString(i.Field <object>("entityTypeTitle")), TafsiliGroupId = Convert.ToInt32(i.Field <object>("tafsiliGroupId")), TafsiliGroupTitle = Convert.ToString(i.Field <object>("tafsiliGroupTitle")), PeopleGroupId = Convert.ToInt32(i.Field <object>("peopleGroupId")), PeopleGroupTitle = Convert.ToString(i.Field <object>("peopleGroupTitle")), Path = i.Field <object>("path").ToString() }).ToList(), TotalCount = repo.totalCount }); } } catch (Exception c) { System.Windows.MessageBox.Show(c.Message); return(null); } }