public List <Model.Document> getAll_Document(Model.Criteria.Document criteria)
{
//string connStr = Properties.Settings.Default.InventoryControl_ConnectionString;
//SqlConnection conn = Common.DataHelper.getSQLServerConnectionObject(connStr);
DataSet ds = new DataSet();
String sql;
sql = "Select * From document where doc_id=" + criteria.doc_id;
Class.clsDB db = new Class.clsDB();
ds = db.ExecuteDataSet(sql);
db.Close();
//SqlDataAdapter adp = new SqlDataAdapter("usp_Permission_Read", conn);
//adp.SelectCommand.CommandType = CommandType.StoredProcedure;
//adp.SelectCommand.Parameters.Add(new SqlParameter("@PRJ_Code", criteria.PRJ_Code));
//adp.SelectCommand.Parameters.Add(new SqlParameter("@UserAccount", criteria.UserAccount));
//adp.SelectCommand.Parameters.Add(new SqlParameter("@PAG_Code", criteria.PAG_Code));
// adp.Fill(ds);
return(ds.Tables[0].AsEnumerable().Select(s => new Model.Document
{
doc_id_int = s.Field <int>("doc_id"),
doc_name = s.Field <string>("doc_name"),
secure_approve = s.Field <string>("secure_approve"),
secure_prepare = s.Field <string>("secure_prepare"),
approve_problem = s.Field <string>("approve_problem"),
content = s.Field <string>("content")
}).ToList());
}
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 List <Model.Account> getEmail_Level2()
{
//string connStr = Properties.Settings.Default.InventoryControl_ConnectionString;
//SqlConnection conn = Common.DataHelper.getSQLServerConnectionObject(connStr);
DataSet ds = new DataSet();
String sql;
sql = "Select * From account where level='2'";
Class.clsDB db = new Class.clsDB();
ds = db.ExecuteDataSet(sql);
db.Close();
//SqlDataAdapter adp = new SqlDataAdapter("usp_Permission_Read", conn);
//adp.SelectCommand.CommandType = CommandType.StoredProcedure;
//adp.SelectCommand.Parameters.Add(new SqlParameter("@PRJ_Code", criteria.PRJ_Code));
//adp.SelectCommand.Parameters.Add(new SqlParameter("@UserAccount", criteria.UserAccount));
//adp.SelectCommand.Parameters.Add(new SqlParameter("@PAG_Code", criteria.PAG_Code));
// adp.Fill(ds);
return(ds.Tables[0].AsEnumerable().Select(s => new Model.Account
{
Title = s.Field <string>("Title"),
Name = s.Field <string>("Name"),
Surname = s.Field <string>("Surname"),
Email = s.Field <string>("Email"),
}).ToList());
}
public List <Model.Account> getEmail()
{
DataSet ds = new DataSet();
String sql;
sql = "Select * From account";
Class.clsDB db = new Class.clsDB();
ds = db.ExecuteDataSet(sql);
return(ds.Tables[0].AsEnumerable().Select(s => new Model.Account
{
Title = s.Field <string>("Title"),
Name = s.Field <string>("Name"),
Surname = s.Field <string>("Surname"),
Email = s.Field <string>("Email"),
}).ToList());
}
public List <MODEL.jobDetail> getJobDetail(MODEL.Criteria.jobDetail criteria)
{
DataSet ds = new DataSet();
String sql;
sql = "Select * From job_detail where show_=1";
Class.clsDB db = new Class.clsDB();
ds = db.ExecuteDataSet(sql);
db.Close();
return(ds.Tables[0].AsEnumerable().Select(s => new MODEL.jobDetail
{
job_id = s.Field <string>("job_id"),
//place_get_job = s.Field<string>("place_get_job"),
//container_type = s.Field<string>("container_type"),
//container_dim = s.Field<string>("container_dim"),
}).ToList());
}
public DataTable GetCustomer()
{
DataTable table;
try
{
DataSet set = new DataSet();
string strSQL = "Select * From supplier order by supp_short_name ";
Class.clsDB sdb1 = new Class.clsDB();
set = sdb1.ExecuteDataSet(strSQL);
sdb1.Close();
table = set.Tables[0];
}
catch (Exception exception1)
{
throw exception1;
}
return(table);
}
public DataTable ExecuteDatatable(string sql)
{
try
{
DataSet ds = new DataSet();
Class.clsDB db = new Class.clsDB();
ds = db.ExecuteDataSet(sql);
db.Close();
return(ds.Tables[0]);
}
catch (Exception ex)
{
throw ex;
}
finally
{
}
}
public DataTable getDocument_By_DocId(string doc_id)
{
try
{
DataSet ds = new DataSet();
String sql;
sql = "Select * From document where doc_id = '" + doc_id + "'";
Class.clsDB db = new Class.clsDB();
ds = db.ExecuteDataSet(sql);
db.Close();
return(ds.Tables[0]);
}
catch (Exception ex)
{
throw ex;
}
finally
{
}
}
public DataTable NotPrice()
{
try
{
DataSet ds = new DataSet();
String sql;
sql = "select no,price from temp where price = 0";
Class.clsDB db = new Class.clsDB();
ds = db.ExecuteDataSet(sql);
db.Close();
return(ds.Tables[0]);
}
catch (Exception ex)
{
throw ex;
}
finally
{
}
}
public DataTable CountUnder()
{
try
{
DataSet ds = new DataSet();
String sql;
sql = "select count(*) as c from temp2under where price > 0";
Class.clsDB db = new Class.clsDB();
ds = db.ExecuteDataSet(sql);
db.Close();
return(ds.Tables[0]);
}
catch (Exception ex)
{
throw ex;
}
finally
{
}
}
public DataTable getDataTemp2under()
{
try
{
DataSet ds = new DataSet();
String sql;
sql = "Select * From Temp2under";
Class.clsDB db = new Class.clsDB();
ds = db.ExecuteDataSet(sql);
db.Close();
return(ds.Tables[0]);
}
catch (Exception ex)
{
throw ex;
}
finally
{
}
}
public DataTable BindFilename()
{
try
{
DataSet ds = new DataSet();
String sql;
sql = "select * from tb_file_name ";
Class.clsDB db = new Class.clsDB();
ds = db.ExecuteDataSet(sql);
db.Close();
return(ds.Tables[0]);
}
catch (Exception ex)
{
throw ex;
}
finally
{
}
}
public DataTable getAccount_Level1()
{
try
{
DataSet ds = new DataSet();
String sql;
sql = "Select * From account where level = '1'";
Class.clsDB db = new Class.clsDB();
ds = db.ExecuteDataSet(sql);
db.Close();
return(ds.Tables[0]);
}
catch (Exception ex)
{
throw ex;
}
finally
{
}
}
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 DataTable GetCustomerByID(string id)
{
DataTable table;
try
{
if (id == "")
{
id = "0";
}
DataSet set = new DataSet();
string strSQL = "Select * From supplier Where supp_code = " + id + " order by supp_short_name ";
Class.clsDB sdb1 = new Class.clsDB();
set = sdb1.ExecuteDataSet(strSQL);
sdb1.Close();
table = set.Tables[0];
}
catch (Exception exception1)
{
throw exception1;
}
return(table);
}
