public frmAddItems()
{
InitializeComponent();
_item = new C_Items();
_unit = new C_Unit();
_groupItem = new C_GroupItem();
}
public frmAppointment()
{
_item = new C_Items();
_unit = new C_Unit();
_staff = new C_Staff();
_receipt = new C_Receipt();
_dtreceipt = new C_DetailsReceipt();
InitializeComponent();
}
public frmUseService()
{
InitializeComponent();
_staffUser = new C_Staff_User();
_dtreceipt = new C_DetailsReceipt();
usr = new UserManager();
_item = new C_Items();
_receipt = new C_Receipt();
_cus = new CustomerManager();
_unit = new C_Unit();
_staff = new C_Staff();
idBranch = _staffUser.GetIdBranch_User(Program.loginForm.NameAccount);//GetId loginForm
}
public List <C_Unit> GetUnits()
{
var entities = new List <C_Unit>();
using (var rdr = SqlHelper.ExecuteReader(this._databaseConnectionString, CommandType.Text, SqlCommands_Rs.Sql_C_Unit_Repository_GetUnits, null)) {
while (rdr.Read())
{
var entity = new C_Unit();
entity.Id = SqlTypeConverter.DBNullStringHandler(rdr["Id"]);
entity.Name = SqlTypeConverter.DBNullStringHandler(rdr["Name"]);
entity.Comment = SqlTypeConverter.DBNullStringHandler(rdr["Desc"]);
entity.Enabled = SqlTypeConverter.DBNullBooleanHandler(rdr["Enabled"]);
entities.Add(entity);
}
}
return(entities);
}
public C_Unit GetUnit(string id)
{
SqlParameter[] parms = { new SqlParameter("@Id", SqlDbType.VarChar, 100) };
parms[0].Value = SqlTypeConverter.DBNullStringChecker(id);
C_Unit entity = null;
using (var rdr = SqlHelper.ExecuteReader(this._databaseConnectionString, CommandType.Text, SqlCommands_Rs.Sql_C_Unit_Repository_GetUnit, parms)) {
if (rdr.Read())
{
entity = new C_Unit();
entity.Id = SqlTypeConverter.DBNullStringHandler(rdr["Id"]);
entity.Name = SqlTypeConverter.DBNullStringHandler(rdr["Name"]);
entity.Comment = SqlTypeConverter.DBNullStringHandler(rdr["Desc"]);
entity.Enabled = SqlTypeConverter.DBNullBooleanHandler(rdr["Enabled"]);
}
}
return(entity);
}
