private void FillCommissionShareTabPages(decimal CommissionId, bool isSavePosition) { if (isSavePosition && CommissionId == 0) { MCommission comm = (MCommission)DataMaster.GetObjectByProperty(typeof(MCommission), MCommission.ColumnNames.CommissionStatus, commissionStatusComboBox.SelectedItem.ToString()); CommissionId = comm.CommissionId; } Type share = typeof(ListOfCommissionShare); TabPage tab; NumericUpDown num; TextBox txt; MCommissionShare commShare; string shareName; foreach (string s in Enum.GetNames(share)) { shareName = Enum.Parse(share, s).ToString(); commShare = (MCommissionShare)DataMaster.GetObjectByProperty(typeof(MCommissionShare), MCommissionShare.ColumnNames.CommissionId, CommissionId, MCommissionShare.ColumnNames.ShareTo, shareName); if (commShare == null) { commShare = new MCommissionShare(); } tab = tabControl_CommissionShare.TabPages[ControlName.tab_pages_.ToString() + shareName]; //set numeric share value num = (NumericUpDown)tab.Controls[ControlName.num_.ToString() + shareName]; if (isSavePosition) { commShare.ShareValue = num.Value; } else { num.Value = commShare.ShareValue; } //add textboxdesc txt = (TextBox)tab.Controls[ControlName.txt_.ToString() + shareName]; if (isSavePosition) { commShare.ShareDesc = txt.Text; } else { txt.Text = commShare.ShareDesc; } if (isSavePosition) { commShare.CommissionId = CommissionId; commShare.ShareTo = shareName; DataMaster.SaveOrUpdate(commShare); } } }
private void SaveStock() { for (int i = 0; i < tStockDataGridView.RowCount; i++) { TStock s = new TStock(); s.ItemId = tStockDataGridView.Rows[i].Cells[2].Value.ToString(); s.StockBarcodeId = tStockDataGridView.Rows[i].Cells[0].Value.ToString(); s.StockLocation = tStockDataGridView.Rows[i].Cells[1].Value.ToString(); DataMaster.SaveOrUpdate(s); } }
private void bindingNavigatorSaveItem_Click(object sender, EventArgs e) { if (!ValidateForm()) { return; } if (!(itemTypeIdLabel1.Text.Trim().Equals("0") || string.IsNullOrEmpty(itemTypeIdLabel1.Text.Trim()))) { tipe = (MItemType)DataMaster.GetObjectByProperty(typeof(MItemType), MItemType.ColumnNames.ItemTypeId, int.Parse(itemTypeIdLabel1.Text)); } else { tipe = new MItemType(); } tipe.ItemTypeName = itemTypeNameTextBox.Text; tipe.ModifiedBy = lbl_UserName.Text; tipe.ModifiedDate = DateTime.Now; DataMaster.SaveOrUpdate(tipe); ModuleControlSettings.SaveLog(ListOfAction.Update, itemTypeNameTextBox.Text, ListOfTable.MGroup, lbl_UserName.Text); BindData(); }
private void bindingNavigatorSaveItem_Click(object sender, EventArgs e) { if (!ValidateForm()) { return; } if (!(groupIdLabel1.Text.Trim().Equals("0") || string.IsNullOrEmpty(groupIdLabel1.Text.Trim()))) { group = (MGroup)DataMaster.GetObjectById(typeof(MGroup), Convert.ToInt32(groupIdLabel1.Text)); } else { group = new MGroup(); } group.GroupName = groupNameTextBox.Text; group.ModifiedBy = lbl_UserName.Text; group.ModifiedDate = DateTime.Now; DataMaster.SaveOrUpdate(group); ModuleControlSettings.SaveLog(ListOfAction.Update, groupNameTextBox.Text, ListOfTable.MGroup, lbl_UserName.Text); BindData(); }
public static string GetVoucherNo() { string voucherFrontString = "V/" + DateTime.Now.Year.ToString() + "/"; int voucherLength = 8; string lastVoucher; string VoucherNo = "VoucherNo"; DataMasterMgtServices DataMaster = new DataMasterMgtServices(); TReference refer = (TReference)DataMaster.GetObjectByProperty(typeof(TReference), TReference.ColumnNames.ReferenceType, VoucherNo); if (refer == null) { refer = new TReference(); lastVoucher = decimal.Zero.ToString(); } else { lastVoucher = refer.NextId.Substring(refer.NextId.Length - voucherLength, voucherLength); //voucherLength = voucherLength - 1; } decimal nextNumVoucher = Convert.ToDecimal(lastVoucher) + 1; string nextVoucher = nextNumVoucher.ToString(); for (int i = 0; i < voucherLength - nextNumVoucher.ToString().Length; i++) { nextVoucher = "0" + nextVoucher; } nextVoucher = voucherFrontString + nextVoucher; refer.NextId = nextVoucher; refer.ReferenceType = VoucherNo; DataMaster.SaveOrUpdate(refer); return(nextVoucher); }
private void bindingNavigatorSaveItem_Click(object sender, EventArgs e) { if (!ValidateForm()) { return; } if (!(groupIdLabel1.Text.Trim().Equals("0") || string.IsNullOrEmpty(groupIdLabel1.Text.Trim()))) { group = (MGroup)DataMaster.GetObjectByProperty(typeof(MGroup), MGroup.ColumnNames.GroupId, Convert.ToInt32(groupIdLabel1.Text)); } else { group = new MGroup(); } //group.GroupId = Convert.ToInt32(groupIdLabel1.Text); group.GroupName = groupNameTextBox.Text; group.ModifiedBy = lbl_UserName.Text; group.ModifiedDate = DateTime.Now; DataMaster.SaveOrUpdate(group); BindData(); }
internal static string GetNewId(Type tipe) { DataMasterMgtServices DataMaster = new DataMasterMgtServices(); TReference refer = (TReference)DataMaster.GetObjectByProperty(typeof(TReference), TReference.ColumnNames.ReferenceType, tipe.Name.ToString()); int length = 8;//int.Parse(ConfigurationManager.AppSettings["IdLength"]); string result = string.Empty; string lastId = string.Empty; if (refer == null) { refer = new TReference(); lastId = decimal.Zero.ToString(); } else { lastId = refer.NextId; } decimal nextId = Convert.ToDecimal(lastId) + 1; for (int i = 0; i < length - nextId.ToString().Length; i++) { result = "0" + result; } result = tipe.Name.ToString().Substring(1, tipe.Name.ToString().Length - 1) + result + nextId.ToString(); refer.NextId = nextId.ToString(); refer.ReferenceType = tipe.Name.ToString(); DataMaster.SaveOrUpdate(refer); return(result); }
private void SaveOrUpdateDeliveryDetail() { TTransactionDeliveryDetail deldet; string itemId; decimal qty, transDetId, delDetId; for (int i = 0; i < tTransactionDeliveryDetailDataGridView.RowCount; i++) { if (Convert.ToBoolean(tTransactionDeliveryDetailDataGridView.Rows[i].Cells[0].Value)) { itemId = tTransactionDeliveryDetailDataGridView.Rows[i].Cells[1].Value.ToString(); qty = Convert.ToDecimal(tTransactionDeliveryDetailDataGridView.Rows[i].Cells[5].Value); transDetId = Convert.ToDecimal(tTransactionDeliveryDetailDataGridView.Rows[i].Cells[6].Value); delDetId = Convert.ToDecimal(tTransactionDeliveryDetailDataGridView.Rows[i].Cells[7].Value); if (isInEdit) { deldet = (TTransactionDeliveryDetail)DataMaster.GetObjectByProperty(typeof(TTransactionDeliveryDetail), TTransactionDeliveryDetail.ColumnNames.DeliveryDetailId, delDetId, TTransactionDeliveryDetail.ColumnNames.TransactionDetailId, transDetId); if (deldet == null) { deldet = new TTransactionDeliveryDetail(); } else { UpdateStok(false, 1, itemId, deldet.DeliveryDetailQuantity, false); } } else { deldet = new TTransactionDeliveryDetail(); } deldet.DeliveryDetailDesc = string.Empty; deldet.DeliveryDetailItemId = itemId; deldet.DeliveryDetailQuantity = qty; deldet.DeliveryId = delId; deldet.TransactionDetailId = transDetId; deldet.ModifiedBy = lbl_UserName.Text; deldet.ModifiedDate = DateTime.Now; DataMaster.SaveOrUpdate(deldet); UpdateStok(false, 1, itemId, qty, true); } } }
private void SaveRekap(listAcc acc, string desc, decimal salesTot) { //period = numericUpDown_Year.Value.ToString() + comboBox_Month.SelectedValue.ToString(); TRekapSubAccount rekap = (TRekapSubAccount)DataMaster.GetObjectByProperty(typeof(TRekapSubAccount), TRekapSubAccount.ColumnNames.RekapSubAccountPeriode, period, TRekapSubAccount.ColumnNames.SubAccountId, acc.ToString()); if (rekap == null) { rekap = new TRekapSubAccount(); } rekap.ModifiedBy = lbl_UserName.Text; rekap.ModifiedDate = DateTime.Now; rekap.RekapSubaccountDesc = desc; rekap.RekapSubAccountPeriode = period; rekap.RekapSubaccountSaldo = salesTot; rekap.SubAccountId = acc.ToString(); DataMaster.SaveOrUpdate(rekap); }
public static string GenerateFacturNo(ListOfTransaction tr, string DeskNo) { DataMasterMgtServices DataMaster = new DataMasterMgtServices(); MSetting set = (MSetting)DataMaster.GetObjectById(typeof(MSetting), AssemblyProduct); TReference refer = (TReference)DataMaster.GetObjectByProperty(typeof(TReference), TReference.ColumnNames.ReferenceType, tr.ToString()); if (refer == null) { refer = new TReference(); refer.NextId = decimal.Zero.ToString(); } string facturNoTemplate = set.FacturNoFormat; decimal no = Convert.ToDecimal(refer.NextId) + 1; int len = set.FacturNoLength - no.ToString().Length; string factur = no.ToString(); for (int i = 0; i < len; i++) { factur = "0" + factur; } refer.NextId = no.ToString(); refer.ReferenceType = tr.ToString(); DataMaster.SaveOrUpdate(refer); string tipeTrans = string.Empty; char[] charTransArray = tr.ToString().ToCharArray(); char charTrans; for (int i = 0; i < tr.ToString().Length; i++) { charTrans = charTransArray[i]; if (char.IsUpper(tr.ToString(), i)) { tipeTrans += tr.ToString().Substring(i, 1); } } return(facturNoTemplate.Replace("[xxx]", factur).Replace("[meja]", DeskNo).Replace("[tanggal]", DateTime.Now.Day.ToString()).Replace("[bulan]", DateTime.Now.Month.ToString()).Replace("[tahun]", DateTime.Now.Year.ToString()).Replace("[Tipe]", tipeTrans)); }
public static string GetLabaDitahanAccountNo() { string LabaDitahanAccountNo = "LabaDitahanAccountNo"; string defaultLabaDitahanAccountNo = "510LAB001"; DataMasterMgtServices DataMaster = new DataMasterMgtServices(); TReference refer = (TReference)DataMaster.GetObjectByProperty(typeof(TReference), TReference.ColumnNames.ReferenceType, LabaDitahanAccountNo); if (refer == null) { refer = new TReference(); refer.ReferenceType = LabaDitahanAccountNo; refer.NextId = defaultLabaDitahanAccountNo; DataMaster.SaveOrUpdate(refer); } else { defaultLabaDitahanAccountNo = refer.NextId; } return(defaultLabaDitahanAccountNo); }
public static string GetPPNPurchaseAccountNo() { string PPNPurchaseAccountNo = "PPNPurchase"; string defaultPPNPurchaseAccountNo = "320PPN001"; DataMasterMgtServices DataMaster = new DataMasterMgtServices(); TReference refer = (TReference)DataMaster.GetObjectByProperty(typeof(TReference), TReference.ColumnNames.ReferenceType, PPNPurchaseAccountNo); if (refer == null) { refer = new TReference(); refer.ReferenceType = PPNPurchaseAccountNo; refer.NextId = defaultPPNPurchaseAccountNo; DataMaster.SaveOrUpdate(refer); } else { defaultPPNPurchaseAccountNo = refer.NextId; } return(defaultPPNPurchaseAccountNo); }
public static string GetBiayaStokAccountNo() { string BiayaStokAccountNo = "BiayaStokAccountNo"; string defaultBiayaStokAccountNo = "830STO001"; DataMasterMgtServices DataMaster = new DataMasterMgtServices(); TReference refer = (TReference)DataMaster.GetObjectByProperty(typeof(TReference), TReference.ColumnNames.ReferenceType, BiayaStokAccountNo); if (refer == null) { refer = new TReference(); refer.ReferenceType = BiayaStokAccountNo; refer.NextId = defaultBiayaStokAccountNo; DataMaster.SaveOrUpdate(refer); } else { defaultBiayaStokAccountNo = refer.NextId; } return(defaultBiayaStokAccountNo); }
public static string GetOtherRevenueAccountNo() { string OtherRevenueAccountNo = "OtherRevenueAccountNo"; string defaultOtherRevenueAccountNo = "680"; DataMasterMgtServices DataMaster = new DataMasterMgtServices(); TReference refer = (TReference)DataMaster.GetObjectByProperty(typeof(TReference), TReference.ColumnNames.ReferenceType, OtherRevenueAccountNo); if (refer == null) { refer = new TReference(); refer.ReferenceType = OtherRevenueAccountNo; refer.NextId = defaultOtherRevenueAccountNo; DataMaster.SaveOrUpdate(refer); } else { defaultOtherRevenueAccountNo = refer.NextId; } return(defaultOtherRevenueAccountNo); }
public static string GetHutangEkspedisiAccountNo() { string HutangEkspedisiAccountNo = "HutangEkspedisiAccountNo"; string defaultHutangEkspedisiAccountNo = "400HUT002"; DataMasterMgtServices DataMaster = new DataMasterMgtServices(); TReference refer = (TReference)DataMaster.GetObjectByProperty(typeof(TReference), TReference.ColumnNames.ReferenceType, HutangEkspedisiAccountNo); if (refer == null) { refer = new TReference(); refer.ReferenceType = HutangEkspedisiAccountNo; refer.NextId = defaultHutangEkspedisiAccountNo; DataMaster.SaveOrUpdate(refer); } else { defaultHutangEkspedisiAccountNo = refer.NextId; } return(defaultHutangEkspedisiAccountNo); }
public static string GetIkhtiarRLAccountNo() { string IkhtiarRLAccountNo = "IkhtiarRLAccountNo"; string defaultIkhtiarRLAccountNo = "1000-RL001"; DataMasterMgtServices DataMaster = new DataMasterMgtServices(); TReference refer = (TReference)DataMaster.GetObjectByProperty(typeof(TReference), TReference.ColumnNames.ReferenceType, IkhtiarRLAccountNo); if (refer == null) { refer = new TReference(); } else { defaultIkhtiarRLAccountNo = refer.NextId; } refer.ReferenceType = IkhtiarRLAccountNo; refer.NextId = defaultIkhtiarRLAccountNo; DataMaster.SaveOrUpdate(refer); return(defaultIkhtiarRLAccountNo); }
private void bindingNavigatorSaveItem_Click(object sender, EventArgs e) { if (!ValidateForm()) { return; } if (!groupIdLabel1.Text.Trim().Equals("0")) { group = (MGroup)DataMaster.GetObjectById(typeof(MGroup), Convert.ToInt32(groupIdLabel1.Text)); } else { group = new MGroup(); } group.GroupId = Convert.ToInt32(groupIdLabel1.Text); group.GroupName = groupNameTextBox.Text; DataMaster.SaveOrUpdate(group); BindData(); }
private void bindingNavigatorSaveItem_Click(object sender, EventArgs e) { if (!ValidateForm()) { return; } if (!(gudangIdLabel1.Text.Trim().Equals("0") || string.IsNullOrEmpty(gudangIdLabel1.Text.Trim()))) { gud = (MGudang)DataMaster.GetObjectByProperty(typeof(MGudang), MGudang.ColumnNames.GudangId, Convert.ToInt32(gudangIdLabel1.Text)); } else { gud = new MGudang(); } gud.GudangName = gudangNameTextBox.Text; gud.ModifiedBy = lbl_UserName.Text; gud.ModifiedDate = DateTime.Now; DataMaster.SaveOrUpdate(gud); ModuleControlSettings.SaveLog(ListOfAction.Update, gudangNameTextBox.Text, ListOfTable.MGudang, lbl_UserName.Text); BindData(); }
private void bindingNavigatorSaveItem_Click(object sender, EventArgs e) { if (!ValidateForm()) { return; } bool isSave = false; //if (bankIdComboBox.Enabled) //{ // giro = new TGiro(); // isSave = true; //} //else //{ // giro = (TGiro)DataMaster.GetObjectByProperty(typeof(TGiro), TGiro.ColumnNames.GiroNo, giroNoTextBox.Text, TGiro.ColumnNames.BankId, bankIdComboBox.SelectedValue.ToString()); // isSave = false; //} if (giroIdNumericUpDown.Value != 0) { giro = (TGiro)DataMaster.GetObjectByProperty(typeof(TGiro), TGiro.ColumnNames.GiroId, giroIdNumericUpDown.Value); isSave = false; } else { giro = new TGiro(); isSave = true; } giro.CurrencyId = currencyIdComboBox.SelectedItem.ToString(); giro.BankId = bankIdComboBox.SelectedValue.ToString(); giro.GiroAmmount = giroAmmountNumericUpDown.Value; giro.GiroCairDate = giroCairDateDateTimePicker.Value; giro.GiroTo = combo_Supplier.SelectedValue.ToString(); giro.GiroMaturityDate = giroMaturityDateDateTimePicker.Value; giro.GiroNo = giroNoTextBox.Text; if (isSave) { giro.GiroStatus = ListOfGiroStatus.Baru.ToString(); giro.GiroOutDate = DateTime.Now; } else { giro.GiroStatus = giroStatusLabel1.Text; } giro.ModifiedBy = lbl_UserName.Text; giro.ModifiedDate = DateTime.Now; DataMaster.SaveOrUpdate(giro); if (isSave) { //try //{ // DataMaster.SavePersistence(giro); //} //catch (NHibernate.NonUniqueObjectException) //{ // RecreateBalloon(); // balloonHelp.Caption = "Validasi data kurang"; // balloonHelp.Content = "Nomor giro " + giroNoTextBox.Text + " sudah pernah diinput, silahkan input dengan nomor yang lain"; // balloonHelp.ShowBalloon(giroNoTextBox); // giroNoTextBox.Focus(); // return; //} ModuleControlSettings.SaveLog(ListOfAction.Insert, bankIdComboBox.SelectedValue.ToString() + ";" + giroNoTextBox.Text + ";" + ListOfGiroStatus.Baru.ToString(), ListOfTable.TGiro, lbl_UserName.Text); } else { //DataMaster.UpdatePersistence(giro); ModuleControlSettings.SaveLog(ListOfAction.Update, bankIdComboBox.SelectedValue.ToString() + ";" + giroNoTextBox.Text + ";" + giroStatusLabel1.Text, ListOfTable.TGiro, lbl_UserName.Text); } BindGiroData(); CalculateTotalUtang(); }