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