private void insertButton_Click(object sender, RoutedEventArgs e) { Models.ActionResultModelBinding result = null; try { Models.Tafsil newTafsilAccountObject = new Models.Tafsil { Code = txtCode.Text, Title = txtTitle.Text, EntityTypeId = cmbEntityType.SelectedValue == null ? default(int) : (int)cmbEntityType.SelectedValue, IsActive = chkInActive.IsChecked.Value ? false : true, IsCostCenter = isCistCenter.IsChecked.Value ? true:false, AccountTypeId = radioLegal.IsChecked.Value ? (short)1 : (short)2, Address = txtAddress.Text, EconomyCode = txtEconomyCode.Text, MaxCredit = decimal.Parse(string.IsNullOrEmpty(txtMaxCreidit.Text) ? "0" : txtMaxCreidit.Text), NationalCode = txtNationCode.Text, Mobile = txtMobile.Text, Tel = txtTel.Text, TitleInAutomateDocument = txtTitleInDocument.Text, }; newTafsilAccountObject.TafsiliGroupBinding = Models.Common.SetDataTable(tafsiliGroupSelector.lblValue.Tag != null ? (List <long>)tafsiliGroupSelector.lblValue.Tag : new List <long>()); newTafsilAccountObject.PeopleGroupBinding = Models.Common.SetDataTable(peopleGroupSelector.lblValue.Tag != null ? (List <long>)tafsiliGroupSelector.lblValue.Tag : new List <long>()); var errors = newTafsilAccountObject.Validate(null); if (errors.Count() > 0) { foreach (var item in errors) { MessageBox.Show(item.ErrorMessage); } } else { using (var controller = new Controllers.TafsilController()) { result = controller.InsertTafsil(newTafsilAccountObject); } } } catch (Exception c) { MessageBox.Show(c.Message); return; } finally { if (result != null) { MessageBox.Show(result.Message); if (result.Status == Models.ActionResult.Success) { } // get Tafsil GetTafsilAccounts(); } } }
/// <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 }); } }