public DataSet saveChangePassword(string Usercode, string Oldpassword, string NewPassword)
{
GTKDBConnection dbManager = CommonConnection.GetGTKConnection();
try
{
dbManager.Open();
dbManager.CreateParameters(3);
dbManager.AddParameters(0, "@Usercode", Usercode, ParameterDirection.Input);
dbManager.AddParameters(1, "@Oldpassword", Oldpassword, ParameterDirection.Input);
dbManager.AddParameters(2, "@NewPassword", NewPassword, ParameterDirection.Input);
string spCall = dbManager.GetSPCall("saveChangePassword");
DataSet ds = dbManager.ExecuteDataSet(CommandType.StoredProcedure, "saveChangePassword");
return(ds);
}
catch (Exception)
{
throw;
}
finally
{
dbManager.Dispose();
}
}
static void Main()
{
Application.EnableVisualStyles();
Application.SetCompatibleTextRenderingDefault(false);
CommonConnection connection = ConnectionFactory.createConnection("mysql", "remotemysql.com", "WEJMD9dLmJ", "WEJMD9dLmJ", "CqlKK8zDL3", 3306);
SEPContainer.RegisterConnection(connection);
SEPContainer.RegisterForm <IAddForm, MyAddForm>();
SEPContainer.RegisterForm <IReadForm, MyReadForm>();
SEPContainer.RegisterForm <IUpdateForm, MyUpdateForm>();
Login login = new Login
{
SuccessAction = roles =>
{
Role role = new Role
{
isAllowedAdd = roles.Contains("C"),
isAllowedRead = roles.Contains("R"),
isAllowedUpdate = roles.Contains("U"),
isAllowedDelete = roles.Contains("D")
};
SEPContainer.RegisterRole(role);
new MainForm().Show();
}
};
Application.Run(login);
}
internal void LogError(string errorNameSpace, string eventName, string errorStack, string errorByUser)
{
IDBManager dbManager = CommonConnection.Connectionstring();
try
{
dbManager.Open();
dbManager.CreateParameters(4);
if (ConfigurationSettings.AppSettings["DataB"] == "SQL")
{
dbManager.AddParameters(0, "@ErrorNameSpace", errorNameSpace, ParameterDirection.Input);
dbManager.AddParameters(1, "@ErrorEvent", eventName, ParameterDirection.Input);
dbManager.AddParameters(2, "@ErrorStack", errorStack, ParameterDirection.Input);
dbManager.AddParameters(3, "@ErrorByUser", errorByUser, ParameterDirection.Input);
dbManager.ExecuteNonQuery(CommandType.StoredProcedure, "SAVE_ERROR_LOG");
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
dbManager.Dispose();
}
}
public DataSet getAllUserInfo(Int32 PageNumber, Int32 RowsPerPage, DataTable dtParams)
{
GTKDBConnection dbManager = CommonConnection.GetGTKConnection();
try
{
dbManager.Open();
dbManager.CreateParameters(3);
dbManager.AddParameters(0, "@PageNumber", PageNumber, ParameterDirection.Input);
dbManager.AddParameters(1, "@RowsPerPage", RowsPerPage, ParameterDirection.Input);
dbManager.AddParameters(2, "@filterParams", dtParams, ParameterDirection.Input);
string spCall = dbManager.GetSPCall("getAllUserInfo");
DataSet ds = dbManager.ExecuteDataSet(CommandType.StoredProcedure, "getAllUserInfo");
return(ds);
}
catch (Exception)
{
throw;
}
finally
{
dbManager.Dispose();
}
}
public static DataTable GetCustomTable(DataTable dataTable, string tempTableName, int userId)
{
DataTable rDataTable = new DataTable(tempTableName);
CommonConnection connection = new CommonConnection();
try
{
if (tempTableName.Trim() != string.Empty)
{
//string strDelete = string.Format("Delete {0} Where UserId={1}", tempTableName, userId);
string strDelete = string.Format("Delete {0} ", tempTableName, userId);
connection.ExecuteNonQuery(strDelete);
}
String sql = "Select top (0) * from " + tempTableName;
var tableStructure = connection.GetDataTable(sql);
foreach (DataRow rowWithValue in dataTable.Rows)
{
tableStructure.Rows.Add(CustomDataRow(tableStructure, rowWithValue, userId));
}
rDataTable = tableStructure;
}
catch (Exception)
{
throw;
}
finally
{
connection.Close();
}
return rDataTable;
}
private void PrepareConnection()
{
if (CommonConnection != null)
{
_stockProcessingQueue.Clear();
CommonConnection.StreamingEventReceived -= Broker_StreamingEventReceived;
CommonConnection.Dispose();
}
if (InstrumentInfoConnection != null)
{
InstrumentInfoConnection.StreamingEventReceived -= Broker_StreamingEventReceived;
InstrumentInfoConnection.Dispose();
}
if (CandleConnection != null)
{
CandleConnection.StreamingEventReceived -= Broker_StreamingEventReceived;
CandleConnection.Dispose();
}
CommonConnection = ConnectionFactory.GetConnection(TiApiToken);
CandleConnection = ConnectionFactory.GetConnection(TiApiToken);
if (Settings.SubscribeInstrumentStatus)
{
InstrumentInfoConnection = ConnectionFactory.GetConnection(TiApiToken);
InstrumentInfoConnection.StreamingEventReceived += Broker_StreamingEventReceived;
}
CandleConnection.StreamingEventReceived += Broker_StreamingEventReceived;
CommonConnection.StreamingEventReceived += Broker_StreamingEventReceived;
RunMonthUpdateTaskIfNotRunning();
_lastRestartTime = DateTime.Now;
}
public static DataTable GetBulkDataTable(DataTable dataTable, string tempTableName, string refName, int refValue)
{
DataTable rDataTable = new DataTable(tempTableName);
CommonConnection connection = new CommonConnection();
try
{
String sql = "Select top (0) * from " + tempTableName;
var tableStructure = connection.GetDataTable(sql);
foreach (DataRow rowWithValue in dataTable.Rows)
{
tableStructure.Rows.Add(CustomDataRow(tableStructure, rowWithValue, refName, refValue));
}
rDataTable = tableStructure;
}
catch (Exception)
{
throw;
}
finally
{
connection.Close();
}
return rDataTable;
}
internal int Save_UserPassword(string UserEmail, string userCode, string UsrPwd, string strToken)
{
IDBManager dbManager = CommonConnection.Connectionstring();
int results = 0;
DataSet ds = new DataSet();
try
{
dbManager.Open();
dbManager.CreateParameters(4);
dbManager.AddParameters(0, "UserEmail", UserEmail, ParameterDirection.Input);
dbManager.AddParameters(1, "userCode", userCode, ParameterDirection.Input);
dbManager.AddParameters(2, "UsrPwd", UsrPwd, ParameterDirection.Input);
dbManager.AddParameters(3, "strToken", strToken, ParameterDirection.Input);
string spCall = Helper.Ins.GetSPCall(dbManager.Parameters, "Save_userPassword");
if (ConfigurationSettings.AppSettings["DataB"] == "SQL")
{
ds = dbManager.ExecuteDataSet(CommandType.StoredProcedure, "Save_userPassword");
results = Convert.ToInt16(ds.Tables[0].Rows[0][0]);
}
return(results);
}
catch (Exception ex)
{
throw ex;
}
finally
{
dbManager.Dispose();
}
}
internal DataSet Fetch_UserInfo(string Mode, string usercode)
{
IDBManager dbManager = CommonConnection.Connectionstring();
DataSet ds = new DataSet();
try
{
dbManager.Open();
dbManager.CreateParameters(2);
dbManager.AddParameters(0, "Mode", Mode, ParameterDirection.Input);
dbManager.AddParameters(1, "UserCode", usercode, ParameterDirection.Input);
string spCall = Helper.Ins.GetSPCall(dbManager.Parameters, "Fetch_Users");
if (ConfigurationSettings.AppSettings["DataB"] == "SQL")
{
ds = dbManager.ExecuteDataSet(CommandType.StoredProcedure, "Fetch_Users");
}
return(ds);
}
catch (Exception ex)
{
throw ex;
}
finally
{
dbManager.Dispose();
}
}
internal int SendResetPswdlink(string UserCode, string UserEmail, string EmlTmpl, string token, DateTimeOffset tokenDt)
{
IDBManager dbManager = CommonConnection.Connectionstring();
int MsgId = 0;
DataSet ds = new DataSet();
try
{
const string dtFormat = "yyyy-MM-dd HH:mm:ss.fffffff zzz";
string dtString2 = tokenDt.ToString(dtFormat, CultureInfo.InvariantCulture);
dbManager.Open();
dbManager.CreateParameters(5);
dbManager.AddParameters(0, "UserCode", UserCode, ParameterDirection.Input);
dbManager.AddParameters(1, "UserEmail", UserEmail, ParameterDirection.Input);
dbManager.AddParameters(2, "EmlTmpl", EmlTmpl, ParameterDirection.Input);
dbManager.AddParameters(3, "token", token, ParameterDirection.Input);
dbManager.AddParameters(4, "tokenDt", dtString2, ParameterDirection.Input);
string spCall = Helper.Ins.GetSPCall(dbManager.Parameters, "SendResetPswdlink");
ds = dbManager.ExecuteDataSet(CommandType.StoredProcedure, "SendResetPswdlink");
MsgId = Convert.ToInt16(ds.Tables[0].Rows[0][0]);
return(MsgId);
}
catch (Exception ex)
{
throw ex;
}
finally
{
dbManager.Dispose();
}
}
internal string Validate(string param, string Mode)
{
IDBManager dbManager = CommonConnection.Connectionstring();
string results = "";
DataSet ds = new DataSet();
try
{
dbManager.Open();
dbManager.CreateParameters(2);
dbManager.AddParameters(0, "params", param, ParameterDirection.Input);
dbManager.AddParameters(1, "MODE", Mode, ParameterDirection.Input);
string spCall = Helper.Ins.GetSPCall(dbManager.Parameters, "Validations");
if (ConfigurationSettings.AppSettings["DataB"] == "SQL")
{
ds = dbManager.ExecuteDataSet(CommandType.StoredProcedure, "Validations");
results = Convert.ToString(ds.Tables[0].Rows[0][0]);
}
return(results);
}
catch (Exception ex)
{
throw ex;
}
finally
{
dbManager.Dispose();
}
}
internal int Save_NewApps(int appid, string AppName, string AppURL, string Status, string mode)
{
IDBManager dbManager = CommonConnection.Connectionstring();
int results = 0;
DataSet ds = new DataSet();
try
{
dbManager.Open();
dbManager.CreateParameters(5);
dbManager.AddParameters(0, "AppId", appid, ParameterDirection.Input);
dbManager.AddParameters(1, "AppName", AppName, ParameterDirection.Input);
dbManager.AddParameters(2, "AppURL", AppURL, ParameterDirection.Input);
dbManager.AddParameters(3, "Status", Status, ParameterDirection.Input);
dbManager.AddParameters(4, "mode", mode, ParameterDirection.Input);
string spCall = Helper.Ins.GetSPCall(dbManager.Parameters, "Save_Apps");
if (ConfigurationSettings.AppSettings["DataB"] == "SQL")
{
ds = dbManager.ExecuteDataSet(CommandType.StoredProcedure, "Save_Apps");
results = Convert.ToInt16(ds.Tables[0].Rows[0][0]);
}
return(results);
}
catch (Exception ex)
{
throw ex;
}
finally
{
dbManager.Dispose();
}
}
public IMessageBroker Create(ConnectionConfig config)
{
string databaseType = config.BrokerType.ToString();
var kernel = CommonConnection.Load();
return(kernel.Get <IMessageBroker>(databaseType).Setup(config));
}
internal DataSet Open_LoginInfo(string UserCode, string Password, string param)
{
IDBManager dbManager = CommonConnection.Connectionstring();
DataSet ds = new DataSet();
try
{
dbManager.Open();
dbManager.CreateParameters(3);
dbManager.AddParameters(0, "LoginUserCode", UserCode, ParameterDirection.Input);
dbManager.AddParameters(1, "UserPassword", Password, ParameterDirection.Input);
dbManager.AddParameters(2, "Param", param, ParameterDirection.Input);
string spCall = Helper.Ins.GetSPCall(dbManager.Parameters, "Fetch_LoginInfo");
if (ConfigurationSettings.AppSettings["DataB"] == "SQL")
{
ds = dbManager.ExecuteDataSet(CommandType.StoredProcedure, "Fetch_LoginInfo");
}
return(ds);
}
catch (Exception ex)
{
throw ex;
}
finally
{
dbManager.Dispose();
}
}
internal DataSet Fetch_LoginDtl(string UserCode, string Password, ref string sReturnMsg)
{
IDBManager dbManager = CommonConnection.Connectionstring();
DataSet ds = new DataSet();
try
{
dbManager.Open();
dbManager.CreateParameters(3);
dbManager.AddParameters(0, "LoginUserCode", UserCode, ParameterDirection.Input);
dbManager.AddParameters(1, "UserPassword", Password, ParameterDirection.Input);
dbManager.AddParameters(2, "@RetMsg", string.Empty, ParameterDirection.Output, 100);
string spCall = Helper.Ins.GetSPCall(dbManager.Parameters, "Fetch_LoginDtl");
if (ConfigurationSettings.AppSettings["DataB"] == "SQL")
{
ds = dbManager.ExecuteDataSet(CommandType.StoredProcedure, "Fetch_LoginDtl");
}
if (dbManager.Parameters[2] != null)
{
sReturnMsg = dbManager.Parameters[2].Value.ToString();
}
return(ds);
}
catch (Exception ex)
{
throw ex;
}
finally
{
dbManager.Dispose();
}
}
public static DataTable GetBulkDataTable(DataTable dataTable, string tempTableName, string refName, int refValue)
{
DataTable rDataTable = new DataTable(tempTableName);
CommonConnection connection = new CommonConnection();
try
{
String sql = "Select top (0) * from " + tempTableName;
var tableStructure = connection.GetDataTable(sql);
foreach (DataRow rowWithValue in dataTable.Rows)
{
tableStructure.Rows.Add(CustomDataRow(tableStructure, rowWithValue, refName, refValue));
}
rDataTable = tableStructure;
}
catch (Exception)
{
throw;
}
finally
{
connection.Close();
}
return(rDataTable);
}
public DataSet saveUserAction(DataTable dtParams, string usercode, string AxnCD)
{
GTKDBConnection dbManager = CommonConnection.GetGTKConnection();
try
{
dbManager.Open();
dbManager.CreateParameters(3);
dbManager.AddParameters(0, "@UserAxnParams", dtParams, ParameterDirection.Input);
dbManager.AddParameters(1, "@loginusercode", usercode, ParameterDirection.Input);
dbManager.AddParameters(2, "@AxnCD", AxnCD, ParameterDirection.Input);
string spCall = dbManager.GetSPCall("saveUserAction");
DataSet ds = dbManager.ExecuteDataSet(CommandType.StoredProcedure, "saveUserAction");
return(ds);
}
catch (Exception)
{
throw;
}
finally
{
dbManager.Dispose();
}
}
public DataSet getDashBDtls(string UserCode, string AppType)
{
GTKDBConnection dbManager = CommonConnection.GetGTKConnection();
try
{
dbManager.Open();
dbManager.CreateParameters(2);
dbManager.AddParameters(0, "UserCode", UserCode, ParameterDirection.Input);
if (AppType != null && AppType != "")
{
dbManager.AddParameters(1, "AppType", AppType, ParameterDirection.Input);
}
else
{
dbManager.AddParameters(1, "AppType", DBNull.Value, ParameterDirection.Input);
}
string spCall = dbManager.GetSPCall("dbo.GTKSSODashBDtls");
DataSet ds = dbManager.ExecuteDataSet(CommandType.StoredProcedure, "dbo.GTKSSODashBDtls");
return(ds);
}
catch (Exception ex)
{
throw ex;
}
finally
{
dbManager.Dispose();
}
}
static void Main(string[] args)
{
Console.WriteLine("[{0}] Start Application", DateTime.Now.ToString("hh.mm.ss.ffffff"));
MessageFactory messageFactory = CommonConnection.Load().Get <MessageFactory>();
/** connection example **/
var channel = "secret_channel"; //channel for rabbitmq or topic for kafka
//subscribe message rabbit
ConnectionConfig connection = new ConnectionConfig(MessageBrokerEnum.RabbitMQ, "127.0.0.1", null);
IMessageBroker messageBrokerRabbitMq = messageFactory.Create(connection);
((ICommonConsumer)messageBrokerRabbitMq.GetConsumer()).OnMessageReceivedEventHandler += OnMessageReceivedEventHandler;
//subscribe message redis
ConnectionConfig connectionRedis = new ConnectionConfig(MessageBrokerEnum.Redis, "127.0.0.1", 6379);
IMessageBroker messageBrokerRedis = messageFactory.Create(connectionRedis);
((ICommonConsumer)messageBrokerRedis.GetConsumer()).OnMessageReceivedEventHandler += OnMessageReceivedEventHandler;
//subscribe message kafka
ConnectionConfig connectionKafka = new ConnectionConfig(MessageBrokerEnum.Kafka, "127.0.0.1", 9092);
IMessageBroker messageBrokerKafka = messageFactory.Create(connectionKafka);
((ICommonConsumer)messageBrokerKafka.GetConsumer()).OnMessageReceivedEventHandler += OnMessageReceivedEventHandler;
messageBrokerKafka.Start(channel);
messageBrokerRedis.Start(channel);
messageBrokerRabbitMq.Start(channel);
/** end of connection example **/
//publish Message
RequestMessageData <SomeMessage> objectToSend = new RequestMessageData <SomeMessage>(new SomeMessage(1, "message dikirim", DateTime.Now, new List <string> {
"ratna", "santi"
})); //some class or object
bool isPublish = messageBrokerRedis.PublishRequestMessage(channel, objectToSend);
isPublish &= messageBrokerKafka.PublishRequestMessage <SomeMessage>(channel, objectToSend); //could adding additional key for kafka on third parameter (optional)
isPublish &= messageBrokerRabbitMq.PublishRequestMessage(channel, objectToSend);
// example of publish bulk
//publishBulk(messageBrokerRabbitMq, channel, objectToSend);
//publishBulk(messageBrokerRedis, channel, objectToSend);
//publishBulk(messageBrokerKafka, channel, objectToSend);
Console.WriteLine("after task start");
Thread.Sleep(10000);
Console.WriteLine("cancel start");
messageBrokerRabbitMq.Unsubscribe(channel);
messageBrokerKafka.Unsubscribe(channel);
messageBrokerRedis.Unsubscribe(channel);
Console.WriteLine("cancel finished");
}
public Result SavePesonalDetails(PersonalDetails profileObj)
{
Result result = new Result();
var db = new CommonConnection();
var sql = "";
if (profileObj.PersonalDetailsId == 0)
{
sql = sqlBuilder.GetInsertQuery<PersonalDetails>(profileObj);
db.ExecuteNonQuery(sql);
}
return result;
}
public static DataTable GetCustomTable(DataTable dataTable, string tempTableName, int userId)
{
DataTable rDataTable = new DataTable(tempTableName);
CommonConnection connection = new CommonConnection();
try
{
if (tempTableName.Trim() != string.Empty)
{
string strDelete = "";
if (userId > 0)
{
strDelete = string.Format("Delete {0} Where UserId={1}", tempTableName, userId);
}
else if (userId == 0)
{
strDelete = "";
}
else if (userId == -1)
{
strDelete = string.Format("Delete {0} ", tempTableName);
}
if (strDelete != "")
{
connection.ExecuteNonQuery(strDelete);
}
}
String sql = "Select top (0) * from " + tempTableName;
var tableStructure = connection.GetDataTable(sql);
foreach (DataRow rowWithValue in dataTable.Rows)
{
tableStructure.Rows.Add(CustomDataRow(tableStructure, rowWithValue, userId));
}
rDataTable = tableStructure;
}
catch (Exception)
{
throw;
}
finally
{
connection.Close();
}
return(rDataTable);
}
//This method will return the converted value by comparing the UOMs from DB.
public static double UomCnvVal(string FrUOM, string ToUOM, double FrQty, double ValFct, double WT, string WTUOM)
{
IDBManager dbManager = CommonConnection.Connectionstring();
try
{
double sRetVal = default(double);
dbManager.Open();
dbManager.CreateParameters(7);
DataSet dsVal = new DataSet();
//Asign values to properties
UomConversions cls = new UomConversions(FrUOM, ToUOM, FrQty, ValFct, WT, WTUOM);
if (ConfigurationSettings.AppSettings["DataB"] == "SQL")
{
dbManager.AddParameters(0, "@FrUOM", UomConversions.FrUOM, ParameterDirection.Input);
dbManager.AddParameters(1, "@ToUOM", UomConversions.ToUOM, ParameterDirection.Input);
dbManager.AddParameters(2, "@FrQty", UomConversions.FrQty, ParameterDirection.Input);
dbManager.AddParameters(3, "@ValFct", UomConversions.ValFct, ParameterDirection.Input);
dbManager.AddParameters(4, "@WT", UomConversions.WT, ParameterDirection.Input);
dbManager.AddParameters(5, "@WTUOM", UomConversions.WTUOM, ParameterDirection.Input);
dbManager.AddParameters(6, "@CnvQty", 0, ParameterDirection.Output);
string spCall = Helper.Ins.GetSPCall(dbManager.Parameters, "ObjUom_Convert");
dsVal = dbManager.ExecuteDataSet(CommandType.StoredProcedure, "ObjUom_Convert");
}
if (dbManager.Parameters[6].Value.ToString() != "")
{
sRetVal = double.Parse(dbManager.Parameters[6].Value.ToString());
}
return(sRetVal);
}
catch (Exception ex)
{
throw ex;
}
finally
{
dbManager.Dispose();
}
}
internal int Save_UserInfo(UserList user)
{
IDBManager dbManager = CommonConnection.Connectionstring();
int results = 0;
DataSet ds = new DataSet();
try
{
dbManager.Open();
dbManager.CreateParameters(8);
dbManager.AddParameters(0, "UserFirstName", user.UserFirstName, ParameterDirection.Input);
dbManager.AddParameters(1, "UserMidName", user.UserMidName, ParameterDirection.Input);
dbManager.AddParameters(2, "UserLastName", user.UserLastName, ParameterDirection.Input);
dbManager.AddParameters(3, "Email", user.UserEmail, ParameterDirection.Input);
dbManager.AddParameters(4, "UserApps", user.UserApps, ParameterDirection.Input);
dbManager.AddParameters(5, "Mode", user.Mode, ParameterDirection.Input);
dbManager.AddParameters(6, "userCode", user.userCode, ParameterDirection.Input);
dbManager.AddParameters(7, "eParam", user.EParm, ParameterDirection.Input);
string spCall = Helper.Ins.GetSPCall(dbManager.Parameters, "Save_Users");
if (ConfigurationSettings.AppSettings["DataB"] == "SQL")
{
ds = dbManager.ExecuteDataSet(CommandType.StoredProcedure, "Save_Users");
results = Convert.ToInt16(ds.Tables[0].Rows[0][0]);
}
return(results);
}
catch (Exception ex)
{
throw ex;
}
finally
{
dbManager.Dispose();
}
}
public DataSet getMenuDetails(string UserCode)
{
GTKDBConnection dbManager = CommonConnection.GetGTKConnection();
try
{
dbManager.Open();
dbManager.CreateParameters(1);
dbManager.AddParameters(0, "UserCode", UserCode, ParameterDirection.Input);
string spCall = dbManager.GetSPCall("dbo.GTKSSOMenuDtls");
DataSet ds = dbManager.ExecuteDataSet(CommandType.StoredProcedure, "dbo.GTKSSOMenuDtls");
return(ds);
}
catch (Exception ex)
{
throw ex;
}
finally
{
dbManager.Dispose();
}
}
public DataSet getGTKSSOUserAxn(int Menuid)
{
GTKDBConnection dbManager = CommonConnection.GetGTKConnection();
try
{
dbManager.Open();
dbManager.CreateParameters(1);
dbManager.AddParameters(0, "@Menuid", Menuid, ParameterDirection.Input);
string spCall = dbManager.GetSPCall("getGTKSSOUserAxn");
DataSet ds = dbManager.ExecuteDataSet(CommandType.StoredProcedure, "getGTKSSOUserAxn");
return(ds);
}
catch (Exception)
{
throw;
}
finally
{
dbManager.Dispose();
}
}
public DataSet getLoginInfo(string UserCode, string Password)
{
GTKDBConnection dbManager = CommonConnection.GetGTKConnection();
try
{
dbManager.Open();
dbManager.CreateParameters(2);
dbManager.AddParameters(0, "LoginUserCode", UserCode, ParameterDirection.Input);
dbManager.AddParameters(1, "UserPassword", Password, ParameterDirection.Input);
string spCall = dbManager.GetSPCall("getLoginInfo");
DataSet ds = dbManager.ExecuteDataSet(CommandType.StoredProcedure, "getLoginInfo");
return(ds);
}
catch (Exception)
{
throw;
}
finally
{
dbManager.Dispose();
}
}
public string UpdateMenuSorting(List <Menu> menuList, User user)
{
string res = "";
CommonConnection con = new CommonConnection();
try
{
var quary = "";
foreach (var menu in menuList)
{
quary += string.Format(" Update Menu Set SorOrder = {0} where MenuId = {1};", menu.SortOrder, menu.MenuId);
}
if (quary != "")
{
con.ExecuteNonQuery(quary);
}
res = Operation.Success.ToString();
}
catch (Exception ex)
{
res = Operation.Failed.ToString();
}
return(res);
}
internal int Save_NewAppsx(string xml, string Mode)
{
IDBManager dbManager = CommonConnection.Connectionstring();
int results = 0;
DataSet ds = new DataSet();
try
{
dbManager.Open();
dbManager.CreateParameters(2);
dbManager.AddParameters(0, "xml", xml, ParameterDirection.Input);
dbManager.AddParameters(1, "Mode", Mode, ParameterDirection.Input);
string spCall = Helper.Ins.GetSPCall(dbManager.Parameters, "Save_AppsX");
if (ConfigurationSettings.AppSettings["DataB"] == "SQL")
{
ds = dbManager.ExecuteDataSet(CommandType.StoredProcedure, "Save_AppsX");
results = Convert.ToInt16(ds.Tables[0].Rows[0][0]);
}
}
catch (Exception ex)
{
}
return(results);
}
//public string GenerateEntityId(string prefix, string suffix, bool useSeperator, CommonConnection connection, string enitityName,int transectionResetType)
//{
// //transectionResetType = 1 then Yearly, 2 then Monthly, 3 then Daily
// string idCode = "";
// var idPolicy = GetIdPolicy(connection, enitityName);
// if (prefix == "")
// {
// prefix = idPolicy.Prefix.Trim();
// }
// if (suffix == "")
// {
// suffix =idPolicy.Suffix==null?"": idPolicy.Suffix.Trim();
// }
// if (idPolicy.LastNumber < 0)
// {
// idPolicy.LastNumber = 0;
// }
// if (transectionResetType == 1)
// {
// if (idPolicy.YearName == DateTime.Now.Year)
// {
// //idPolicy.LastNumber = 0;
// }
// else
// {
// idPolicy.LastNumber = 0;
// }
// }
// else if (transectionResetType == 2)
// {
// if (idPolicy.YearName == DateTime.Now.Year && idPolicy.MonthName == DateTime.Now.Month)
// {
// //idPolicy.LastNumber = 0;
// }
// else
// {
// idPolicy.LastNumber = 0;
// }
// }
// else
// {
// if (idPolicy.YearName == DateTime.Now.Year && idPolicy.MonthName == DateTime.Now.Month &&
// idPolicy.DateName == DateTime.Now.Day)
// {
// //idPolicy.LastNumber = 0;
// }
// else
// {
// idPolicy.LastNumber = 0;
// }
// }
// string newNumber = GenerateIDNumber(idPolicy.StartNumber, idPolicy.NumberDigit, idPolicy.LastNumber, enitityName, connection);
// if (useSeperator == false)
// {
// idCode = prefix + newNumber + suffix;
// }
// else
// {
// idCode = prefix + "-" + newNumber + "-" + suffix;
// }
// return idCode.Trim();
//}
//private IDPolicy GetIdPolicy(CommonConnection connection, string enitityName)
//{
// string quary = string.Format("Select * from IDPolicy where EntityName = '{0}'", enitityName);
// return connection.Data<IDPolicy>(quary).FirstOrDefault();
//}
private string GenerateIDNumber(int startNumber, int digit, int lastNumber, string entityName, CommonConnection connection)
{
string num = "";
var length = (lastNumber + 1).ToString().Length;
var diff = digit - length;
if (diff < 0)
{
try
{
num = "000001";
startNumber = startNumber + 1;
lastNumber = 1;
string quary = string.Format(UPDATE_IDPOLICY_WITH_STNUMBER, startNumber, lastNumber, DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.Day, entityName);
connection.ExecuteNonQuery(quary);
}
catch
{
connection.RollBack();
}
}
else
{
for (int i = 0; i < diff; i++)
{
num += "0";
}
num = num + (lastNumber + 1);
try
{
lastNumber = lastNumber + 1;
string quary = string.Format(UPDATE_IDPOLICY, lastNumber, DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.Day, entityName);
connection.ExecuteNonQuery(quary);
}
catch
{
connection.RollBack();
}
}
return num;
}
