private void bindingNavigatorDeleteItem_Click(object sender, EventArgs e) { if (!string.IsNullOrEmpty(colourIdTextBox.Text.Trim())) { if (MessageBox.Show("Anda yakin menghapus data?", "Konfirmasi Hapus Data", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) == DialogResult.OK) { color = (MColour)DataMaster.GetObjectById(typeof(MColour), colourIdTextBox.Text); DataMaster.Delete(color); ModuleControlSettings.SaveLog(ListOfAction.Delete, colourIdTextBox.Text, ListOfTable.MColour, lbl_UserName.Text); BindData(); } } }
private void bindingNavigatorSaveItem_Click(object sender, EventArgs e) { if (!ValidateForm()) { return; } if (colourIdTextBox.Enabled == true) { color = new MColour(); } else { color = (MColour)DataMaster.GetObjectById(typeof(MColour), colourIdTextBox.Text); } color.ColourId = colourIdTextBox.Text; color.ColourDesc = colourDescTextBox.Text; color.ModifiedBy = lbl_UserName.Text; color.ModifiedDate = DateTime.Now; if (colourIdTextBox.Enabled == true) { try { DataMaster.SavePersistence(color); } catch (NHibernate.NonUniqueObjectException) { RecreateBalloon(); balloonHelp.Caption = "Validasi data kurang"; balloonHelp.Content = "Warna dengan kode " + colourIdTextBox.Text + " sudah pernah diinput, silahkan input dengan kode yang lain"; balloonHelp.ShowBalloon(colourIdTextBox); colourIdTextBox.Focus(); return; } ModuleControlSettings.SaveLog(ListOfAction.Insert, colourIdTextBox.Text, ListOfTable.MColour, lbl_UserName.Text); } else { DataMaster.UpdatePersistence(color); ModuleControlSettings.SaveLog(ListOfAction.Update, colourIdTextBox.Text, ListOfTable.MColour, lbl_UserName.Text); } BindData(); }
internal static void FillColorComboBox(ComboBox stockDesc1ComboBox) { DataMasterMgtServices DataMaster = new DataMasterMgtServices(); stockDesc1ComboBox.DropDownStyle = ComboBoxStyle.DropDownList; NHibernate.Expression.Order[] orderArrays = new NHibernate.Expression.Order[1]; orderArrays[0] = NHibernate.Expression.Order.Asc(MColour.ColumnNames.ColourDesc); IList list = DataMaster.GetList(typeof(MColour), null, orderArrays); MColour col = new MColour(); col.ColourDesc = "- Warna -"; list.Insert(0, col); //DataTable dt = new DataTable(); //dt.Columns.Add(MColour.ColumnNames.ColourId); //dt.Columns.Add(MColour.ColumnNames.ColourDesc); //DataRow dr; //IList listItemType = DataMaster.GetAll(typeof(MColour)); //MColour warna = new MColour(); //warna.ColourDesc = "- Warna -"; //dr = dt.NewRow(); //dr[0] = warna.ColourId; //dr[1] = warna.ColourDesc; //dt.Rows.Add(dr); //for (int i = 0; i < listItemType.Count; i++) //{ // warna = (MColour)listItemType[i]; // dr = dt.NewRow(); // dr[0] = warna.ColourId; // dr[1] = warna.ColourDesc; // dt.Rows.Add(dr); //} stockDesc1ComboBox.DataSource = list; stockDesc1ComboBox.DisplayMember = MColour.ColumnNames.ColourDesc; stockDesc1ComboBox.ValueMember = MColour.ColumnNames.ColourId; stockDesc1ComboBox.Show(); }
private void BindData(object sender, EventArgs e) { string myKeyWord = string.Empty; string col = TStock.ColumnNames.StockDesc2; if (sender == txt_SearchById) { if (!txt_SearchById.Text.Equals("<Cari Berdasar No Rangka>")) { myKeyWord = txt_SearchById.Text.Trim(); } col = TStock.ColumnNames.StockDesc2; } else if (sender == txt_SearchByName) { if (!txt_SearchByName.Text.Equals("<Cari Berdasar No Mesin>")) { myKeyWord = txt_SearchByName.Text.Trim(); } col = TStock.ColumnNames.StockDesc3; } //bindingSource_Search.Clear(); NHibernate.Expression.ICriterion[] expArrays = new NHibernate.Expression.ICriterion[5]; expArrays[0] = NHibernate.Expression.Expression.Eq(TStock.ColumnNames.ItemId, cb_ItemId.SelectedValue.ToString()); expArrays[1] = NHibernate.Expression.Expression.InsensitiveLike(col, myKeyWord, NHibernate.Expression.MatchMode.Anywhere); expArrays[2] = NHibernate.Expression.Expression.Eq(TStock.ColumnNames.GudangId, GudangId); if (!string.IsNullOrEmpty(LocationId)) { expArrays[3] = NHibernate.Expression.Expression.Eq(TStock.ColumnNames.LocatonId, LocationId); } expArrays[4] = NHibernate.Expression.Expression.Eq(TStock.ColumnNames.StockIsAvailable, true); IList listSearch = DataMaster.GetList(typeof(TStock), expArrays, null); TStock stok; MColour color; MItem item; DataTable dt = new DataTable(); DataRow dr; dt.Columns.Add(TStock.ColumnNames.StockId); dt.Columns.Add(TStock.ColumnNames.ItemId); dt.Columns.Add(TStock.ColumnNames.StockDesc1); dt.Columns.Add(TStock.ColumnNames.StockDesc2); dt.Columns.Add(TStock.ColumnNames.StockDesc3); for (int i = 0; i < listSearch.Count; i++) { stok = listSearch[i] as TStock; dr = dt.NewRow(); dr[0] = stok.StockId; //nama item item = DataMaster.GetObjectByProperty(typeof(MItem), MItem.ColumnNames.ItemId, stok.ItemId) as MItem; if (item == null) { item = new MItem(); } dr[1] = item.ItemName; //nama warna color = DataMaster.GetObjectByProperty(typeof(MColour), MColour.ColumnNames.ColourId, stok.StockDesc1) as MColour; if (color == null) { color = new MColour(); } dr[2] = color.ColourDesc; dr[3] = stok.StockDesc2; dr[4] = stok.StockDesc3; dt.Rows.Add(dr); } bindingSource_Search.DataSource = dt; //if (listSearch.Count > 0) // bindingSource_Search.DataSource = listSearch; }