public static UOMs GetEntity(decimal uomID) { UOMs uom = null; using (SqlConnection cn = new SqlConnection(Common.ConnectionString)) { string proc = "pr_UOM_Get"; using (SqlCommand cmd = new SqlCommand(proc, cn)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@UOM_ID", uomID); cn.Open(); SqlDataReader rdr = cmd.ExecuteReader(CommandBehavior.CloseConnection); if (rdr.HasRows) { rdr.Read(); uom = FillUOM(rdr); } if (!rdr.IsClosed) { rdr.Close(); } } } return(uom); }
public static List <UOMs> GetEntityList() { List <UOMs> uomList = new List <UOMs>(); using (SqlConnection cn = new SqlConnection(Common.ConnectionString)) { string proc = "pr_UOM_GetList"; using (SqlCommand cmd = new SqlCommand(proc, cn)) { cmd.CommandType = CommandType.StoredProcedure; cn.Open(); SqlDataReader rdr = cmd.ExecuteReader(CommandBehavior.CloseConnection); while (rdr.Read()) { UOMs uom = FillUOM(rdr); uomList.Add(uom); } if (!rdr.IsClosed) { rdr.Close(); } } } return(uomList); }
private static UOMs FillUOM(SqlDataReader rdr) { UOMs uom = new UOMs(); uom.UOM_ID = Convert.ToDecimal(rdr["UOM_ID"]); uom.UOM = rdr["UOM"].ToString(); uom.UOM_Desc = rdr["UOM_Desc"].ToString(); return(uom); }
public static UOMs SaveEntity(UOMs uom) { if (uom.UOM_ID > 0) { return(UpdateEntity(uom)); } else { return(AddEntity(uom)); } }
public static void DeleteEntity(UOMs uom) { using (SqlConnection cn = new SqlConnection(Common.ConnectionString)) { string proc = "pr_UOM_Delete"; using (SqlCommand cmd = new SqlCommand(proc, cn)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@UOM_ID", uom.UOM_ID); cn.Open(); cmd.ExecuteNonQuery(); } } }
private void Delete() { UOMs uom = uomBindingSource.Current as UOMs; // (BindingList<UOMs>)userBindingSource.DataSource; //UOMs uom = OrderList[userBindingSource.Position]; decimal UOM_ID = uom.UOM_ID; DialogResult dlg = MessageBox.Show(string.Format("Are you sure you want to delete UOM # {0}?", UOM_ID.ToString())); if (dlg == System.Windows.Forms.DialogResult.OK) { UOMs.DeleteEntity(uom); uomBindingSource.RemoveCurrent(); MessageBox.Show(string.Format("UOM # {0} was deleted.", UOM_ID.ToString())); } }
private void Save() { uomBindingSource.EndEdit(); UOMs uom = uomBindingSource.Current as UOMs; //BindingList<UOMs> OrderList = (BindingList<UOMs>)userBindingSource.DataSource; //UOMs UOMs = OrderList[userBindingSource.Position]; UOMs.SaveEntity(uom); BindingList <UOMs> uomList = new BindingList <UOMs>(UOMs.GetEntityList()); uomBindingSource.DataSource = uomList; MessageBox.Show("UOM was saved."); }
private void toolBtnFindOrderNumber_Click(object sender, EventArgs e) { List <UOMs> uomList = new List <UOMs>(uomBindingSource.DataSource as BindingList <UOMs>); UOMFilter uomFilter = new UOMFilter(Convert.ToInt32(toolTxtFindOrderNumber.Text)); //Predicate<UOMs> filterByOrderID = new Predicate<UOMs>(orderFilter.MatchesOrderID); Predicate <UOMs> filterByOrderID = new Predicate <UOMs>(uomFilter.BeginsWithOrderID); UOMs uom = uomList.Find(filterByOrderID); if (uom == null) { MessageBox.Show("No matching UOM found", "Not Found", MessageBoxButtons.OK); } else { int index = uomBindingSource.IndexOf(uom); uomBindingSource.Position = index; } }
private static UOMs UpdateEntity(UOMs uom) { using (SqlConnection cn = new SqlConnection(Common.ConnectionString)) { string proc = "pr_UOM_Update"; using (SqlCommand cmd = new SqlCommand(proc, cn)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@UOM_ID", uom.UOM_ID); cmd.Parameters.AddWithValue("@UOM", uom.UOM); cmd.Parameters.AddWithValue("@UOM_Desc", uom.UOM_Desc); cmd.Parameters.AddWithValue("@t_user", uom.t_user); cn.Open(); cmd.ExecuteNonQuery(); } } uom = GetEntity(uom.UOM_ID); return(uom); }
private static UOMs AddEntity(UOMs uom) { int UOM_ID = 0; using (SqlConnection cn = new SqlConnection(Common.ConnectionString)) { string proc = "pr_UOM_Add"; using (SqlCommand cmd = new SqlCommand(proc, cn)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@UOM", uom.UOM); cmd.Parameters.AddWithValue("@UOM_Desc", uom.UOM_Desc); cmd.Parameters.AddWithValue("@t_user", uom.t_user); cmd.Parameters.Add(new SqlParameter("@UOM_ID", SqlDbType.Int)); cmd.Parameters["@UOM_ID"].Direction = ParameterDirection.Output; cn.Open(); cmd.ExecuteNonQuery(); UOM_ID = Convert.ToInt32(cmd.Parameters["@UOM_ID"].Value); } uom = GetEntity(UOM_ID); } return(uom); }
private void SetupBindings() { BindingList <UOMs> uomList = new BindingList <UOMs>(UOMs.GetEntityList()); uomBindingSource.DataSource = uomList; }
public bool BeginsWithOrderID(UOMs uom) { return(uom.UOM_ID.ToString().StartsWith(UOM_ID.ToString())); }
public bool MatchesOrderID(UOMs uom) { return(uom.UOM_ID == UOM_ID); }