public int UpdateAccount(Model.Criteria.M_AccountCriteria criteria) { try { Class.clsDB db = new Class.clsDB(); string sql; sql = "Update account SET "; sql += "title='" + criteria.title + "',"; sql += "name='" + criteria.name + "',"; sql += "surname='" + criteria.surname + "',"; sql += "username='******',"; sql += "password='******',"; sql += "level='" + criteria.level + "',"; sql += "signature='" + criteria.signature + "' WHERE "; sql += " email='" + criteria.email + "'"; int ret; ret = db.ExecuteNonQuery(sql); db.Close(); return(ret); } catch (Exception ex) { return(0); } }
public int InsertAccount(Model.Criteria.M_AccountCriteria criteria) { try { Class.clsDB db = new Class.clsDB(); string sql; sql = "Insert into account ( "; sql += "title,"; sql += "name,"; sql += "surname,"; sql += "username,"; sql += "password,"; sql += "level,"; sql += "signature,"; sql += " email) VALUES("; sql += "'" + criteria.title + "',"; sql += "'" + criteria.name + "',"; sql += "'" + criteria.surname + "',"; sql += "'" + criteria.username + "',"; sql += "'" + criteria.password + "',"; sql += "'" + criteria.level + "',"; sql += "'" + criteria.signature + "',"; sql += "'" + criteria.email + "')"; int ret; ret = db.ExecuteNonQuery(sql); db.Close(); return(ret); } catch (Exception ex) { return(0); } }
public List <Model.M_Account> getAccount(Model.Criteria.M_AccountCriteria criteria, ref int rsTotalRecord) { try { DataSet ds = new DataSet(); String sql; sql = "Select * From account"; Class.clsDB db = new Class.clsDB(); ds = db.ExecuteDataSet(sql); var result = ds.Tables[0].AsEnumerable().Select(s => new Model.M_Account { title = s.Field <string>("title"), name = s.Field <string>("name"), surname = s.Field <string>("surname"), username = s.Field <string>("username"), password = s.Field <string>("password"), email = s.Field <string>("email"), }).ToList(); return(result); } catch (Exception ex) { throw ex; } finally { } }
public static Json <Model.M_Account> getAccount(Model.Criteria.M_AccountCriteria criteria, Helper.JqGridParameter gridParam) { BLL.ManageAccount _BLL = new BLL.ManageAccount(); int rsTotalRecord = 0; var result = _BLL.getAccount(criteria, ref rsTotalRecord); //turn Helper.UtilityHelper.ToJqGridResult<Models.M_Department_SearchLv1>(gridParam, result, rsTotalRecord); return(Helper.Utility.ToJqGridResult <Model.M_Account>(gridParam, result)); }
protected void initDataAccount(string mailAccount) { DataTable dt; BLL.ManageAccount _BLL = new BLL.ManageAccount(); Model.Criteria.M_AccountCriteria criteria = new Model.Criteria.M_AccountCriteria(); criteria.email = mailAccount; dt = _BLL.getAccount_By_Email(criteria); if (dt.Rows.Count > 0) { Account.title = dt.Rows[0]["title"].ToString(); Account.name = dt.Rows[0]["name"].ToString(); Account.surname = dt.Rows[0]["surname"].ToString(); } }
public DataTable getAccount_By_Email(Model.Criteria.M_AccountCriteria criteria) { try { DataSet ds = new DataSet(); String sql; sql = "Select * From account where email='" + criteria.email + "'"; Class.clsDB db = new Class.clsDB(); ds = db.ExecuteDataSet(sql); db.Close(); return(ds.Tables[0]); } catch (Exception ex) { throw ex; } finally { } }
public int InsertAccount(Model.Criteria.M_AccountCriteria criteria) { return(_objDAL.InsertAccount(criteria)); }
public int UpdateAccount(Model.Criteria.M_AccountCriteria criteria) { return(_objDAL.UpdateAccount(criteria)); }
public DataTable getAccount_By_Email(Model.Criteria.M_AccountCriteria criteria) { return(_objDAL.getAccount_By_Email(criteria)); }
public List <Model.M_Account> getAccount(Model.Criteria.M_AccountCriteria criteria, ref int rsTotalRecord) { return(_objDAL.getAccount(criteria, ref rsTotalRecord)); }