public POSInfo Get(
String USER_ID,
ref string sErr)
{
POSInfo objEntr = new POSInfo();
connect();
InitSPCommand(_strSPGetName);
AddParameter("USER_ID", USER_ID);
DataTable list = new DataTable();
try
{
list = executeSelectSP(command);
}
catch (Exception ex)
{
sErr = ex.Message;
}
disconnect();
if (list.Rows.Count > 0)
{
objEntr = (POSInfo)GetDataFromDataRow(list, 0);
}
//if (dr != null) list = CBO.FillCollection(dr, ref list);
if (sErr != "")
{
ErrorLog.SetLog(sErr);
}
return(objEntr);
}
public DataTableCollection Get_Page(POSInfo obj, string orderBy, int pageIndex, int pageSize, ref String sErr)
{
string whereClause = CreateWhereClause(obj);
DataTableCollection dtList = null;
connect();
InitSPCommand(_strSPGetPages);
AddParameter("WhereClause", whereClause);
AddParameter("OrderBy", orderBy);
AddParameter("PageIndex", pageIndex);
AddParameter("PageSize", pageSize);
try
{
dtList = executeCollectSelectSP();
}
catch (Exception ex)
{
sErr = ex.Message;
}
disconnect();
if (sErr != "")
{
ErrorLog.SetLog(sErr);
}
return(dtList);
}
public string Update(POSInfo objEntr)
{
connect();
InitSPCommand(_strSPUpdateName);
AddParameter("USER_ID", objEntr.USER_ID);
AddParameter("CURRENT_DB", objEntr.CURRENT_DB);
AddParameter("CURRENT_ACTIVITY", objEntr.CURRENT_ACTIVITY);
AddParameter("WORK_STATION", objEntr.WORK_STATION);
AddParameter("LOGIN_TIME", objEntr.LOGIN_TIME);
string sErr = "";
try
{
excuteSPNonQuery();
}
catch (Exception ex)
{
sErr = ex.Message;
}
disconnect();
if (sErr != "")
{
ErrorLog.SetLog(sErr);
}
return(sErr);
}
protected override object GetDataFromDataRow(DataTable dt, int i)
{
POSInfo result = new POSInfo();
result.USER_ID = (dt.Rows[i]["USER_ID"] == DBNull.Value ? "" : Convert.ToString(dt.Rows[i]["USER_ID"]));
result.CURRENT_DB = (dt.Rows[i]["CURRENT_DB"] == DBNull.Value ? "" : Convert.ToString(dt.Rows[i]["CURRENT_DB"]));
result.CURRENT_ACTIVITY = (dt.Rows[i]["CURRENT_ACTIVITY"] == DBNull.Value ? "" : Convert.ToString(dt.Rows[i]["CURRENT_ACTIVITY"]));
result.WORK_STATION = (dt.Rows[i]["WORK_STATION"] == DBNull.Value ? "" : Convert.ToString(dt.Rows[i]["WORK_STATION"]));
result.LOGIN_TIME = (dt.Rows[i]["LOGIN_TIME"] == DBNull.Value ? "" : Convert.ToString(dt.Rows[i]["LOGIN_TIME"]));
return(result);
}
private void btnLogin_Click(object sender, EventArgs e)
{
PODInfo inf = new PODInfo();
_user = inf.USER_ID = txtUser.Text;
_pass = inf.PASS = txtPass.Text;
if (_user != "TVC" || _pass != "TVCSYS")
{
inf.LANGUAGE = "44";
BUS.PODControl podCtr = new BUS.PODControl();
if (podCtr.IsExist(inf.USER_ID))
{
string pass = Convert.ToBase64String(new System.Security.Cryptography.SHA1CryptoServiceProvider().ComputeHash(Encoding.ASCII.GetBytes(inf.PASS)));
inf = podCtr.Get(inf.USER_ID, ref _sErr);
inf.LANGUAGE = inf.LANGUAGE == "84" ? "84" : "44";
if (inf.PASS == pass)
{
BUS.POSControl posCtr = new BUS.POSControl();
if (!posCtr.IsExist(inf.USER_ID))
{
DialogResult = DialogResult.OK;
_DB = inf.DB_DEFAULT;
DTO.POSInfo infPOS = new POSInfo(inf.USER_ID, _DB, "Query Designer", "QD", DateTime.Now.ToString("yyyy-MM-dd hh:mm"));
posCtr.InsertUpdate(infPOS);
Close();
}
else
{
lbErr.Text = "Existing users in the system";
}
}
else
{
lbErr.Text = "Password wrong!";
}
}
else
{
lbErr.Text = "User is not exist!";
}
}
else
{
DialogResult = DialogResult.OK;
Close();
}
}
public string InsertUpdate(POSInfo obj)
{
string sErr = "";
if (IsExist(
obj.USER_ID
))
{
sErr = Update(obj);
}
else
{
Add(obj, ref sErr);
}
return(sErr);
}
/// <summary>
/// Return 1: Table is exist Identity Field
/// Return 0: Table is not exist Identity Field
/// Return -1: Erro
/// </summary>
/// <param name="tableName"></param>
public Int32 Add(POSInfo objEntr, ref string sErr)
{
int ret = -1;
connect();
InitSPCommand(_strSPInsertName);
AddParameter("USER_ID", objEntr.USER_ID);
AddParameter("CURRENT_DB", objEntr.CURRENT_DB);
AddParameter("CURRENT_ACTIVITY", objEntr.CURRENT_ACTIVITY);
AddParameter("WORK_STATION", objEntr.WORK_STATION);
AddParameter("LOGIN_TIME", objEntr.LOGIN_TIME);
try
{
//command.ExecuteNonQuery();
object tmp = executeSPScalar();
if (tmp != null && tmp != DBNull.Value)
{
ret = Convert.ToInt32(tmp);
}
else
{
ret = 0;
}
}
catch (Exception ex)
{
sErr = ex.Message;
}
disconnect();
if (sErr != "")
{
ErrorLog.SetLog(sErr);
}
return(ret);
}
/* public string Delete(String arrID)
* {
* string kq = "";
* string[] arrStrID = arrID.Split(',');
* foreach (string strID in arrStrID)
* {
* if (strID != "")
* {
* int ID = Convert.ToInt32(strID);
* kq += _POSDAO.Delete(ID);
* }
* }
* return kq;
* } */
public DataTableCollection Get_Page(POSInfo obj, string orderBy, int pageIndex, int pageSize, ref String sErr)
{
return(_POSDAO.Get_Page(obj, orderBy, pageIndex, pageSize, ref sErr));
}
public string Update(POSInfo obj)
{
return(_POSDAO.Update(obj));
}
public Int32 Add(POSInfo obj, ref string sErr)
{
return(_POSDAO.Add(obj, ref sErr));
}
private string CreateWhereClause(POSInfo obj)
{
String result = "";
return(result);
}