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;
}
