/// <summary> /// حذف يك گروه حساب /// </summary> /// <param name="groupModel"></param> /// <returns></returns> public Models.ActionResultModelBinding RemovePeopleGroup(Models.PeopleGroup groupModel, bool confirmDeleteSubdivision) { try { using (var repo = new Repository.Repository(this, "usp_deletePeopleGroup")) { repo.cmd.Parameters.AddWithValue("@id", groupModel.Id); //repo.cmd.Parameters.AddWithValue("@confirmDeleteSubdivision", confirmDeleteSubdivision); repo.ExecuteNonQuery(); return(new Models.ActionResultModelBinding { Message = repo.rMsg, Status = repo.rCode == 1 ? Models.ActionResult.Success : Models.ActionResult.Failed }); } } catch (Exception c) { return(new Models.ActionResultModelBinding { Message = c.Message, Status = Models.ActionResult.Failed }); } }
/// <summary> /// ويرايش گروه اشخاص /// </summary> /// <param name="groupModel"></param> /// <returns></returns> public Models.ActionResultModelBinding UpdatePeopleGroup(Models.PeopleGroup groupModel) { try { using (var repo = new Repository.Repository(this, "usp_updatetPeopleGroup")) { repo.cmd.Parameters.AddWithValue("@id", groupModel.Id); repo.cmd.Parameters.AddWithValue("@code", groupModel.Code); repo.cmd.Parameters.AddWithValue("@title", groupModel.Title); repo.ExecuteNonQuery(); return(new Models.ActionResultModelBinding { Message = repo.rMsg, Status = repo.rCode == 1 ? Models.ActionResult.Success : Models.ActionResult.Failed }); } } catch (Exception c) { return(new Models.ActionResultModelBinding { Message = c.Message, Status = Models.ActionResult.Failed }); } }
/// <summary> /// ثبت سال مالی جديد /// </summary> /// <param name="model"> /// مدل پايه سال مالی /// </param> /// <returns></returns> public Models.ActionResultModelBinding InsertFiscalYear(Models.FiscalYear model) { try { using (var repo = new Repository.Repository(this, "usp_insertFiscalYear")) { repo.cmd.Parameters.AddWithValue("@title", model.Title); repo.cmd.Parameters.AddWithValue("@startDate", model.StartDate); repo.cmd.Parameters.AddWithValue("@endDate", model.EndDate); repo.cmd.Parameters.AddWithValue("@taxable", model.Taxable); repo.cmd.Parameters.AddWithValue("@taxes", model.Taxes); repo.cmd.Parameters.AddWithValue("@duties", model.Duties); repo.cmd.Parameters.AddWithValue("@is_active", model.IsActive); repo.ExecuteNonQuery(); return(new Models.ActionResultModelBinding { Message = repo.rMsg, Status = repo.rCode == 1 ? Models.ActionResult.Success : Models.ActionResult.Failed }); } } catch (Exception c) { return(new Models.ActionResultModelBinding { Message = c.Message, Status = Models.ActionResult.Failed }); } }
/// <summary> /// ویرایش الگوی سند /// </summary> /// <param name="model"></param> /// <returns></returns> public Models.ActionResultModelBinding UpdatetDocumentTemplate(Models.DocumnetTemplateModelBinding model) { try { using (var repo = new Repository.Repository(this, "usp_updateAccountingDocumentTemplate")) { repo.cmd.Parameters.AddWithValue("@id", model.Id); repo.cmd.Parameters.AddWithValue("@title", model.Title); repo.cmd.Parameters.AddWithValue("@descriptionHead", model.DescriptionHeader); repo.cmd.Parameters.AddWithValue("@documentTypeId", model.DocumentTypeId); repo.cmd.Parameters.AddWithValue("@accountCode", model.TafsilCode); repo.cmd.Parameters.AddWithValue("@natureId", model.NatureId); repo.cmd.Parameters.AddWithValue("@descriptionRow", model.DescriptionRow); repo.ExecuteNonQuery(); return(new Models.ActionResultModelBinding { Message = repo.rMsg, Status = repo.rCode == 1 ? Models.ActionResult.Success : Models.ActionResult.Failed }); } } catch (Exception c) { return(new Models.ActionResultModelBinding { Message = c.Message, Status = Models.ActionResult.Failed }); } }
/// <summary> /// ثبت مرکز هزینه جديد /// </summary> /// <param name="groupModel"> /// مدل پايه مرکز هزینه /// </param> /// <returns></returns> public Models.ActionResultModelBinding InsertCostCenter(Models.CostCenter groupModel) { try { using (var repo = new Repository.Repository(this, "usp_insertCostCenter")) { repo.cmd.Parameters.AddWithValue("@code", groupModel.Code); repo.cmd.Parameters.AddWithValue("@title", groupModel.Title); repo.ExecuteNonQuery(); return(new Models.ActionResultModelBinding { Message = repo.rMsg, Status = repo.rCode == 1 ? Models.ActionResult.Success : Models.ActionResult.Failed }); } } catch (Exception c) { return(new Models.ActionResultModelBinding { Message = c.Message, Status = Models.ActionResult.Failed }); } }
/// <summary> /// ويرايش حساب کل /// </summary> /// <param name="kolModel"></param> /// <returns></returns> public Models.ActionResultModelBinding UpdateKolAccount(Models.Kol kolModel) { try { using (var repo = new Repository.Repository(this, "usp_updateAccountingKol")) { repo.cmd.Parameters.AddWithValue("@id", kolModel.Id); repo.cmd.Parameters.AddWithValue("@code", kolModel.Code); repo.cmd.Parameters.AddWithValue("@title", kolModel.Title); repo.cmd.Parameters.AddWithValue("@natureId", kolModel.NatureId); repo.cmd.Parameters.AddWithValue("@isDefault", kolModel.IsDefault); repo.cmd.Parameters.AddWithValue("@groupId", kolModel.GroupId); repo.ExecuteNonQuery(); return(new Models.ActionResultModelBinding { Message = repo.rMsg, Status = repo.rCode == 1 ? Models.ActionResult.Success : Models.ActionResult.Failed }); } } catch (Exception c) { return(new Models.ActionResultModelBinding { Message = c.Message, Status = Models.ActionResult.Failed }); } }
/// <summary> /// ویرایش الگو /// </summary> /// <param name="model"></param> /// <returns></returns> public Models.ActionResultModelBinding UpdateTafsilAccountTemplate(Models.TafsilAccountTemplateModelBinding model) { try { using (var repo = new Repository.Repository(this, "usp_updateTafsilAccountTemplate")) { repo.cmd.Parameters.AddWithValue("@id", model.Id); repo.cmd.Parameters.AddWithValue("@entityId", model.EntityId); repo.cmd.Parameters.AddWithValue("@tafsiliGroupId", model.TafsiliGroupId); repo.cmd.Parameters.AddWithValue("@peopleGroupId", model.PeopleGroupId); repo.ExecuteNonQuery(); return(new Models.ActionResultModelBinding { Message = repo.rMsg, Status = repo.rCode == 1 ? Models.ActionResult.Success : Models.ActionResult.Failed }); } } catch (Exception c) { return(new Models.ActionResultModelBinding { Message = c.Message, Status = Models.ActionResult.Failed }); } }
/// <summary> /// ثبت گروه تفصیلی جدید /// </summary> /// <param name="model"> /// مدل پايه گروه تفصیلی /// </param> /// <returns></returns> public Models.ActionResultModelBinding InsertTafsiliGroupAccount(Models.TafsiliGroup model) { try { using (var repo = new Repository.Repository(this, "usp_insertTafisiliGroup")) { repo.cmd.Parameters.AddWithValue("@code", model.Code); repo.cmd.Parameters.AddWithValue("@title", model.Title); repo.cmd.Parameters.AddWithValue("@editable", model.Editable); repo.ExecuteNonQuery(); return(new Models.ActionResultModelBinding { Message = repo.rMsg, Status = repo.rCode == 1 ? Models.ActionResult.Success : Models.ActionResult.Failed }); } } catch (Exception c) { return(new Models.ActionResultModelBinding { Message = c.Message, Status = Models.ActionResult.Failed }); } }
/// <summary> /// ثبت حساب معین جديد /// </summary> /// <param name="model"> /// مدل پايه حساب معین /// </param> /// <returns></returns> public Models.ActionResultModelBinding InsertMoinAccount(Models.Moin model) { try { using (var repo = new Repository.Repository(this, "usp_insertAccountingMoein")) { repo.cmd.Parameters.AddWithValue("@code", model.Code); repo.cmd.Parameters.AddWithValue("@title", model.Title); repo.cmd.Parameters.AddWithValue("@natureId", model.NatureId); repo.cmd.Parameters.AddWithValue("@isDefault", model.IsDefault); repo.cmd.Parameters.AddWithValue("@isPermanent", model.IsPermanent); repo.cmd.Parameters.AddWithValue("@kolId", model.KolId); var param = repo.cmd.Parameters.AddWithValue("@tafiliGroupList", model.TafsiliGroupBinding); param.SqlDbType = System.Data.SqlDbType.Structured; repo.ExecuteNonQuery(); return(new Models.ActionResultModelBinding { Message = repo.rMsg, Status = repo.rCode == 1 ? Models.ActionResult.Success : Models.ActionResult.Failed }); } } catch (Exception c) { return(new Models.ActionResultModelBinding { Message = c.Message, Status = Models.ActionResult.Failed }); } }
/// <summary> /// ویرایش حساب تفصیل /// </summary> /// <param name="model"></param> /// <returns></returns> public Models.ActionResultModelBinding UpdateTafsil(Models.Tafsil model) { try { using (var repo = new Repository.Repository(this, "usp_updateTafsilAccount")) { repo.cmd.Parameters.AddWithValue("@id", model.Id); repo.cmd.Parameters.AddWithValue("@code", model.Code); repo.cmd.Parameters.AddWithValue("@title", model.Title); repo.cmd.Parameters.AddWithValue("@automateDocumentTitle", model.TitleInAutomateDocument); repo.cmd.Parameters.AddWithValue("@isActive", model.IsActive); repo.cmd.Parameters.AddWithValue("@hasCostCenter", model.IsCostCenter); repo.cmd.Parameters.AddWithValue("@fk_typ_entity_type", model.EntityTypeId); repo.cmd.Parameters.AddWithValue("@tel", model.Tel); repo.cmd.Parameters.AddWithValue("@mobile", model.Mobile); repo.cmd.Parameters.AddWithValue("@address", model.Address); repo.cmd.Parameters.AddWithValue("@nationalCode", model.NationalCode); repo.cmd.Parameters.AddWithValue("@economyCode", model.EconomyCode); repo.cmd.Parameters.AddWithValue("@accTypeId", model.AccountTypeId); repo.cmd.Parameters.AddWithValue("@maxCredit", model.MaxCredit); var param = repo.cmd.Parameters.AddWithValue("@tafiliGroupList", model.TafsiliGroupBinding); param.SqlDbType = System.Data.SqlDbType.Structured; var param1 = repo.cmd.Parameters.AddWithValue("@peopleGroupList", model.PeopleGroupBinding); param1.SqlDbType = System.Data.SqlDbType.Structured; repo.ExecuteNonQuery(); return(new Models.ActionResultModelBinding { Message = repo.rMsg, Status = repo.rCode == 1 ? Models.ActionResult.Success : Models.ActionResult.Failed }); } } catch (Exception c) { return(new Models.ActionResultModelBinding { Message = c.Message, Status = Models.ActionResult.Failed }); } }
/// <summary> /// حذف حساب تفصیل /// </summary> /// <param name="model"></param> /// <returns></returns> public Models.ActionResultModelBinding DeleteTafsil(Models.Tafsil model) { try { using (var repo = new Repository.Repository(this, "usp_updateTafsilAccount")) { repo.cmd.Parameters.AddWithValue("@id", model.Id); repo.ExecuteNonQuery(); return(new Models.ActionResultModelBinding { Message = repo.rMsg, Status = repo.rCode == 1 ? Models.ActionResult.Success : Models.ActionResult.Failed }); } } catch (Exception c) { return(new Models.ActionResultModelBinding { Message = c.Message, Status = Models.ActionResult.Failed }); } }