/// <summary>
/// @author : TrungMT
/// @CreateDate:05/05/2008
/// @Description: show form and play many clip
/// </summary>
public FrmClipView(DataRowCollection pClipRows, TimeSpan ptServerLocalDelay,QTC.Adv.DataModule.Single.Workstation workstation)
{
InitializeComponent();
this.workstation = workstation;
mClipRows = pClipRows;
Stopped = true;
InitTimmerList();
mTimer.Enabled = true;
mtServerLocalDelay = ptServerLocalDelay;
mFullScreen = new FullScreen(this);
}
internal void UpdateItem(Workstation wupdate)
{
BWorkstation workstation = new BWorkstation();
dgrWorkstation["colCode", currentRow].Value = wupdate.WorkstationCode;
dgrWorkstation["colName", currentRow].Value = wupdate.Name;
dgrWorkstation["colIP", currentRow].Value = wupdate.IPAddress;
dgrWorkstation["colUinitManager", currentRow].Value = wupdate.UnitManager;
dgrWorkstation["colUniManagerTel", currentRow].Value = wupdate.PhoneNumber;
dgrWorkstation["colAddress", currentRow].Value = wupdate.Address;
dgrWorkstation["colAdminManger", currentRow].Value = wupdate.AdminName;
dgrWorkstation["colAdminManagerTel", currentRow].Value = wupdate.AdminPhone;
}
public DataSet Login(Workstation pWorkstation)
{
IDbDataParameter[] parameters =
{
MakeParameter("@CODE", DbType.String, 10),
MakeParameter("@PASSWORD", DbType.String, 400)
};
parameters[0].Value = pWorkstation.WorkstationCode;
parameters[1].Value = pWorkstation.Password;
DataSet ds = RunProcedure("sp_ADV_WORKSTATION_LOGIN", parameters, "ADV_WORKSTATION");
return ds;
}
internal void AddItem(Workstation wupdate)
{
BWorkstation workstation = new BWorkstation();
DataRow newRow = ds.Tables[0].NewRow();
currentRow = dgrWorkstation.Rows.Count + 1;
newRow["STT"] = currentRow;
newRow["WORKSTATION_ID"] = wupdate.WorkstationId;
newRow["CODE"] = wupdate.WorkstationCode;
newRow["NAME"] = wupdate.Name;
newRow["IP"] = wupdate.IPAddress;
newRow["UNIT_MANAGER"] = wupdate.UnitManager;
newRow["TEL"] = wupdate.PhoneNumber;
newRow["ADDRESS"] = wupdate.Address;
newRow["ADMIN_NAME"] = wupdate.AdminName;
newRow["ADMIN_TEL"] = wupdate.AdminPhone;
ds.Tables[0].Rows.Add(newRow);
}
public static Workstation GetWorkstasion(int workstationId)
{
Workstation wkt = new Workstation();
ConnectionFactory Connection = InternalGlobal.MakeConnectionFactory();
PrWorkstation dworkstation = new PrWorkstation(Connection);
Connection.Open();
DataRow dr = dworkstation.Retrieves(workstationId);
Connection.Close();
wkt.WorkstationId = (int)dr["WORKSTATION_ID"];
wkt.WorkstationCode = (string)dr["CODE"];
wkt.Name= (string)dr["NAME"];
wkt.Password = (string)dr["PASSWORD"];
wkt.IPAddress = (string)dr["IP"];
wkt.UnitManager = (string)dr["UNIT_MANAGER"];
wkt.Address = (string)dr["ADDRESS"];
wkt.PhoneNumber = (string)dr["TEL"];
wkt.AdminName = (string)dr["ADMIN_NAME"];
wkt.AdminPhone = (string)dr["ADMIN_TEL"];
wkt.AreaId = (int)dr["AREA_ID"];
return wkt;
}
private void DeleteRowsSelected()
{
int workstationId = (int)dgrWorkstation["colID",currentRow].Value;
BWorkstation bw = new BWorkstation();
Workstation w = new Workstation(workstationId);
try
{
bool ret = bw.Delete(w);
}
catch (Exception exp)
{
MsgBoxVN.ShowError(exp.Message,Dic.STRING_WARNING);
}
}
private void LoadDetail(DataRow dr)
{
workstation = new QTC.Adv.DataModule.Single.Workstation();
workstation.WorkstationId = (int)dr["WORKSTATION_ID"];
workstation.WorkstationCode = (string)dr["CODE"];
workstation.Name = (string)dr["NAME"];
workstation.Password = (string)dr["PASSWORD"];
workstation.IPAddress = (string)dr["IP"];
workstation.UnitManager = (string)dr["UNIT_MANAGER"];
workstation.Address = (string)dr["ADDRESS"];
workstation.PhoneNumber = (string)dr["TEL"];
workstation.AdminName = (string)dr["ADMIN_NAME"];
workstation.AdminPhone = (string)dr["ADMIN_TEL"];
workstation.AreaId = (int)dr["AREA_ID"];
workstation.Status = dr["STATUS"]==DBNull.Value?(byte)0:(bool)dr["STATUS"] ? (byte)1:(byte)0 ;
workstation.LogTime = (DateTime)dr["LOG_TIME"];
}
private void ShowFormUpdate()
{
wupdate = BWorkstation.GetWorkstasion(workstationId);
txtCode.Text = wupdate.WorkstationCode;
txtName.Text = wupdate.Name;
txtPassword.Text = "QTC-ADVERTISE";
txtAddress.Text = wupdate.Address;
txtIP.Text = wupdate.IPAddress.Trim();
txtUnitManager.Text = wupdate.UnitManager;
txtAddress.Text = wupdate.Address;
txtTel.Text = wupdate.PhoneNumber.Trim();
txtAdminManager.Text = wupdate.AdminName;
txtAdminTel.Text = wupdate.AdminPhone.Trim();
DisPlayAreaName(wupdate.AreaId);
}
private void SaveNew()
{
BWorkstation newWT = new BWorkstation();
Workstation data = new Workstation(txtCode.Text, txtName.Text, MD5.EncryptionToString(txtPassword.Text.Trim()), txtIP.Text, txtUnitManager.Text, txtAddress.Text, txtTel.Text, txtAdminManager.Text, txtAdminTel.Text, (int)cboArea.SelectedValue);
try
{
data.WorkstationId = newWT.Add(data);
frmWorkstation.AddItem(data);
ClearFields();
}
catch (SqlException exp)
{
if(exp.Number ==2627)
MsgBoxVN.ShowError("Mã máy trạm đã tồn tại.","Thông báo");
else
MsgBoxVN.ShowError("Có lỗi trong quá trình cập nhật.\n\nLỗi ---> " + exp.Message, "Thông báo");
return;
}
}
/// <summary>
/// @author : khoaht
/// @createDate : 14/7/2009
/// </summary>
/// <param name="code"></param>
private void WriteLoginLog(string code)
{
try
{
BWorkstation bw = new BWorkstation();
DataRow dr = BWorkstation.SearchCode(code).Tables[0].Rows[0];
Workstation mw = new Workstation();
mw.WorkstationId = (int)dr["WORKSTATION_ID"];
mw.WorkstationCode = (string)dr["CODE"];
mw.Name = (string)dr["NAME"];
mw.Password = (string)dr["PASSWORD"];
mw.IPAddress = (string)dr["IP"];
mw.UnitManager = (string)dr["UNIT_MANAGER"];
mw.Address = (string)dr["ADDRESS"];
mw.PhoneNumber = (string)dr["TEL"];
mw.AdminName = (string)dr["ADMIN_NAME"];
mw.AdminPhone = (string)dr["ADMIN_TEL"];
mw.AreaId = (int)dr["AREA_ID"];
mw.Status = (byte)1;
mw.LogTime = DateTime.Now;
bw.UpdateLog(mw);
}
catch
{
}
}
public bool UpdateLog(Workstation workstation)
{
PrWorkstation dworkstation = new PrWorkstation(Connection);
bool update = false;
try
{
Open();
update = dworkstation.UpdateLog(workstation);
Commit();
}
catch (Exception exp)
{
Rollback();
throw exp;
}
finally
{
Close();
}
return update;
}
public bool Delete(Workstation workstation)
{
PrWorkstation dworkstation = new PrWorkstation(Connection);
bool delete = false;
try
{
Open();
delete = dworkstation.Delete(workstation);
Commit();
}
catch (Exception exp)
{
Rollback();
throw exp;
}
finally
{
Close();
}
return delete;
}
public int Add(Workstation workstation)
{
PrWorkstation dworkstation = new PrWorkstation(Connection);
int workstationId = -1;
try
{
Open();
workstationId = dworkstation.Create(workstation);
Commit();
}
catch (Exception exp)
{
Rollback();
throw exp;
}
finally
{
Close();
}
return workstationId;
}
private Global()
{
mWorkstation = new QTC.Adv.DataModule.Single.Workstation();
}
public static void Logout()
{
mWorkstation = null;
}
public static bool Login(string pstrWorkstationCode, string pstrPasswordEngcypt, bool pblnSaveInfo)
{
bool blnLogin=false;
try
{
Logout();
mWorkstation = new QTC.Adv.DataModule.Single.Workstation();
mWorkstation.WorkstationId = -1;
mWorkstation.WorkstationCode = pstrWorkstationCode.Trim();
mWorkstation.Password = Qtc.Libs.Security.MD5.EncryptionToString(pstrPasswordEngcypt);
BWorkstation bWorkstation = new BWorkstation();
blnLogin = bWorkstation.Login(mWorkstation);
// Load FTP info
QTC.Adv.BusinessModule.Global.LoadPropertiesInfo();
if (pblnSaveInfo)
{
Properties.Settings.Default.UserName = pstrWorkstationCode;
Properties.Settings.Default.Password = pstrPasswordEngcypt;
Properties.Settings.Default.SaveInfo = pblnSaveInfo;
Properties.Settings.Default.WorkstationId = mWorkstation.WorkstationId;
Properties.Settings.Default.Save();
}
else
{
Properties.Settings.Default.UserName = "";
Properties.Settings.Default.Password = "";
Properties.Settings.Default.SaveInfo = pblnSaveInfo;
Properties.Settings.Default.Save();
}
}
catch (Exception)
{
return false;
}
return blnLogin;
}
/// <summary>
/// @author : khoaht
/// @createDate : 14/7/2008
/// </summary>
/// <param name="pWorkstation"></param>
/// <returns></returns>
public bool Login(Workstation pWorkstation)
{
try
{
Open();
// Login
PrWorkstation prWorkstation = new PrWorkstation(mcnnFactory);
// Return if cannot login
DataSet ds = prWorkstation.Login(pWorkstation);
if (ds.Tables[0].Rows.Count <= 0)
return false;
// Check match password
if (!Qtc.Libs.Security.MD5.CompareHash(pWorkstation.Password, (string)ds.Tables[0].Rows[0]["PASSWORD"]))
return false;
// Get workstation info
pWorkstation.IPAddress = (string) ds.Tables[0].Rows[0]["IP"];
pWorkstation.WorkstationId = (int) ds.Tables[0].Rows[0]["WORKSTATION_ID"];
pWorkstation.Name = (string) ds.Tables[0].Rows[0]["NAME"];
// WRITE LOGIN LOG
WriteLoginLog(pWorkstation.WorkstationCode);
return true;
}
catch (Exception exp)
{
throw exp;
}
finally
{
Close();
}
//return false;
}
public bool UpdateLog(Workstation workstation)
{
IDbDataParameter[] parameters =
{
MakeParameter("@CODE", DbType.String, 10),
MakeParameter("@NAME", DbType.String, 200),
MakeParameter("@PASSWORD", DbType.String, 400),
MakeParameter("@IP", DbType.String, 30),
MakeParameter("@UNIT_MANAGER", DbType.String, 200),
MakeParameter("@ADDRESS", DbType.String, 400),
MakeParameter("@TEL", DbType.String, 20),
MakeParameter("@ADMIN_NAME", DbType.String, 200),
MakeParameter("@ADMIN_TEL", DbType.String, 20),
MakeParameter("@AREA_ID", DbType.Int32, 4),
MakeParameter("@STATUS", DbType.Byte, 1),
MakeParameter("@LOG_TIME", DbType.DateTime,8),
MakeParameter("@WORKSTATION_ID", DbType.Int32, 4),
};
parameters[0].Value = workstation.WorkstationCode;
parameters[1].Value = workstation.Name;
parameters[2].Value = workstation.Password;
parameters[3].Value = workstation.IPAddress;
parameters[4].Value = workstation.UnitManager;
parameters[5].Value = workstation.Address;
parameters[6].Value = workstation.PhoneNumber;
parameters[7].Value = workstation.AdminName;
parameters[8].Value = workstation.AdminPhone;
parameters[9].Value = workstation.AreaId;
parameters[10].Value = workstation.Status;
parameters[11].Value = workstation.LogTime;
parameters[12].Value = workstation.WorkstationId;
int rowsAffected = 0;
RunProcedure("sp_ADV_WORKSTATION_Update_Log", parameters, out rowsAffected);
return (rowsAffected == 1);
}
