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