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