public static string GenerateFacturNo(string DeskNo)
{
DataMasterMgtServices DataMaster = new DataMasterMgtServices();
MSetting set = (MSetting)DataMaster.GetObjectByProperty(typeof(MSetting), MSetting.ColumnNames.SettingId, AssemblyProduct);
//IList listTrans = DataMaster.GetAll(typeof(TTransaction));
string facturNoTemplate = set.FacturNoFormat;
//int no = listTrans.Count + 1;
int no = Convert.ToInt32(set.FacturNoNext) + 1;
int len = set.FacturNoLength - no.ToString().Length;
string factur = no.ToString();
for (int i = 0; i < len; i++)
{
factur = "0" + factur;
}
//update next faktur
set.FacturNoNext = set.FacturNoNext + 1;
DataMaster.UpdatePersistence(set);
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()));
}
public static void SetCustomerComboBoxForFilter(ComboBox cb)
{
DataMasterMgtServices DataMaster = new DataMasterMgtServices();
IList listCust = DataMaster.GetAll(typeof(MCustomer));
MCustomer cust;
DataTable dt = new DataTable();
dt.Columns.Add(MCustomer.ColumnNames.CustomerId);
dt.Columns.Add(MCustomer.ColumnNames.CustomerName);
DataRow dr = dt.NewRow();
dr[0] = "";
dr[1] = "-Semua Pelanggan-";
dt.Rows.Add(dr);
for (int i = 0; i < listCust.Count; i++)
{
cust = (MCustomer)listCust[i];
dr = dt.NewRow();
dr[0] = cust.CustomerId;
dr[1] = cust.CustomerName;
dt.Rows.Add(dr);
}
cb.DropDownStyle = ComboBoxStyle.DropDownList;
cb.DataSource = dt;
cb.ValueMember = MCustomer.ColumnNames.CustomerId;
cb.DisplayMember = MCustomer.ColumnNames.CustomerName;
cb.Show();
}
public static void SetEkspeditionComboBoxForFilter(ComboBox cb)
{
DataMasterMgtServices DataMaster = new DataMasterMgtServices();
IList listEks = DataMaster.GetAll(typeof(MEkspedission));
MEkspedission eks;
DataTable dt = new DataTable();
dt.Columns.Add(MEkspedission.ColumnNames.EkspedissionId);
dt.Columns.Add(MEkspedission.ColumnNames.EkspedissionName);
DataRow dr = dt.NewRow();
dr[0] = "";
dr[1] = "-Semua Ekspedisi-";
dt.Rows.Add(dr);
for (int i = 0; i < listEks.Count; i++)
{
eks = (MEkspedission)listEks[i];
dr = dt.NewRow();
dr[0] = eks.EkspedissionId;
dr[1] = eks.EkspedissionName;
dt.Rows.Add(dr);
}
cb.DropDownStyle = ComboBoxStyle.DropDownList;
cb.DataSource = dt;
cb.ValueMember = MEkspedission.ColumnNames.EkspedissionId;
cb.DisplayMember = MEkspedission.ColumnNames.EkspedissionName;
cb.Show();
}
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 BindKartuStokData()
{
DataTable dt = new DataTable();
dt.Columns.Add("Hapus", typeof(bool));
dt.Columns.Add("kartu stok id", typeof(decimal));
dt.Columns.Add("kartu stok date", typeof(DateTime));
dt.Columns.Add("item id", typeof(string));
dt.Columns.Add("stok status", typeof(bool));
dt.Columns.Add("stok jumlah", typeof(decimal));
dt.Columns.Add("stok saldo", typeof(decimal));
DataRow dr;
DataMasterMgtServices DataMaster = new DataMasterMgtServices();
IList listKartuStok = DataMaster.GetAllSortBy(typeof(TStokCard), TStokCard.ColumnNames.ItemId, "ASC");
TStokCard card;
for (int i = 0; i < listKartuStok.Count; i++)
{
card = (TStokCard)listKartuStok[i];
dr = dt.NewRow();
dr[0] = false;
dr[1] = card.StokCardId;
dr[2] = card.StokCardDate;
dr[3] = card.ItemId;
dr[4] = card.StokCardStatus;
dr[5] = card.StokCardQuantity;
dr[6] = card.StokCardSaldo;
dt.Rows.Add(dr);
}
dataGridView1.DataSource = dt;
dataGridView1.Show();
}
public static void SetGroupComboBoxForFilter(ComboBox cb)
{
DataMasterMgtServices DataMaster = new DataMasterMgtServices();
IList listGroup = DataMaster.GetAll(typeof(MGroup));
MGroup group;
DataTable dt = new DataTable();
dt.Columns.Add(MGroup.ColumnNames.GroupId);
dt.Columns.Add(MGroup.ColumnNames.GroupName);
DataRow dr = dt.NewRow();
dr[0] = 0;
dr[1] = "-Semua Golongan-";
dt.Rows.Add(dr);
for (int i = 0; i < listGroup.Count; i++)
{
group = (MGroup)listGroup[i];
dr = dt.NewRow();
dr[0] = group.GroupId;
dr[1] = group.GroupName;
dt.Rows.Add(dr);
}
cb.DropDownStyle = ComboBoxStyle.DropDownList;
cb.DataSource = dt;
cb.ValueMember = MGroup.ColumnNames.GroupId;
cb.DisplayMember = MGroup.ColumnNames.GroupName;
cb.Show();
}
public static void SetSupplierComboBoxForFilter(ComboBox cb)
{
DataMasterMgtServices DataMaster = new DataMasterMgtServices();
IList listSupp = DataMaster.GetAll(typeof(MSupplier));
MSupplier supp;
DataTable dt = new DataTable();
dt.Columns.Add(MSupplier.ColumnNames.SupplierId);
dt.Columns.Add(MSupplier.ColumnNames.SupplierName);
DataRow dr = dt.NewRow();
dr[0] = "";
dr[1] = "-Semua Supplier-";
dt.Rows.Add(dr);
for (int i = 0; i < listSupp.Count; i++)
{
supp = (MSupplier)listSupp[i];
dr = dt.NewRow();
dr[0] = supp.SupplierId;
dr[1] = supp.SupplierName;
dt.Rows.Add(dr);
}
cb.DropDownStyle = ComboBoxStyle.DropDownList;
cb.DataSource = dt;
cb.ValueMember = MSupplier.ColumnNames.SupplierId;
cb.DisplayMember = MSupplier.ColumnNames.SupplierName;
cb.Show();
}
public static void SetUserComboBoxForFilter(ComboBox cb)
{
DataMasterMgtServices DataMaster = new DataMasterMgtServices();
IList listUser = DataMaster.GetAll(typeof(MUser));
MUser user;
DataTable dt = new DataTable();
dt.Columns.Add(MUser.ColumnNames.UserStatus);
dt.Columns.Add(MUser.ColumnNames.UserName);
DataRow dr = dt.NewRow();
dr[0] = "";
dr[1] = "-Semua Pengguna-";
dt.Rows.Add(dr);
for (int i = 0; i < listUser.Count; i++)
{
user = (MUser)listUser[i];
dr = dt.NewRow();
dr[0] = user.UserName;
dr[1] = user.UserName;
dt.Rows.Add(dr);
}
cb.DropDownStyle = ComboBoxStyle.DropDownList;
cb.DataSource = dt;
cb.ValueMember = MUser.ColumnNames.UserStatus;
cb.DisplayMember = MUser.ColumnNames.UserName;
cb.Show();
}
public static void SetItemComboBoxForFilter(ComboBox cb)
{
DataMasterMgtServices DataMaster = new DataMasterMgtServices();
IList listItem = DataMaster.GetAll(typeof(MItem));
MItem item;
DataTable dt = new DataTable();
dt.Columns.Add(MItem.ColumnNames.ItemId);
dt.Columns.Add(MItem.ColumnNames.ItemName);
DataRow dr = dt.NewRow();
dr[0] = "";
dr[1] = "-Semua Item-";
dt.Rows.Add(dr);
for (int i = 0; i < listItem.Count; i++)
{
item = (MItem)listItem[i];
dr = dt.NewRow();
dr[0] = item.ItemId;
dr[1] = item.ItemName;
dt.Rows.Add(dr);
}
cb.DropDownStyle = ComboBoxStyle.DropDownList;
cb.DataSource = dt;
cb.ValueMember = MItem.ColumnNames.ItemId;
cb.DisplayMember = MItem.ColumnNames.ItemName;
cb.Show();
}
public static DateTime GetMaksDateTransactionClosing()
{
DataMasterMgtServices DataMaster = new DataMasterMgtServices();
IList listRekap = DataMaster.GetAll(typeof(TRekapTransaction));
TRekapTransaction rekap;
DateTime maks = DateTime.MinValue;
//search maks rekapdateto
for (int i = 0; i < listRekap.Count; i++)
{
rekap = (TRekapTransaction)listRekap[i];
if (rekap.RekapDateTo > maks)
{
maks = rekap.RekapDateTo;
}
}
if (maks == DateTime.MinValue)
{
//search min transaction date
maks = DateTime.MaxValue;
IList listTrans = DataMaster.GetAll(typeof(TTransaction));
TTransaction trans;
for (int i = 0; i < listTrans.Count; i++)
{
trans = (TTransaction)listTrans[i];
if (maks > trans.TransactionDate)
{
maks = trans.TransactionDate;
}
}
}
return(maks);
}
public static void SetEmployeeComboBoxForFilter(ComboBox cb)
{
DataMasterMgtServices DataMaster = new DataMasterMgtServices();
IList listEmp = DataMaster.GetAll(typeof(MEmployee));
MEmployee emp;
DataTable dt = new DataTable();
dt.Columns.Add(MEmployee.ColumnNames.EmployeeId);
dt.Columns.Add(MEmployee.ColumnNames.EmployeeName);
DataRow dr = dt.NewRow();
dr[0] = "";
dr[1] = "-Semua Karyawan-";
dt.Rows.Add(dr);
for (int i = 0; i < listEmp.Count; i++)
{
emp = (MEmployee)listEmp[i];
dr = dt.NewRow();
dr[0] = emp.EmployeeId;
dr[1] = emp.EmployeeName;
dt.Rows.Add(dr);
}
cb.DropDownStyle = ComboBoxStyle.DropDownList;
cb.DataSource = dt;
cb.ValueMember = MEmployee.ColumnNames.EmployeeId;
cb.DisplayMember = MEmployee.ColumnNames.EmployeeName;
cb.Show();
}
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 button1_Click(object sender, EventArgs e)
{
DataMasterMgtServices DataMaster = new DataMasterMgtServices();
TMenuUser tmenu = (TMenuUser)DataMaster.GetObjectByProperty(typeof(TMenuUser), TMenuUser.ColumnNames.MenuId, Convert.ToDecimal(treeView1.SelectedNode.Tag), TMenuUser.ColumnNames.SettingId, AppCode.AssemblyProduct, TMenuUser.ColumnNames.UserName, lbl_UserName.Text);
bool isSave = false;
if (tmenu == null)
{
tmenu = new TMenuUser();
isSave = true;
}
tmenu.HasAccess = true;
tmenu.MenuId = Convert.ToDecimal(treeView1.SelectedNode.Tag);
tmenu.ModifiedBy = lbl_UserName.Text;
tmenu.ModifiedDate = DateTime.Now;
tmenu.SettingId = AppCode.AssemblyProduct;
tmenu.UserName = lbl_UserName.Text;
if (isSave)
{
DataMaster.SavePersistence(tmenu);
}
else
{
DataMaster.UpdatePersistence(tmenu);
}
}
public FormLoginForApotek()
{
InitializeComponent();
DataMasterMgtServices DataMaster = new DataMasterMgtServices();
MSetting set = (MSetting)DataMaster.GetObjectByProperty(typeof(MSetting), MSetting.ColumnNames.SettingId, AppCode.AssemblyProduct);
this.Text = AppCode.AssemblyProduct + " " + set.CompanyName;
this.Icon = Properties.Resources.logo_apotek_ico;
}
public static void SetGudangComboBox(ComboBox cb)
{
DataMasterMgtServices DataMaster = new DataMasterMgtServices();
IList listGudang = DataMaster.GetAll(typeof(MGudang));
cb.DropDownStyle = ComboBoxStyle.DropDownList;
cb.DataSource = listGudang;
cb.ValueMember = MGudang.ColumnNames.GudangId;
cb.DisplayMember = MGudang.ColumnNames.GudangName;
cb.Show();
}
public static void SupplierValidating(string supplierId, TextBox supplierNameTextBox)
{
DataMasterMgtServices DataMaster = new DataMasterMgtServices();
MSupplier supp = (MSupplier)DataMaster.GetObjectByProperty(typeof(MSupplier), MSupplier.ColumnNames.SupplierId, supplierId);
if (supp != null)
{
supplierNameTextBox.Text = supp.SupplierName;
}
else
{
supplierNameTextBox.ResetText();
}
}
public static void EmployeeValidating(string employeeId, TextBox employeeNameTextBox)
{
DataMasterMgtServices DataMaster = new DataMasterMgtServices();
MEmployee emp = (MEmployee)DataMaster.GetObjectByProperty(typeof(MEmployee), MEmployee.ColumnNames.EmployeeId, employeeId);
if (emp != null)
{
employeeNameTextBox.Text = emp.EmployeeName;
}
else
{
employeeNameTextBox.ResetText();
}
}
public static void EkspedissionValidating(string ekspedissionId, TextBox ekspedissionNameTextBox)
{
DataMasterMgtServices DataMaster = new DataMasterMgtServices();
MEkspedission eks = (MEkspedission)DataMaster.GetObjectByProperty(typeof(MEkspedission), MEkspedission.ColumnNames.EkspedissionId, ekspedissionId);
if (eks != null)
{
ekspedissionNameTextBox.Text = eks.EkspedissionName;
}
else
{
ekspedissionNameTextBox.ResetText();
}
}
public static bool HavePriviledges(string userName, int MenuId, string SettingId)
{
DataMasterMgtServices DataMaster = new DataMasterMgtServices();
TMenuUser userMenu = (TMenuUser)DataMaster.GetObjectByProperty(typeof(TMenuUser), TMenuUser.ColumnNames.UserName, userName, TMenuUser.ColumnNames.MenuId, Convert.ToDecimal(MenuId), TMenuUser.ColumnNames.SettingId, SettingId);
if (userMenu != null)
{
return(userMenu.HasAccess);
}
else
{
return(false);
}
}
public static void CustomerValidating(string customerId, TextBox customerNameTextBox)
{
DataMasterMgtServices DataMaster = new DataMasterMgtServices();
MCustomer cust = (MCustomer)DataMaster.GetObjectByProperty(typeof(MCustomer), MCustomer.ColumnNames.CustomerId, customerId);
if (cust != null)
{
customerNameTextBox.Text = cust.CustomerName;
}
else
{
customerNameTextBox.ResetText();
}
}
internal static string GetSupplierName(string SupplierId)
{
DataMasterMgtServices DataMaster = new DataMasterMgtServices();
MSupplier sup = DataMaster.GetObjectByProperty(typeof(MSupplier), MSupplier.ColumnNames.SupplierId, SupplierId) as MSupplier;
if (sup != null)
{
return(sup.SupplierName);
}
else
{
return(string.Empty);
}
}
public static void SetGroupComboBox(ComboBox cb)
{
DataMasterMgtServices DataMaster = new DataMasterMgtServices();
IList listGroup = DataMaster.GetAll(typeof(MGroup));
cb.DropDownStyle = ComboBoxStyle.DropDownList;
if (listGroup.Count > 0)
{
cb.DataSource = listGroup;
cb.DisplayMember = "GroupName";
cb.ValueMember = "GroupId";
cb.Show();
}
}
public static void SetDepartmentComboBox(ComboBox cb)
{
DataMasterMgtServices DataMaster = new DataMasterMgtServices();
cb.DropDownStyle = ComboBoxStyle.DropDownList;
IList listDepartment = DataMaster.GetAll(typeof(MDep));
if (listDepartment.Count > 0)
{
cb.DataSource = listDepartment;
cb.DisplayMember = "DepName";
cb.ValueMember = "DepId";
cb.Show();
}
}
public static void SetItemTextBoxSuggest(TextBox txt)
{
txt.AutoCompleteMode = AutoCompleteMode.SuggestAppend;
txt.AutoCompleteSource = AutoCompleteSource.CustomSource;
txt.AutoCompleteCustomSource.Clear();
DataMasterMgtServices DataMaster = new DataMasterMgtServices();
IList listItem = DataMaster.GetAll(typeof(MItem));
MItem item;
for (int i = 0; i < listItem.Count; i++)
{
item = (MItem)listItem[i];
txt.AutoCompleteCustomSource.Add(item.ItemId);
}
}
public static void SetCustomerTextBoxSuggest(TextBox txt)
{
txt.AutoCompleteMode = AutoCompleteMode.SuggestAppend;
txt.AutoCompleteSource = AutoCompleteSource.CustomSource;
txt.AutoCompleteCustomSource.Clear();
DataMasterMgtServices DataMaster = new DataMasterMgtServices();
IList listCust = DataMaster.GetAll(typeof(MCustomer));
MCustomer cust;
for (int i = 0; i < listCust.Count; i++)
{
cust = (MCustomer)listCust[i];
txt.AutoCompleteCustomSource.Add(cust.CustomerId);
}
}
public static void SetSupplierTextBoxSuggest(TextBox txt)
{
txt.AutoCompleteMode = AutoCompleteMode.SuggestAppend;
txt.AutoCompleteSource = AutoCompleteSource.CustomSource;
txt.AutoCompleteCustomSource.Clear();
DataMasterMgtServices DataMaster = new DataMasterMgtServices();
IList listSupp = DataMaster.GetAll(typeof(MSupplier));
MSupplier supp;
for (int i = 0; i < listSupp.Count; i++)
{
supp = (MSupplier)listSupp[i];
txt.AutoCompleteCustomSource.Add(supp.SupplierId);
}
}
public FormLogin()
{
InitializeComponent();
DataMasterMgtServices DataMaster = new DataMasterMgtServices();
MSetting set = (MSetting)DataMaster.GetObjectByProperty(typeof(MSetting), MSetting.ColumnNames.SettingId, AppCode.AssemblyProduct);
if (set != null)
{
this.Text = AppCode.AssemblyProduct + " " + set.CompanyName;
}
this.Icon = Properties.Resources.inventori_ico;
this.Load += new EventHandler(FormLogin_Load);
this.Shown += new EventHandler(FormLogin_Shown);
buttonOK.Click += new EventHandler(buttonOK_Click);
}
public static void SetEmployeeTextBoxSuggest(TextBox txt)
{
txt.AutoCompleteMode = AutoCompleteMode.SuggestAppend;
txt.AutoCompleteSource = AutoCompleteSource.CustomSource;
txt.AutoCompleteCustomSource.Clear();
DataMasterMgtServices DataMaster = new DataMasterMgtServices();
IList listEmployee = DataMaster.GetAll(typeof(MEmployee));
MEmployee emp;
for (int i = 0; i < listEmployee.Count; i++)
{
emp = (MEmployee)listEmployee[i];
txt.AutoCompleteCustomSource.Add(emp.EmployeeId);
}
}
public static void SetTypeItemComboBox(ComboBox cb)
{
DataMasterMgtServices DataMaster = new DataMasterMgtServices();
cb.DropDownStyle = ComboBoxStyle.DropDownList;
IList listItemType = DataMaster.GetAll(typeof(MItemType));
if (listItemType.Count > 0)
{
cb.DataSource = listItemType;
cb.DisplayMember = "ItemTypeName";
cb.ValueMember = "ItemTypeId";
cb.Show();
}
}
public static void SetTransactionTextBoxSuggest(TextBox txt, ListOfTransaction tr, string SupplierId)
{
txt.AutoCompleteMode = AutoCompleteMode.SuggestAppend;
txt.AutoCompleteSource = AutoCompleteSource.CustomSource;
txt.AutoCompleteCustomSource.Clear();
DataMasterMgtServices DataMaster = new DataMasterMgtServices();
IList listTrans = DataMaster.GetListEq(typeof(TTransaction), TTransaction.ColumnNames.TransactionStatus, tr.ToString(), TTransaction.ColumnNames.TransactionBy, SupplierId);
TTransaction trans;
for (int i = 0; i < listTrans.Count; i++)
{
trans = (TTransaction)listTrans[i];
txt.AutoCompleteCustomSource.Add(trans.TransactionFactur);
}
}
