public static List <PointExchange> GetPointExchanges(string MemberNo, bool RealData)
{
string db = GetDB(RealData);
List <PointExchange> result = new List <PointExchange>();
IConnection con = new ConnectionLocator(db).connection;
using (DbConnection dbCon = con.Connect())
{
try
{
dbCon.Open();
using (DbDataAdapter adapter = con.factory.CreateDataAdapter())
{
StringBuilder sql = new StringBuilder();
sql.AppendFormat("EXEC MC_GetPointExchangesByMemberNo @MEMBER_NO='{0}'", MemberNo);
adapter.SelectCommand = new CommandManager().CreateQueryCommand(dbCon, sql.ToString());
DataSet ds = new DataSet();
adapter.Fill(ds, "MC_GetPointExchangesByMemberNo");
if (ds.Tables["MC_GetPointExchangesByMemberNo"].Rows.Count > 0)
{
foreach (DataRow row in ds.Tables["MC_GetPointExchangesByMemberNo"].Rows)
{
PointExchange d = new PointExchange();
d.Id = Convert.ToString(row["ID"]);;
d.RecodeDate = Convert.ToDateTime(row["RECODE_DATE"]);
d.MemberNo = Convert.ToString(row["MEMBER_NO"]);
d.Point = Convert.ToInt32(row["POINT"]);
d.Machine = new Machine();
d.Machine.Id = Convert.ToString(row["MACHINE_ID"]);
d.Machine.Name = Convert.ToString(row["MACHINE_NAME"]);
d.PublishedTime = Convert.ToInt32(row["PUBLISHED_TIME"]);
result.Add(d);
}
}
}
}
catch
{
return(null);
}
}
if (result.Count > 0)
{
return(result);
}
return(null);
}
public static PointExchange GetPointExchange(string id, bool RealData)
{
string db = GetDB(RealData);
PointExchange result = new PointExchange();
IConnection con = new ConnectionLocator(db).connection;
using (DbConnection dbCon = con.Connect())
{
try
{
dbCon.Open();
using (DbDataAdapter adapter = con.factory.CreateDataAdapter())
{
StringBuilder sql = new StringBuilder();
sql.AppendFormat("EXEC MC_GET_DETAIL_POINT_EXCHANGE @ID='{0}'", id);
adapter.SelectCommand = new CommandManager().CreateQueryCommand(dbCon, sql.ToString());
DataSet ds = new DataSet();
adapter.Fill(ds, "TBL_POINT_EXCHANGE");
if (ds.Tables["TBL_POINT_EXCHANGE"].Rows.Count > 0)
{
foreach (DataRow row in ds.Tables["TBL_POINT_EXCHANGE"].Rows)
{
result.Id = id;
result.RecodeDate = Convert.ToDateTime(row["RECODE_DATE"]);
result.PublishedTime = Convert.ToInt32(row["PUBLISHED_TIME"]);
result.MemberNo = Convert.ToString(row["MEMBER_NO"]);
result.Point = Convert.ToInt32(row["POINT"]);
result.Machine = new Machine();
result.Machine.Id = Convert.ToString(row["MACHINE_ID"]);
result.Machine.Name = Convert.ToString(row["MACHINE_NAME"]);
}
}
}
}
catch
{
return(null);
}
}
if ((result.MemberNo != null) && (result.MemberNo != ""))
{
return(result);
}
return(null);
}
public static List <Machine> GetMachines(bool RealData)
{
string db = GetDB(RealData);
List <Machine> MachineList = new List <Machine>();
IConnection con = new ConnectionLocator(db).connection;
using (DbConnection dbCon = con.Connect())
{
try
{
dbCon.Open();
using (DbDataAdapter adapter = con.factory.CreateDataAdapter())
{
StringBuilder sql = new StringBuilder();
sql.AppendFormat("EXEC GET_LIST_MACHINE");
adapter.SelectCommand = new CommandManager().CreateQueryCommand(dbCon, sql.ToString());
DataSet ds = new DataSet();
adapter.Fill(ds, "MS_MACHINE_LIST");
if (ds.Tables["MS_MACHINE_LIST"].Rows.Count > 0)
{
foreach (DataRow row in ds.Tables["MS_MACHINE_LIST"].Rows)
{
if (Convert.ToString(row["FLG0"]) != "0")
{
Machine machine = new Machine();
machine.Id = Convert.ToString(row["MACHINE_ID"]);
machine.Name = Convert.ToString(row["MACHINE_NAME"]);
MachineList.Add(machine);
}
}
}
}
}
catch
{
return(null);
}
}
if (MachineList.Count() > 0)
{
return(MachineList);
}
return(null);
}
public void DelayedInitialize()
{
// require for bundled version of DBus
global::DBus.BusG.Init();
conn_map = new Dictionary <string, Connection> ();
source_map = new Dictionary <string, IDictionary <Contact, ContactSource> > ();
container = new ContactContainerSource(this);
ServiceManager.SourceManager.AddSource(container);
download_manager = new DownloadManagerUi();
upload_manager = new UploadManagerUi();
try {
locator = new ConnectionLocator();
}
catch (DBusProxyObjectNotFound e) {
Log.Error(e.ToString());
return;
}
foreach (Account account in locator.GetConnections())
{
CreateConnection(account);
}
locator.ConnectionStatusChanged += OnConnectionStatusChanged;
try {
proxy_server = new StreamingHTTPProxyServer();
proxy_server.Start();
}
catch (Exception e) {
Log.Error("Failed to start Banshee.Telepathy.StreamingHTTPProxyServer");
Log.Warning(e);
}
try {
streaming_server = new StreamingServer();
streaming_server.Start();
}
catch (Exception e) {
Log.Error("Failed to start Banshee.Telepathy.StreamingHTTPProxyServer");
Log.Warning(e);
}
}
public static Machine GetMachine(string id, bool RealData)
{
string db = GetDB(RealData);
Machine result = new Machine();
IConnection con = new ConnectionLocator(db).connection;
using (DbConnection dbCon = con.Connect())
{
try
{
dbCon.Open();
using (DbDataAdapter adapter = con.factory.CreateDataAdapter())
{
StringBuilder sql = new StringBuilder();
sql.AppendFormat("EXEC GET_DETAIL_MACHINE @MACHINE_ID='{0}'", id);
adapter.SelectCommand = new CommandManager().CreateQueryCommand(dbCon, sql.ToString());
DataSet ds = new DataSet();
adapter.Fill(ds, "MS_MACHINE");
result.Name = "";
if (ds.Tables["MS_MACHINE"].Rows.Count > 0)
{
foreach (DataRow row in ds.Tables["MS_MACHINE"].Rows)
{
result.Id = id;
result.Name = Convert.ToString(row["NAME"]);
}
}
}
}
catch
{
return(null);
}
}
if (result.Name != "")
{
return(result);
}
return(null);
}
public static Member GetMember(string MemberNo, bool RealData)
{
string db = GetDB(RealData);
IConnection con = new ConnectionLocator(db).connection;
using (DbConnection dbCon = con.Connect())
{
try
{
dbCon.Open();
using (DbDataAdapter adapter = con.factory.CreateDataAdapter())
{
StringBuilder sql = new StringBuilder();
sql.AppendFormat("EXEC GET_DETAIL_MEMBER @MEMBER_NO='{0}'", MemberNo);
adapter.SelectCommand = new CommandManager().CreateQueryCommand(dbCon, sql.ToString());
DataSet ds = new DataSet();
adapter.Fill(ds, "GET_DETAIL_MEMBER");
Member result = new Member();
if (ds.Tables["GET_DETAIL_MEMBER"].Rows.Count > 0)
{
foreach (DataRow row in ds.Tables["GET_DETAIL_MEMBER"].Rows)
{
result.MemberNo = Convert.ToString(row["MEMBER_NO"]);;
result.Point = Convert.ToInt32(row["POINT"]);
result.ElsePoint = result.Point - Convert.ToInt32(row["TOTAL_POINT"]);
}
}
return(result);
}
}
catch
{
return(null);
}
}
}
public static int MembersCardChanged(string OldMemberNo, string NewMemberNo, bool RealData)
{
string db = GetDB(RealData);
int result = 0;
using (DbConnection dbCon = new ConnectionLocator(db).connection.Connect())
{
try
{
dbCon.Open();
DbTransaction Trans = dbCon.BeginTransaction();
using (DbCommand cmd = new CommandManager().CreateProcedureCommand(dbCon, "MC_MEMBERS_CARD_CHANGED"))
{
cmd.Transaction = Trans;
DbParameter param;
param = cmd.CreateParameter();
param.ParameterName = "@OLD_MEMBER_NO";
param.DbType = DbType.String;
param.Direction = ParameterDirection.Input;
param.Size = 32;
cmd.Parameters.Add(param);
param = cmd.CreateParameter();
param.ParameterName = "@NEW_MEMBER_NO";
param.DbType = DbType.String;
param.Direction = ParameterDirection.Input;
param.Size = 32;
cmd.Parameters.Add(param);
param = cmd.CreateParameter();
param.ParameterName = "@RESULT";
param.DbType = DbType.Int16;
param.Direction = ParameterDirection.Output;
param.Size = 4;
cmd.Parameters.Add(param);
cmd.Parameters["@OLD_MEMBER_NO"].Value = OldMemberNo;
cmd.Parameters["@NEW_MEMBER_NO"].Value = NewMemberNo;
cmd.ExecuteNonQuery();
result = Convert.ToInt32(cmd.Parameters["@RESULT"].Value);
if (result == 1)
{
Trans.Commit();
return(result);
}
else
{
Trans.Rollback();
return(result);
}
}
}
catch (Exception error)
{
return(result);
}
}
}
public static List <AutoScale> GetAutoScales(string MemberNo, bool RealData)
{
string db = GetDB(RealData);
List <AutoScale> result = new List <AutoScale>();
IConnection con = new ConnectionLocator(db).connection;
using (DbConnection dbCon = con.Connect())
{
try
{
dbCon.Open();
using (DbDataAdapter adapter = con.factory.CreateDataAdapter())
{
StringBuilder sql = new StringBuilder();
sql.AppendFormat("EXEC MC_GetAutoScalesByMemberNo @MEMBER_NO='{0}'", MemberNo);
adapter.SelectCommand = new CommandManager().CreateQueryCommand(dbCon, sql.ToString());
DataSet ds = new DataSet();
adapter.Fill(ds, "MC_GetAutoScalesByMemberNo");
if (ds.Tables["MC_GetAutoScalesByMemberNo"].Rows.Count > 0)
{
foreach (DataRow row in ds.Tables["MC_GetAutoScalesByMemberNo"].Rows)
{
AutoScale d = new AutoScale();
d.Id = Convert.ToString(row["ID"]);;
d.RecodeDate = Convert.ToDateTime(row["RECODE_DATE"]);
d.MemberNo = Convert.ToString(row["MEMBER_NO"]);
d.Scale = Convert.ToDouble(row["SCALE"]);
d.Point = Convert.ToInt32(row["POINT"]);
d.TotalPoint = Convert.ToInt32(row["TOTAL_POINT"]);
d.Unit = Convert.ToString(row["UNIT"]);
d.Machine = new Machine();
d.Machine.Id = Convert.ToString(row["MACHINE_ID"]);
d.Machine.Name = Convert.ToString(row["MACHINE_NAME"]);
d.Item = new Item();
d.Item.Id = Convert.ToString(row["ITEM_CODE"]);
d.Item.Name = Convert.ToString(row["ITEM_NAME"]);
d.WeightCheck = Convert.ToString(row["WEIGHT_CHECK"]);
d.TimeCheck = Convert.ToString(row["TIME_CHECK"]);
result.Add(d);
}
}
}
}
catch
{
return(null);
}
}
if (result.Count > 0)
{
return(result);
}
return(null);
}