public bool Insert(DTO_Group _Group)
{
Connet();
string sql = "insert into Group ( ID, Group_Name, AccountID, Phone) values (@ID, @Group_Name, @AccountID, @Phone)";
try
{
_cmd = new SqlCommand(sql, _conn);
_cmd.Parameters.Add("@ID", SqlDbType.VarChar).Value = _Group.ID;
_cmd.Parameters.Add("@Group_Name", SqlDbType.VarChar).Value = _Group.Group_Name;
_cmd.Parameters.Add("@AccountID", SqlDbType.VarChar).Value = _Group.AccountID;
_cmd.Parameters.Add("@Phone", SqlDbType.VarChar).Value = _Group.Phone;
_cmd.ExecuteNonQuery();
_cmd.Dispose();
Disconnet();
}
catch (Exception ex)
{
Disconnet();
return(false);
throw ex;
}
return(true);
}
public bool Update(DTO_Group _Group)
{
Connet();
string sql = "update Group set Group_Name=@Group_Name,AccountID=@AccountID,Phone=@APhone Where ID=@ID";
try
{
_cmd = new SqlCommand(sql, _conn);
_cmd.Parameters.Add("@ID", SqlDbType.VarChar).Value = _Group.ID;
_cmd.Parameters.Add("@Group_Name", SqlDbType.VarChar).Value = _Group.Group_Name;
_cmd.Parameters.Add("@AccountID", SqlDbType.VarChar).Value = _Group.AccountID;
_cmd.Parameters.Add("@Phone", SqlDbType.VarChar).Value = _Group.Phone;
_cmd.ExecuteNonQuery();
_cmd.Dispose();
Disconnet();
}
catch (Exception ex)
{
Disconnet();
return(false);
throw ex;
}
return(true);
}
public DTO_Group GetNhomByID(string strMaNhom)
{
if (strMaNhom == null)
{
return(null);
}
DTO_Group res = null;
using (var context = new SQLServerDBContext())
{
res = context.Group.Where(g => g.MaNhom == strMaNhom).FirstOrDefault();
}
return(res);
}
public bool Delete(DTO_Group _Group)
{
Connet();
string sql = "delete from Group where ID=@ID";
try
{
_cmd = new SqlCommand(sql, _conn);
_cmd.Parameters.Add("@ID", SqlDbType.VarChar).Value = _Group.ID;
_cmd.ExecuteNonQuery();
_cmd.Dispose();
Disconnet();
}
catch (Exception ex)
{
Disconnet();
return(false);
throw ex;
}
return(true);
}
public bool Update(DTO_Group _group)
{
return(_Group.Update(_group));
}
public bool Delete(DTO_Group _group)
{
return(_Group.Delete(_group));
}
public bool Insert(DTO_Group _group)
{
return(_Group.Insert(_group));
}
