public List <MasItemDTO> GetSearchItemDetailByID(Int32 ItemID) { List <MasItemDTO> lst = new List <MasItemDTO>(); MasItemDTO item = new MasItemDTO(); try { List <SqlParameter> param = new List <SqlParameter>(); param.Add(new SqlParameter() { ParameterName = "ItemID", Value = ItemID, DbType = DbType.Int32 }); DataSet ds = conn.GetDataSet("GetSearchItemDetailByID", param); if (ds != null && ds.Tables.Count > 0 && ds.Tables[0] != null) { foreach (DataRow dr in ds.Tables[0].Rows) { item = new MasItemDTO(); item.TID = Convert.ToInt32(dr["TID"].ToString()); item.ItemID = Convert.ToInt32(dr["ItemID"].ToString()); item.ItemDetail = dr["ItemDetail"].ToString(); item.DetailOrder = Convert.ToInt32(dr["DetailOrder"].ToString()); item.CanChange = dr["CanChange"].ToString(); lst.Add(item); } } } catch (Exception ex) { } return(lst); }
public List <MasItemDTO> GetSearchItem() { List <MasItemDTO> lst = new List <MasItemDTO>(); try { List <SqlParameter> param = new List <SqlParameter>(); DataSet ds = conn.GetDataSet("GetSearchItem", param); if (ds != null && ds.Tables.Count > 0 && ds.Tables[0] != null) { MasItemDTO o = new MasItemDTO(); foreach (DataRow dr in ds.Tables[0].Rows) { o = new MasItemDTO(); o.ItemID = Convert.ToInt32(dr["ItemID"].ToString()); o.ItemCode = dr["ItemCode"].ToString(); o.ItemName = dr["ItemName"].ToString(); o.ItemDesc = dr["ItemDesc"].ToString(); o.ItemPrice = Convert.ToDouble(dr["ItemPrice"].ToString()); o.UnitName = dr["UnitName"].ToString(); o.Active = dr["Active"].ToString(); lst.Add(o); } } } catch (Exception ex) { } return(lst); }
public string UpdateMasItem(MasItemDTO item) { string err = ""; try { List <SqlParameter> paramI = new List <SqlParameter>(); paramI.Add(new SqlParameter() { ParameterName = "ItemID", Value = item.ItemID, DbType = DbType.Int32 }); paramI.Add(new SqlParameter() { ParameterName = "ItemCode", Value = item.ItemCode }); paramI.Add(new SqlParameter() { ParameterName = "ItemName", Value = item.ItemName }); paramI.Add(new SqlParameter() { ParameterName = "ItemDesc", Value = item.ItemDesc }); paramI.Add(new SqlParameter() { ParameterName = "ItemPrice", Value = item.ItemPrice, DbType = DbType.Double }); paramI.Add(new SqlParameter() { ParameterName = "UnitID", Value = item.UnitID, DbType = DbType.Int32 }); paramI.Add(new SqlParameter() { ParameterName = "ItemTypeID", Value = item.ItemTypeID, DbType = DbType.Int32 }); paramI.Add(new SqlParameter() { ParameterName = "DistID", Value = item.UnitID, DbType = DbType.Int32 }); paramI.Add(new SqlParameter() { ParameterName = "MinRemaining", Value = item.MinRemaining, DbType = DbType.Int32 }); paramI.Add(new SqlParameter() { ParameterName = "User", Value = item.UpdatedBy }); conn.ExcuteNonQueryNClose("UpdateMasItem", paramI, out err); } catch (Exception ex) { err = ex.Message; } return(err); }
public string DeleteMasItem(MasItemDTO item) { string err = ""; try { List <SqlParameter> paramI = new List <SqlParameter>(); paramI.Add(new SqlParameter() { ParameterName = "ItemID", Value = item.ItemID, DbType = DbType.Int32 }); paramI.Add(new SqlParameter() { ParameterName = "User", Value = item.UpdatedBy }); conn.ExcuteNonQueryNClose("DeleteMasItem", paramI, out err); } catch (Exception ex) { err = ex.Message; } return(err); }
public MasItemDTO GetSearchItemByID(Int32 ItemID) { MasItemDTO item = new MasItemDTO(); try { List <SqlParameter> param = new List <SqlParameter>(); param.Add(new SqlParameter() { ParameterName = "ItemID", Value = ItemID, DbType = DbType.Int32 }); DataSet ds = conn.GetDataSet("GetSearchItemByID", param); if (ds != null && ds.Tables.Count > 0 && ds.Tables[0] != null) { foreach (DataRow dr in ds.Tables[0].Rows) { item = new MasItemDTO(); item.ItemID = Convert.ToInt32(dr["ItemID"].ToString()); item.ItemCode = dr["ItemCode"].ToString(); item.ItemName = dr["ItemName"].ToString(); item.ItemDesc = dr["ItemDesc"].ToString(); item.ItemPrice = Convert.ToDouble(dr["ItemPrice"].ToString()); item.UnitID = Convert.ToInt32(dr["UnitID"].ToString()); item.ItemTypeID = Convert.ToInt32(dr["ItemTypeID"].ToString()); item.DistributorID = Convert.ToInt32(dr["DistributorID"].ToString()); item.MinRemaining = Convert.ToInt32(dr["MinRemaining"].ToString()); break; } } } catch (Exception ex) { } return(item); }