/// <summary>
/// Executes this command against the specified database connection and returns the auto-increment value of the inserted row, or null if it is not an
/// auto-increment table.
/// </summary>
public object Execute( DBConnection cn )
{
var cmd = cn.DatabaseInfo.CreateCommand();
cmd.CommandText = "INSERT INTO " + table;
if( columnModifications.Count == 0 )
cmd.CommandText += " DEFAULT VALUES";
else {
cmd.CommandText += "( ";
foreach( var columnMod in columnModifications )
cmd.CommandText += columnMod.ColumnName + ", ";
cmd.CommandText = cmd.CommandText.Substring( 0, cmd.CommandText.Length - 2 );
cmd.CommandText += " ) VALUES( ";
foreach( var columnMod in columnModifications ) {
var parameter = columnMod.GetParameter();
cmd.CommandText += parameter.GetNameForCommandText( cn.DatabaseInfo ) + ", ";
cmd.Parameters.Add( parameter.GetAdoDotNetParameter( cn.DatabaseInfo ) );
}
cmd.CommandText = cmd.CommandText.Substring( 0, cmd.CommandText.Length - 2 );
cmd.CommandText += " )";
}
cn.ExecuteNonQueryCommand( cmd );
if( !cn.DatabaseInfo.LastAutoIncrementValueExpression.Any() )
return null;
var autoIncrementRetriever = cn.DatabaseInfo.CreateCommand();
autoIncrementRetriever.CommandText = "SELECT {0}".FormatWith( cn.DatabaseInfo.LastAutoIncrementValueExpression );
var autoIncrementValue = cn.ExecuteScalarCommand( autoIncrementRetriever );
return autoIncrementValue != DBNull.Value ? autoIncrementValue : null;
}
public List<String> getListOfForums()
{
DBConnection myConnection = new DBConnection();
myConnection.connect("LILY-PC", "projectdb1", "admin", "123");
String query = "SELECT f_title FROM [projectdb1].[dbo].[Forum]";
return myConnection.getResultsList(query, "f_title");
}
public Company Get(int id, string lang)
{
DBConnection dbConnection = new DBConnection(lang);
company = dbConnection.GetCompanyById(id);
//company.licenceList = new List<Licence>();
//if (company != null && company.company_id > 0)
//{
// var licenceList = dbConnection.GetAllLicenceByCompanyId(company.company_id, "active");
// if (licenceList != null && licenceList.Count > 0)
// {
// company.licenceList = licenceList;
// foreach (var licence in company.licenceList)
// {
// licence.deviceList = new List<Device>();
// //Get Device
// var deviceList = dbConnection.GetAllDevice("", "", licence.original_licence_no);
// if (deviceList != null && deviceList.Count > 0)
// {
// licence.deviceList = deviceList;
// }
// }
// }
//}
return company;
}
public Artist GetArtistById(int? id)
{
using (var db = new DBConnection())
{
return db.Artists.FirstOrDefault(x => x.id == id);
}
}
private bool CheckEEP_ExecutingServiceStateTable(string sProjectID)
{
bool blExistence = false;
DBConnection cDBConnection;
try
{
cDBConnection = new DBConnection();
DataTable dtt = new DataTable();
DataRow[] dtwSelection;
string cmdSQL = "select name from SysObjects order by name";
dtt = cDBConnection.execDataTable(cmdSQL, gsEEPDB);
dtwSelection = dtt.Select("name = 'EEP_ExecutingServiceState'");
switch (dtwSelection.Length)
{
case 1: // have being the table.
blExistence = true;
gLogger.Trace("已經有EEP_ExecutingServiceState的Table");
break;
case 0://Create a new table
cmdSQL = "CREATE TABLE dbo.EEP_ExecutingServiceState (ProjectID NVARCHAR (50) NOT NULL, ServiceName NVARCHAR (50) NOT NULL, RecTime DATETIME NOT NULL, AlarmIntervalMinute INT NOT NULL, CONSTRAINT PK_EEP_ExecutingServiceState PRIMARY KEY (ProjectID, ServiceName));";
//cmdSQL = string.Format("CREATE TABLE [dbo].[RMC_HistoryData_{0}_{1}]([EquipmentID] [nvarchar](50) NULL, [PointID] [nvarchar](50) NULL, [PointValue] [nvarchar](50) NULL, [RecTime] [datetime] NULL) ON [PRIMARY]", sProjectID, DateTime.Now.ToString("yyyyMM"));
cDBConnection.execNonQuery(cmdSQL, gsEEPDB);
blExistence = true;
gLogger.Trace("產生新的EEP_ExecutingServiceState的Table");
break;
}
}
catch (Exception ex)
{
gLogger.ErrorException("UpdateServiceTime.CheckEEP_ExecutingServiceStateTable", ex);
}
return blExistence;
}
protected void Page_Load(object sender, EventArgs e)
{
DBConnection bindComboBox = new DBConnection();
City cities = new City();
DataTable DT = new DataTable();
DT = bindComboBox.BindDropdown(cities.SearchCities(), "City_Name", "City_Number");
CityDDL.DataSource = DT;
CityDDL.DataValueField = "City_Number";
CityDDL.DataTextField = "City_Name";
CityDDL.DataBind();
GenderDDL.Items.Add("Male");
GenderDDL.Items.Add("Female");
//EmployeeType
EmployeeType empType = new EmployeeType();
DT = bindComboBox.BindDropdown(empType.SearchEmployeeTypes(), "Employee_Type_Name", "Employee_Type_Number");
EmployeeTypeDDL.DataSource = DT;
EmployeeTypeDDL.DataValueField = "Employee_Type_Name";
EmployeeTypeDDL.DataTextField = "Employee_Type_Number";
EmployeeTypeDDL.DataBind();
}
public frmEditFunctionSettings(SpecialFunction _function, DBConnection _dbCon, string _tableName)
{
InitializeComponent();
function = _function;
dbCon = _dbCon;
tableName = _tableName;
}
private string gsProjectID = ConfigurationManager.AppSettings.Get("ProjectID"); //從AppConfig讀取「ProjectID」參數
#endregion Fields
#region Methods
/// <summary>
/// 紀錄WindowServic運作時間
/// 用來判斷WindowService是否有正常作動
/// </summary>
public void Update_Time()
{
DBConnection cDBConnection;
bool blFlag;
string cmdSQL = string.Empty;
string sServiceName = gsProjectID + ".ModbusTCP.Adapter(" + gsIP + ":" + gsPort + ")";
try
{
cDBConnection = new DBConnection();
blFlag = false;
blFlag = CheckEEP_ExecutingServiceStateTable(gsProjectID);
if (blFlag == false)
{
gLogger.Error("產生EEP_ExecutingServiceState Table失敗");
}
cmdSQL = string.Format("SELECT * FROM EEP_ExecutingServiceState WHERE ProjectID = '{0}' AND ServiceName = '{1}'", gsProjectID, sServiceName);
DataTable dttExecutingServiceState = cDBConnection.execDataTable(cmdSQL, gsEEPDB);
if (dttExecutingServiceState.Rows.Count > 0)
{
cmdSQL = string.Format("UPDATE EEP_ExecutingServiceState SET RecTime = '{2}', AlarmIntervalSecond = '{3}' WHERE ProjectID = '{0}' AND ServiceName = '{1}'", gsProjectID, sServiceName, DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff"), dttExecutingServiceState.Rows[0]["AlarmIntervalSecond"].ToString());
cDBConnection.execNonQuery(cmdSQL, gsEEPDB);
gLogger.Trace("更新WindowService監控時間成功");
}
else
{
cmdSQL = string.Format("INSERT INTO EEP_ExecutingServiceState (ProjectID, ServiceName, RecTime, AlarmIntervalSecond) VALUES ('{0}', '{1}', '{2}', '{3}')", gsProjectID, sServiceName, DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff"), giSystemRunTimeRecord);
cDBConnection.execNonQuery(cmdSQL, gsEEPDB);
}
}
catch (Exception ex)
{
gLogger.ErrorException("UpdateServiceTime.Update_Time", ex);
}
}
internal static void Generate(
DBConnection cn, TextWriter writer, string baseNamespace, Database database, Configuration.SystemDevelopment.Database configuration)
{
if( configuration.queries == null )
return;
info = cn.DatabaseInfo;
writer.WriteLine( "namespace " + baseNamespace + "." + database.SecondaryDatabaseName + "Retrieval {" );
foreach( var query in configuration.queries ) {
List<Column> columns;
try {
columns = validateQueryAndGetColumns( cn, query );
}
catch( Exception e ) {
throw new UserCorrectableException( "Column retrieval failed for the " + query.name + " query.", e );
}
CodeGenerationStatics.AddSummaryDocComment( writer, "This object holds the values returned from a " + query.name + " query." );
writer.WriteLine( "public static partial class " + query.name + "Retrieval {" );
// Write nested classes.
DataAccessStatics.WriteRowClasses( writer, columns, localWriter => { } );
writeCacheClass( writer, database, query );
writer.WriteLine( "private const string selectFromClause = @\"" + query.selectFromClause + " \";" );
foreach( var postSelectFromClause in query.postSelectFromClauses )
writeQueryMethod( writer, database, query, postSelectFromClause );
writer.WriteLine( "static partial void updateSingleRowCaches( Row row );" );
writer.WriteLine( "}" ); // class
}
writer.WriteLine( "}" ); // namespace
}
public List<Genre> GetAllGenres()
{
using (var db = new DBConnection())
{
return db.Genres.ToList();
}
}
public Genre GetGenreById(int? id)
{
using (var db = new DBConnection())
{
return db.Genres.FirstOrDefault(x => x.id == id);
}
}
public void FillSession(string usuario)
{
DBConnection dbconnectionObj = new DBConnection();
string query = @"select
u.id as usuario_id,
u.usuario as usuario,
p.id as empleado_id,
p.num_placa,
p.nombre as nombre_personal,
p.delegacion_id
from
usuarios as u inner join personal as p on u.empleado_id = p.id
where u.usuario = @usuario";
DataTable dt = dbconnectionObj.Select(query,
new SqlParameter("@usuario", usuario)
);
if (dt.Rows.Count > 0)
{
foreach (DataRow row in dt.Rows)
{
Sesion.usuario_id = int.Parse(row["usuario_id"].ToString());
Sesion.empleado_id = int.Parse(row["empleado_id"].ToString());
Sesion.nombre_personal = row["nombre_personal"].ToString();
Sesion.num_placa = row["num_placa"].ToString();
Sesion.delegacion_id = int.Parse(row["delegacion_id"].ToString());
}
}
}
private void button1_Click(object sender, EventArgs e)
{
//Get database connection information from DBConnection.cs
DBConnection conString = new DBConnection();
string dbConnString;
conString.MyProperty = "";
dbConnString = conString.MyProperty;
//Check all fields from SafeInsert.cs
SafeInsert safeInsert = new SafeInsert();
string phoneIn = safeInsert.cityFix(phoneNumberIn.Text);
try
{
MySqlConnection connection = new MySqlConnection(dbConnString);
connection.Open(); //open connection
MySqlDataAdapter MyDa = new MySqlDataAdapter();
string SqlSelectAll = "Select * from customerdetails;";
MyDa.SelectCommand = new MySqlCommand(SqlSelectAll, connection);
DataTable table = new DataTable(); //Setup Bindings to attach to DataGrid
MyDa.Fill(table);
BindingSource bSource = new BindingSource();
bSource.DataSource = table;
//Fill grid
dgView.DataSource = bSource;
}
catch (Exception)
{
MessageBox.Show("Error Connecting");
}
}
internal static string GetClassName( DBConnection cn, string table, bool isRevisionHistoryTable, bool isRevisionHistoryClass )
{
return
EwlStatics.GetCSharpSafeClassName(
isRevisionHistoryTable && !isRevisionHistoryClass
? "Direct" + table.TableNameToPascal( cn ) + "ModificationWithRevisionBypass"
: table.TableNameToPascal( cn ) + "Modification" );
}
public void UpdateArtist(Artist artist)
{
using (var db = new DBConnection())
{
db.Entry(artist).State = EntityState.Modified;
db.SaveChanges();
}
}
public void DeleteGenre(int id)
{
using (var db = new DBConnection())
{
db.Genres.Remove(db.Genres.FirstOrDefault(x=>x.id == id));
db.SaveChanges();
}
}
public void Update(Album album)
{
using (var db = new DBConnection())
{
db.Entry(album).State = EntityState.Modified;
db.SaveChanges();
}
}
public void UpdateGenre(Genre genre)
{
using (var db = new DBConnection())
{
db.Entry(genre).State = EntityState.Modified;
db.SaveChanges();
}
}
public void CreateGenre(Genre genre)
{
using (var db = new DBConnection())
{
db.Genres.Add(genre);
db.SaveChanges();
}
}
public void CreateAlbum(Album album)
{
using (var db = new DBConnection())
{
db.Albums.Add(album);
db.SaveChanges();
}
}
public void FirstConnectToDBTest()
{
DBConnection dbConnection = new DBConnection();
var connectionSuccessFlag = dbConnection.ConnectToDB();
Assert.AreEqual(true, connectionSuccessFlag);
Assert.AreEqual(true, dbConnection.IsConnectedToDB);
}
private void btnCreateConnection_Click(object sender, EventArgs e)
{
DBConnection con = new DBConnection((string)cboxServ.SelectedItem, (string)cboxDatabase.SelectedItem, txtUser.Text, txtPass.Text);
frmManagerMain main = new frmManagerMain(con);
this.Hide();
main.ShowDialog();
this.Show();
}
public String getForumID(String forumName)
{
List<String> myList = new List<string>();
DBConnection myConnection = new DBConnection();
myConnection.connect("LILY-PC", "projectdb1", "admin", "123");
String query = String.Format("SELECT f_id FROM [projectdb1].[dbo].[Forum] WHERE f_title = '{0}'", forumName);
myList = myConnection.getResultsList(query, "f_id");
return myList.First();
}
public DataTable getInfo(String id)
{
DataTable myTable = new DataTable();
DBConnection myConnection = new DBConnection();
myConnection.connect("LILY-PC", "projectdb1", "admin", "123");
String query = String.Format("SELECT c.f_name AS 'First Name' ,c.m_name AS 'Middle Name', c.l_name AS 'Last Name', c.prs_email AS 'Personal Email', c.company AS 'Company',c.cmp_add_no AS 'C.A.No',c.cmp_add_street AS 'C.A.St',c.cmp_add_town AS 'C.A.tw',c.cmp_email AS 'Cm.Email',p.phone AS 'Pers Phone',b.phone AS 'Bus Phone' FROM Manager AS c, PrsPhone AS p, BusPhone AS b WHERE c.u_id=p.u_id AND c.u_id=b.u_id AND c.u_id={0}", id);
myTable = myConnection.executeReturningQuery(query);
return myTable;
}
public DataTable getCV(String id)
{
DataTable myTable = new DataTable();
DBConnection myConnection = new DBConnection();
myConnection.connect("LILY-PC", "projectdb1", "admin", "123");
String query = String.Format("SELECT c.f_name AS 'First Name' ,c.m_name AS 'Middle Name', c.l_name AS 'Last Name', c.dob AS 'Date of Birth', c.age AS 'Age', c.gender AS 'Gender', c.maritual_status AS 'Marital Status', c.add_no AS 'Number',c.add_street AS 'Street', c.add_town AS 'Town',c.email AS 'Email', p.phone AS 'Phone', s.school AS 'School' FROM [Candidate] AS c, PrsPhone AS p, CanSchool AS s WHERE c.u_id=p.u_id AND c.u_id=s.u_id AND c.u_id={0}", id);
myTable = myConnection.executeReturningQuery(query);
return myTable;
}
internal TableColumns( DBConnection cn, string table, bool forRevisionHistoryLogic )
{
try {
// NOTE: Cache this result.
AllColumns = Column.GetColumnsInQueryResults( cn, "SELECT * FROM " + table, true );
foreach( var col in AllColumns ) {
// This hack allows code to be generated against a database that is configured for ASP.NET Application Services.
var isAspNetApplicationServicesTable = table.StartsWith( "aspnet_" );
if( !( cn.DatabaseInfo is OracleInfo ) && col.DataTypeName == typeof( string ).ToString() && col.AllowsNull && !isAspNetApplicationServicesTable )
throw new UserCorrectableException( "String column " + col.Name + " allows null, which is not allowed." );
}
// Identify key, identity, and non identity columns.
var nonIdentityColumns = new List<Column>();
foreach( var col in AllColumns ) {
if( col.IsKey )
keyColumns.Add( col );
if( col.IsIdentity ) {
if( identityColumn != null )
throw new UserCorrectableException( "Only one identity column per table is supported." );
identityColumn = col;
}
else
nonIdentityColumns.Add( col );
}
if( !keyColumns.Any() )
throw new UserCorrectableException( "The table must contain a primary key or other means of uniquely identifying a row." );
// If the table has a composite key, try to use the identity as the key instead since this will enable InsertRow to return a value.
if( identityColumn != null && keyColumns.Count > 1 ) {
keyColumns.Clear();
keyColumns.Add( identityColumn );
}
RowVersionColumn = AllColumns.SingleOrDefault( i => i.IsRowVersion );
AllColumnsExceptRowVersion = AllColumns.Where( i => !i.IsRowVersion ).ToArray();
AllNonIdentityColumnsExceptRowVersion = nonIdentityColumns.Where( i => !i.IsRowVersion ).ToArray();
if( forRevisionHistoryLogic ) {
if( keyColumns.Count != 1 ) {
throw new UserCorrectableException(
"A revision history modification class can only be created for tables with exactly one primary key column, which is assumed to also be a foreign key to the revisions table." );
}
primaryKeyAndRevisionIdColumn = keyColumns.Single();
if( primaryKeyAndRevisionIdColumn.IsIdentity )
throw new UserCorrectableException( "The revision ID column of a revision history table must not be an identity." );
}
dataColumns = AllColumns.Where( col => !col.IsIdentity && !col.IsRowVersion && col != primaryKeyAndRevisionIdColumn ).ToArray();
}
catch( Exception e ) {
throw UserCorrectableException.CreateSecondaryException( "An exception occurred while getting columns for table " + table + ".", e );
}
}
public DataTable Get()
{
DataTable dt = new DataTable();
DBConnection dbconnectionObj = new DBConnection();
string query = @"
select id, nombre from roles
";
dt = dbconnectionObj.Select(query, null);
return dt;
}
public bool Exists(string usuario)
{
DataTable dt = new DataTable();
DBConnection dbconnectionObj = new DBConnection();
string query = @"select id from usuarios where usuario = @usuario";
dt = dbconnectionObj.Select(query,
new SqlParameter("@usuario", usuario)
);
return dt.Rows.Count > 0 ? true : false;
}
protected void VehicleDDL_SelectedIndexChanged(object sender, EventArgs e)
{
DBConnection db = new DBConnection();
ClientVehicle ClientV = new ClientVehicle();
DateDDL.DataTextField = "Project_StartDateTime";
DateDDL.DataValueField = "Project_Number";
DateDDL.DataSource = db.BindDropdown("SELECT Project.Project_Number, Project.Project_StartDateTime, Project.Project_TotalCost FROM Project WHERE Client_Vehicle_Number = " + VehicleDDL.SelectedItem.Value, "Project_StartDateTime", "Project_Number");
DateDDL.DataBind();
DateDDL.Items.Insert(0, "");
}
internal static void Generate( DBConnection cn, TextWriter writer, string baseNamespace, Database database )
{
writer.WriteLine( "namespace " + baseNamespace + " {" );
writer.WriteLine( "public static class " + database.SecondaryDatabaseName + "Procedures {" );
foreach( var procedure in database.GetProcedures() ) {
var parameters = database.GetProcedureParameters( procedure );
// header
CodeGenerationStatics.AddSummaryDocComment( writer, "Executes the " + procedure + " procedure." );
var parameterDeclarations =
parameters.Select(
i => ( i.Direction == ParameterDirection.Output ? "out " : i.Direction == ParameterDirection.InputOutput ? "ref " : "" ) + i.DataTypeName + " " + i.Name );
writer.WriteLine( "public static void " + procedure + "( " + StringTools.ConcatenateWithDelimiter( ", ", parameterDeclarations.ToArray() ) + " ) {" );
// body
writer.WriteLine( "var cmd = new SprocExecution( \"" + procedure + "\" );" );
foreach( var parameter in parameters ) {
if( parameter.Direction == ParameterDirection.Input )
writer.WriteLine( "cmd.AddParameter( " + getDbCommandParameterCreationExpression( parameter ) + " );" );
else {
writer.WriteLine( "var " + parameter.Name + "Parameter = " + getDbCommandParameterCreationExpression( parameter ) + ";" );
writer.WriteLine(
parameter.Name + "Parameter.GetAdoDotNetParameter( " + DataAccessStatics.GetConnectionExpression( database ) +
".DatabaseInfo ).Direction = ParameterDirection." + parameter.Direction + ";" );
writer.WriteLine( "cmd.AddParameter( " + parameter.Name + "Parameter );" );
}
}
foreach( var parameter in parameters.Where( parameter => parameter.Direction != ParameterDirection.Input ) )
writer.WriteLine( parameter.DataTypeName + " " + parameter.Name + "Local = default( " + parameter.DataTypeName + " );" );
writer.WriteLine( "cmd.ExecuteReader( " + DataAccessStatics.GetConnectionExpression( database ) + ", r => {" );
foreach( var parameter in parameters.Where( parameter => parameter.Direction != ParameterDirection.Input ) ) {
var adoDotNetParameterValueExpression = "{0}Parameter.GetAdoDotNetParameter( {1}.DatabaseInfo ).Value".FormatWith(
parameter.Name,
DataAccessStatics.GetConnectionExpression( database ) );
// We are not sure if this is handling null correctly. When a null comes back via an "out" parameter, we're not sure whether it is represented with
// DBNull.Value or in another way. This issue can be resolved as soon as we have a system with stored procedures that we can use for testing.
// NOTE: This is a hack. We would like to use a simple cast to convert the value of the database parameter to the method parameter's type, but we
// can't because the types in Oracle.DataAccess.Types, like OracleDecimal, do not support any kind of conversion to .NET types when they are boxed.
writer.WriteLine(
"{0}Local = {1};".FormatWith(
parameter.Name,
parameter.GetIncomingValueConversionExpression(
"EwlStatics.ChangeType( {0}.ToString(), typeof( {1} ) )".FormatWith( adoDotNetParameterValueExpression, parameter.UnconvertedDataTypeName ) ) ) );
//writer.WriteLine( "{0}Local = {1};".FormatWith( parameter.Name, parameter.GetIncomingValueConversionExpression( adoDotNetParameterValueExpression ) ) );
}
writer.WriteLine( "} );" );
foreach( var parameter in parameters.Where( parameter => parameter.Direction != ParameterDirection.Input ) )
writer.WriteLine( parameter.Name + " = " + parameter.Name + "Local;" );
writer.WriteLine( "}" );
}
writer.WriteLine( "}" );
writer.WriteLine( "}" );
}
public static void delObject(
string sessionGuid_in,
string ip_forLogPurposes_in,
long idAuthor_in,
out int[] errors_out
)
{
List <int> _errorlist;
Guid _sessionguid;
Sessionuser _sessionuser;
#region check...
if (!SBO_CRD_Authentication.isSessionGuid_valid(
sessionGuid_in,
ip_forLogPurposes_in,
out _sessionguid,
out _sessionuser,
out _errorlist,
out errors_out
))
{
//// no need!
//errors_out = _errors.ToArray();
return;
}
#endregion
#region check Permissions...
if (
!_sessionuser.hasPermission(
PermissionType.Author__delete
)
)
{
_errorlist.Add(ErrorType.author__lack_of_permissions_to_delete);
errors_out = _errorlist.ToArray();
return;
}
#endregion
#region check existence...
SO_NWS_Author _author;
if (
idAuthor_in <= 0
||
(
(_author = DO_NWS_Author.getObject(
idAuthor_in
)) == null
)
)
{
_errorlist.Add(ErrorType.data__not_found);
errors_out = _errorlist.ToArray();
return;
}
#endregion
#region check Permissions... (more)
if (
// is approved
(
!_author.IFUser__Approved_isNull
||
!_author.Approved_date_isNull
)
&&
// and no permission to approve
!_sessionuser.hasPermission(
PermissionType.Author__approve
)
)
{
_errorlist.Add(ErrorType.author__lack_of_permissions_to_delete_approved);
errors_out = _errorlist.ToArray();
return;
}
#endregion
#region check References...
if (
(DO_NWS_ContentAuthor.getCount_inRecord_byAuthor(
idAuthor_in
) > 0)
)
{
_errorlist.Add(ErrorType.data__constraint_violation);
errors_out = _errorlist.ToArray();
return;
}
#endregion
Exception _exception = null;
#region DBConnection _con = DO__Utilities.DBConnection_createInstance(...);
DBConnection _con = DO__Utilities.DBConnection_createInstance(
DO__Utilities.DBServerType,
DO__Utilities.DBConnectionstring,
DO__Utilities.DBLogfile
);
#endregion
try {
//_con.Open();
//_con.Transaction.Begin();
DO_NWS_Author.delObject(
idAuthor_in,
_con
);
_errorlist.Add(ErrorType.author__successfully_deleted__WARNING);
#region _con.Transaction.Commit();
if (
_con.IsOpen
&&
_con.Transaction.InTransaction
)
{
_con.Transaction.Commit();
}
#endregion
} catch (Exception _ex) {
#region _con.Transaction.Rollback();
if (
_con.IsOpen
&&
_con.Transaction.InTransaction
)
{
_con.Transaction.Rollback();
}
#endregion
_exception = _ex;
} finally {
#region _con.Transaction.Terminate(); _con.Close(); _con.Dispose();
if (_con.IsOpen)
{
if (_con.Transaction.InTransaction)
{
_con.Transaction.Terminate();
}
_con.Close();
}
_con.Dispose();
#endregion
}
if (_exception != null)
{
#region SBO_LOG_Log.Log(ErrorType.data);
OGen.NTier.Kick.Libraries.BusinessLayer.SBO_LOG_Log.log(
_sessionuser,
LogType.error,
ErrorType.data,
-1L,
_sessionuser.IDApplication,
"{0}",
new string[] {
_exception.Message
}
);
#endregion
_errorlist.Add(ErrorType.data);
}
errors_out = _errorlist.ToArray();
}
protected void SubmitButton_Click(object sender, System.EventArgs e)
{
if (!IsValid)
{
return;
}
MainDataSet.Tables["Users"].Rows[0]["Email"] = EmailAddress.Text;
MainDataSet.Tables["Users"].Rows[0]["FirstName"] = FirstName.Text;
MainDataSet.Tables["Users"].Rows[0]["LastName"] = LastName.Text;
MainDataSet.Tables["Users"].Rows[0]["CompanyName"] = CompanyName.Text;
MainDataSet.Tables["Users"].Rows[0]["Address"] = Address.Text;
MainDataSet.Tables["Users"].Rows[0]["City"] = City.Text;
MainDataSet.Tables["Users"].Rows[0]["State"] = State.Text;
MainDataSet.Tables["Users"].Rows[0]["Zip"] = Zip.Text;
MainDataSet.Tables["Users"].Rows[0]["Country"] = ddlCountries.SelectedItem.Text;
MainDataSet.Tables["Users"].Rows[0]["PrimaryTelephone"] = PrimaryTelephone.Text;
MainDataSet.Tables["Users"].Rows[0]["EveningTelephone"] = EveningTelephone.Text;
MainDataSet.Tables["Users"].Rows[0]["DaytimeTelephone"] = DaytimeTelephone.Text;
MainDataSet.Tables["Users"].Rows[0]["MobileTelephone"] = MobileTelephone.Text;
MainDataSet.Tables["Users"].Rows[0]["dateModified"] = DateTime.Today.ToString();
if (Website.Text.Length > 0)
{
if (!Website.Text.StartsWith("http://"))
{
Website.Text = "http://" + Website.Text;
}
MainDataSet.Tables["Users"].Rows[0]["Website"] = Website.Text;
}
else
{
MainDataSet.Tables["Users"].Rows[0]["Website"] = "";
}
MainDataSet.Tables["Users"].Rows[0]["Registered"] = Registered.Text;
MainDataSet.Tables["Users"].Rows[0]["IfPayTravelAgents"] = PayTravelAgents.Checked;
int referredby = -1;
try
{
referredby = Convert.ToInt32(Agents.SelectedValue);
}
catch (Exception)
{
}
if (referredby != -1)
{
MainDataSet.Tables["Users"].Rows[0]["ReferredByID"] = referredby;
}
else
{
MainDataSet.Tables["Users"].Rows[0]["ReferredByID"] = DBNull.Value;
}
if (ReservationSame.Checked)
{
MainDataSet.Tables["Users"].Rows[0]["IfReservationSame"] = true;
MainDataSet.Tables["Users"].Rows[0]["ReservationEmail"] = MainDataSet.Tables["Users"].Rows[0]["Email"];
MainDataSet.Tables["Users"].Rows[0]["ReservationFirstName"] = MainDataSet.Tables["Users"].Rows[0]["FirstName"];
MainDataSet.Tables["Users"].Rows[0]["ReservationLastName"] = MainDataSet.Tables["Users"].Rows[0]["LastName"];
}
else
{
MainDataSet.Tables["Users"].Rows[0]["IfReservationSame"] = false;
MainDataSet.Tables["Users"].Rows[0]["ReservationEmail"] = ReservationEmail.Text;
MainDataSet.Tables["Users"].Rows[0]["ReservationFirstName"] = ReservationFirstName.Text;
MainDataSet.Tables["Users"].Rows[0]["ReservationLastName"] = ReservationLastName.Text;
}
if (AuthenticationManager.IfAdmin && IfAdmin.Visible)
{
MainDataSet.Tables["Users"].Rows[0]["IfAdmin"] = IfAdmin.Items[IfAdmin.SelectedIndex].Text == "Yes";
}
DBConnection obj = new DBConnection();
DataTable dt = new DataTable();
try
{
//lock (CommonFunctions.Connection)
MainAdapter.Update(MainDataSet, "Users");
dt = VADBCommander.NewsletterListByEmail(EmailAddress.Text);
if (dt.Rows.Count == 0)
{
string strFullName = FirstName.Text + " " + LastName.Text;
VADBCommander.NewsLetterEmailShortAdd(EmailAddress.Text, strFullName);
}
}
catch (Exception ex) { lblInfo.Text = ex.Message; }
finally { obj.CloseConnection(); }
Response.Redirect(CommonFunctions.PrepareURL("listings.aspx"));
}
private void mostrarInventarioToolStripMenuItem_Click(object sender, EventArgs e)
{
dgvResultados.DataSource = DBConnection.GetItemStock();
}
public static void update(Guid id, Guid gradeID, Guid productID, Guid productWidthID, Guid lengthUnitID, Guid colorID, int qty, int orderLotQty, string poNotes, string notes)
{
InventoryStockLevel objOld = new InventoryStockLevel(id);
//generate log description
string logDescription = "";
Product product = new Product(productID);
if (objOld.ProductStoreNameID != product.StoreNameID)
{
logDescription = Tools.append(logDescription, String.Format("Product Store Name: '{0}' to '{1}'", objOld.ProductStoreName, product.StoreName), ",");
}
if (objOld.GradeID != gradeID)
{
logDescription = Tools.append(logDescription, String.Format("Grade: '{0}' to '{1}'", objOld.GradeID, new Grade(gradeID).Name), ",");
}
if (objOld.ProductWidthID != productWidthID)
{
logDescription = Tools.append(logDescription, String.Format("Product Width: '{0}' to '{1}'", objOld.ProductWidthName, new ProductWidth(productWidthID).Name), ",");
}
if (objOld.LengthUnitID != lengthUnitID)
{
logDescription = Tools.append(logDescription, String.Format("Length Unit: '{0}' to '{1}'", objOld.LengthUnitID, new LengthUnit(lengthUnitID).Name), ",");
}
if (objOld.VendorName != product.VendorName)
{
logDescription = Tools.append(logDescription, String.Format("Vendor: '{0}' to '{1}'", objOld.VendorName, product.VendorName), ",");
}
if (objOld.OrderLotQty != orderLotQty)
{
logDescription = Tools.append(logDescription, String.Format("Lot qty: '{0}' to '{1}'", objOld.OrderLotQty, orderLotQty), ",");
}
if (objOld.Qty != qty)
{
logDescription = Tools.append(logDescription, String.Format("Qty: '{0}' to '{1}'", objOld.Qty, qty), ",");
}
if (objOld.PONotes != poNotes)
{
logDescription = Tools.append(logDescription, String.Format("PO Notes: '{0}' to '{1}'", objOld.PONotes, poNotes), ",");
}
if (objOld.Notes != notes)
{
logDescription = Tools.append(logDescription, String.Format("Notes: '{0}' to '{1}'", objOld.Notes, notes), ",");
}
if (!string.IsNullOrEmpty(logDescription))
{
SqlQueryResult result = DBConnection.query(
false,
DBConnection.ActiveSqlConnection,
QueryTypes.ExecuteNonQuery,
"inventorystocklevel_update",
new SqlQueryParameter(COL_DB_ID, SqlDbType.UniqueIdentifier, id),
new SqlQueryParameter(COL_DB_GRADEID, SqlDbType.UniqueIdentifier, gradeID),
new SqlQueryParameter(COL_DB_PRODUCTID, SqlDbType.UniqueIdentifier, productID),
new SqlQueryParameter(COL_DB_PRODUCTWIDTHID, SqlDbType.UniqueIdentifier, productWidthID),
new SqlQueryParameter(COL_DB_LENGTHUNITID, SqlDbType.UniqueIdentifier, lengthUnitID),
new SqlQueryParameter(COL_DB_COLORID, SqlDbType.UniqueIdentifier, colorID),
new SqlQueryParameter(COL_DB_ORDERLOTQTY, SqlDbType.Int, orderLotQty),
new SqlQueryParameter(COL_DB_QTY, SqlDbType.Int, qty),
new SqlQueryParameter(COL_DB_PONOTES, SqlDbType.VarChar, Util.wrapNullable(poNotes)),
new SqlQueryParameter(COL_DB_NOTES, SqlDbType.VarChar, Util.wrapNullable(notes))
);
if (result.IsSuccessful)
{
ActivityLog.submitUpdate(id, logDescription);
}
}
}
public static ReturnObject AddShift(string current)
{
masters_manage_shift page_object = new masters_manage_shift();
DBConnection db_connection = new DBConnection();
ReturnObject return_object = new ReturnObject();
string shift_code = string.Empty;
string shift_name = string.Empty;
int count = 0;
if (HttpContext.Current.Session["username"] == null) // checking session expired or not
{
return_object = page_object.DoLogout();
}
else
{
try
{
JObject current_data = JObject.Parse(current);
shift_code = current_data["shift_code"].ToString();
shift_name = current_data["shift_desc"].ToString();
count = page_object.CheckShiftCode(shift_code);
if (count > 0)
{
return_object.status = "error";
return_object.return_data = "Shift Code has been taken. Please try again with a different Code.";
return(return_object);
}
count = page_object.CheckShiftName(shift_name);
if (count > 0)
{
return_object.status = "error";
return_object.return_data = "Shift Name has been taken. Please try again with a different Name.";
return(return_object);
}
page_object.UpdateDatabase(current_data, "I");
return_object.status = "success";
return_object.return_data = "Shift added successfully!";
}
catch (Exception ex)
{
Logger.LogException(ex, page, "ADD_SHIFT");
return_object.status = "error";
return_object.return_data = "An error occurred while saving Shift details. Please try again. If the error persists, please contact Support.";
throw;
}
finally
{
page_object.Dispose();
}
}
return(return_object);
}
private void PrepareDataForExport(string filters, string branches)
{
DBConnection db_connection = new DBConnection();
Hashtable filter_conditions = new Hashtable();
JObject filters_data = new JObject();
JArray branch_data = new JArray();
string
from_date, to_date, user_name,
employee_name, employee_id, current_user_id,
where_clause = string.Empty, company_name, category_name, employee_status,
department_name, shift_name, branch_list = string.Empty;
int
user_access_level, i = 0;
filters_data = JObject.Parse(filters);
company_name = filters_data["company_name"].ToString();
department_name = filters_data["department"].ToString();
shift_name = filters_data["shift"].ToString();
category_name = filters_data["category"].ToString();
employee_status = filters_data["status"].ToString();
employee_id = filters_data["employee_id"].ToString();
employee_name = filters_data["employee_name"].ToString();
from_date = DateTime.ParseExact(filters_data["from_date"].ToString(), "dd-MMM-yyyy", CultureInfo.InvariantCulture).ToString("yyyy-MM-dd");
to_date = DateTime.ParseExact(filters_data["to_date"].ToString(), "dd-MMM-yyyy", CultureInfo.InvariantCulture).ToString("yyyy-MM-dd");
// Get current logged in user data from the Session variable
user_name = HttpContext.Current.Session["username"].ToString();
user_access_level = Convert.ToInt32(HttpContext.Current.Session["access_level"]);
current_user_id = HttpContext.Current.Session["employee_id"].ToString();
// process branch IDs
branch_data = JArray.Parse(branches);
for (i = 0; i < branch_data.Count; i++)
{
branch_list += "'" + branch_data[i].ToString() + "',";
}
where_clause += " where m.punchdate between '" + from_date + "' and '" + to_date + "' ";
if (company_name != "select")
{
// where_clause = where_clause + " and c.Companyname = '" + company_name + "'";
if (!string.IsNullOrEmpty(branch_list))
{
branch_list = branch_list.Remove(branch_list.Length - 1, 1);
where_clause = where_clause + " and b.branchname in (" + branch_list + ")";
}
if (department_name != "select")
{
where_clause = where_clause + " and d.DeptName = '" + department_name + "'";
}
if (shift_name != "select")
{
where_clause = where_clause + " and s.Shift_Desc = '" + shift_name + "'";
}
if (category_name != "select")
{
where_clause = where_clause + " and ecm.EmpCategoryName='" + category_name + "'";
}
// Checking to see if an employee ID has been selected in the filters.
if (employee_id != "") // If YES then we pull results only for the selected employee ID.
{
where_clause = where_clause + " and m.EmpId = '" + employee_id + "'";
}
else
{
where_clause += " and m.EmpId in (select EmpID from [FetchEmployees] ('" + current_user_id + "','" + employee_status + "'))";
}
if (employee_name != "")
{
where_clause = where_clause + " and e.Emp_Name like '%" + employee_name + "%'";
}
filter_conditions.Add("where", where_clause);
db_connection.ExecuteStoredProcedureWithHashtable_WithoutReturn("DailyPunchReport1", filter_conditions);
}
}
private void DeliverRecordDatabaseExecute()
{
int succ = 0;
try
{
DBConnection.OpenConnection();
DBConnection.cmd.CommandType = CommandType.StoredProcedure;
DBConnection.cmd.CommandText = "sp_insertFollowUP";
#region create Parameters
DBConnection.cmd.Parameters.Add(new SqlParameter("@DecisionNO", SqlDbType.BigInt));
DBConnection.cmd.Parameters.Add(new SqlParameter("@LastConnection", SqlDbType.DateTime));
DBConnection.cmd.Parameters.Add(new SqlParameter("@Notice", SqlDbType.NText));
DBConnection.cmd.Parameters.Add(new SqlParameter("@Comment", SqlDbType.NText));
DBConnection.cmd.Parameters.Add(new SqlParameter("@ReceivedDate", SqlDbType.Date));
DBConnection.cmd.Parameters.Add(new SqlParameter("@VisitDate", SqlDbType.Date));
DBConnection.cmd.Parameters.Add(new SqlParameter("@DeliverDate", SqlDbType.Date));
DBConnection.cmd.Parameters.Add(new SqlParameter("@Distance", SqlDbType.TinyInt));
DBConnection.cmd.Parameters.Add(new SqlParameter("@FStatus", SqlDbType.TinyInt));
DBConnection.cmd.Parameters.Add(new SqlParameter("@Scribe_ssn", SqlDbType.BigInt));
DBConnection.cmd.Parameters.Add(new SqlParameter("@Observer_ssn", SqlDbType.BigInt));
DBConnection.cmd.Parameters.Add(new SqlParameter("@Success", SqlDbType.Int));
#endregion
#region set value in parameters
DBConnection.cmd.Parameters["@DecisionNO"].Value = long.Parse(DecisionNO);
DBConnection.cmd.Parameters["@LastConnection"].Value = DBNull.Value;
DBConnection.cmd.Parameters["@Notice"].Value = DBNull.Value;
DBConnection.cmd.Parameters["@Comment"].Value = DBNull.Value;
DBConnection.cmd.Parameters["@ReceivedDate"].Value = ReceivedDate;
DBConnection.cmd.Parameters["@VisitDate"].Value = DBNull.Value;
DBConnection.cmd.Parameters["@DeliverDate"].Value = DBNull.Value;
DBConnection.cmd.Parameters["@Distance"].Value = Distance;
DBConnection.cmd.Parameters["@FStatus"].Value = 0;
DBConnection.cmd.Parameters["@Scribe_ssn"].Value = Properties.Settings.Default.EmpNo;
DBConnection.cmd.Parameters["@Observer_ssn"].Value = employee.Ssn;
#endregion
DBConnection.cmd.Parameters["@Success"].Direction = ParameterDirection.Output;
DBConnection.cmd.ExecuteNonQuery();
succ = (int)DBConnection.cmd.Parameters["@Success"].Value;
#region messge box
// It Was Stored in Database
if (succ == 1)
{
MessageBox.Show("تم تحويل المحضر للمتابعة بنجاح", "", MessageBoxButton.OK, MessageBoxImage.None,
MessageBoxResult.OK, MessageBoxOptions.RightAlign | MessageBoxOptions.RtlReading);
}
//record is not exist
else if (succ == 2)
{
MessageBox.Show("رقم المحضر غير موجود", "", MessageBoxButton.OK, MessageBoxImage.Error,
MessageBoxResult.OK, MessageBoxOptions.RightAlign | MessageBoxOptions.RtlReading);
}
// follow up Already exist
else if (succ == 3)
{
MessageBox.Show("المحظر حول للمتابعة بالفعل", "", MessageBoxButton.OK, MessageBoxImage.Error,
MessageBoxResult.OK, MessageBoxOptions.RightAlign | MessageBoxOptions.RtlReading);
}
// EMPLOYEE is not exist
else if (succ == 4)
{
MessageBox.Show("رقم المتابع غير موجود", "", MessageBoxButton.OK, MessageBoxImage.Error,
MessageBoxResult.OK, MessageBoxOptions.RightAlign | MessageBoxOptions.RtlReading);
}
// It is not Stored in Database
else
{
MessageBox.Show("لم يتم تحويل المحضر للمتابعة الرجاء التاكد من البيانات", "", MessageBoxButton.OK, MessageBoxImage.Error,
MessageBoxResult.OK, MessageBoxOptions.RightAlign | MessageBoxOptions.RtlReading);
}
#endregion
}
catch (Exception ex)
{
MessageBox.Show("لم يتم تحويل المحضر للمتابعة الرجاء التاكد من الاتصال بالسيرفر" + Environment.NewLine + "الخطأ : " + ex.Message.ToString(), "", MessageBoxButton.OK, MessageBoxImage.Error,
MessageBoxResult.OK, MessageBoxOptions.RightAlign | MessageBoxOptions.RtlReading);
}
finally
{
DBConnection.CloseConnection();
}
}
public LocationsController(DBConnection context)
{
_context = context;
}
public static ReturnObject DeleteHoliday(string current)
{
masters_holiday page_object = new masters_holiday();
DBConnection db_connection = new DBConnection();
ReturnObject return_object = new ReturnObject();
string query = string.Empty;
int count = 0;
string
company_code = string.Empty,
holiday_group_code = string.Empty,
holiday_code = string.Empty,
holiday_from = string.Empty,
holiday_to = string.Empty,
holiday_type = string.Empty;
if (HttpContext.Current.Session["username"] == null) // checking session expired or not
{
return_object = page_object.DoLogout();
}
else
{
try
{
JObject current_data = JObject.Parse(current);
holiday_code = current_data["holiday_code"].ToString();
holiday_from = current_data["holiday_from"].ToString();
holiday_to = current_data["holiday_to"].ToString();
company_code = current_data["company_code"].ToString();
holiday_type = current_data["holiday_type"].ToString();
query = "select count(*) from HolidayListDetails where holcode in(select distinct holcode from HolidayMaster where holcode = '" + holiday_code + "')";
count = db_connection.GetRecordCount(query);
if (count > 0)
{
return_object.status = "error";
return_object.return_data = "Holidays have been mapped to Holiday Group List. Please unassign the holidays from the Holiday Group List and try again.";
}
else
{
page_object.UpdateDatabase(holiday_code, null, holiday_from, holiday_to, company_code, "0", holiday_code, "D", holiday_type);
return_object.status = "success";
return_object.return_data = "Holiday deleted successfully!";
}
}
catch (Exception Ex)
{
Logger.LogException(Ex, page, "DELETE_HOLIDAY");
return_object.status = "error";
return_object.return_data = "An error occurred while performing this operation. Please try again. If the error persists, please contact Support";
throw;
}
finally
{
page_object.Dispose();
}
}
return(return_object);
}
public static ReturnObject EditHoliday(string current, string previous)
{
masters_holiday page_object = new masters_holiday();
DBConnection db_connection = new DBConnection();
ReturnObject return_object = new ReturnObject();
string query = string.Empty;
string holiday_code = string.Empty;
string holiday_name = string.Empty;
string holiday_from = string.Empty;
string holiday_to = string.Empty;
string company_code = string.Empty;
string holiday_type = string.Empty;
string original_holiday_name = string.Empty;
string original_holiday_from = string.Empty;
string original_holiday_to = string.Empty;
int count = 0;
if (HttpContext.Current.Session["username"] == null) // checking session expired or not
{
return_object = page_object.DoLogout();
}
else
{
try
{
JObject current_data = JObject.Parse(current);
JObject original_data = JObject.Parse(previous);
holiday_code = current_data["holiday_code"].ToString();
holiday_name = current_data["holiday_name"].ToString();
holiday_from = current_data["holiday_from"].ToString();
holiday_to = current_data["holiday_to"].ToString();
company_code = current_data["company_code"].ToString();
holiday_type = current_data["holiday_type"].ToString();
original_holiday_name = original_data["holiday_name"].ToString();
original_holiday_from = original_data["holiday_from"].ToString();
original_holiday_to = original_data["holiday_to"].ToString();
if (original_holiday_name != holiday_name)
{
count = page_object.CheckHolidayName(holiday_name, company_code);
if (count > 0)
{
return_object.status = "error";
return_object.return_data = "A Holiday with the same Name has been created. Please try again with a different Holiday Name.";
return(return_object);
}
}
Debug.Write(original_holiday_from + " " + holiday_from);
if (original_holiday_from != holiday_from || original_holiday_to != holiday_to)
{
count = page_object.CheckHolidayDates(holiday_from, holiday_to);
if (count > 0)
{
return_object.status = "error";
return_object.return_data = "The selected From and To Dates have been mapped to another Holiday. Please try again with different Dates";
return(return_object);
}
}
page_object.UpdateDatabase(holiday_code, holiday_name, holiday_from, holiday_to, company_code, "0", holiday_code, "U", holiday_type);
return_object.status = "success";
return_object.return_data = "Holiday edited successfully!";
}
catch (Exception Ex)
{
Logger.LogException(Ex, page, "EDIT_HOLIDAY");
return_object.status = "error";
return_object.return_data = "An error occurred while performing this operation. Please try again. If the error persists, please contact Support";
throw;
}
finally
{
page_object.Dispose();
}
}
return(return_object);
}
/// <summary>
/// Making the use of Database Transactions possible on a sequence of operations across multiple DataObjects.
/// </summary>
/// <param name="connection_in">opened Database connection with an initiated Transaction</param>
public DO_Word(DBConnection connection_in) : base(connection_in)
{
}
protected void Button1_Click(object sender, EventArgs e)
{
bool methodCheck = true;
//check a requirement password format
Regex RK = new Regex("^(?=.*?[A-Z])(?=.*?[a-z])(?=.*?[0-9])(?=.*?[#?!@$%^&*-]).{4,12}$");
if (InputValidation.ValidationPassword(TextBox6.Text, TextBox7.Text) == false)
{
methodCheck = false;
}
if (!RK.IsMatch(TextBox6.Text))
{
methodCheck = false;
}
if (methodCheck == true)
{
Dbm.ConnectDB();
query = "Select email, Fname FROM USERTABLE WHERE email = @email AND Fname = @Fname";
Dbm.GetCommend(query);
Dbm.AddVal("@email", TextBox1.Text);
Dbm.AddVal("@Fname", TextBox5.Text);
SqlDataReader reader = Dbm.ExeReader();
if (reader.HasRows && reader.Read())
{
Dbm.CloseDB();
DBConnection Db2 = new DBConnection();
Db2.ConnectDB();
query = "UPDATE USERTABLE Set Password = @Password";
Db2.GetCommend(query);
//process to hash password to store in sql
String saltHashReturned = PasswordHash.CreateHash(TextBox6.Text);
int commaIndex = saltHashReturned.IndexOf(":");
String extractedString = saltHashReturned.Substring(0, commaIndex);
commaIndex = saltHashReturned.IndexOf(":");
extractedString = saltHashReturned.Substring(commaIndex + 1);
commaIndex = extractedString.IndexOf(":");
String salt = extractedString.Substring(0, commaIndex);
commaIndex = extractedString.IndexOf(":");
extractedString = extractedString.Substring(commaIndex + 1);
String hash = extractedString;
//from the first : to the second is a salt
//from the second " to the end is a hash
Db2.AddVal("@Password", saltHashReturned);
//sql execute
Db2.ExeQuery();
Response.Redirect("index.aspx");
Db2.CloseDB();
}
else
{
Label1.Visible = true;
Label1.Text = "Username and Name is not matching";
}
}
if (methodCheck == false)
{
Label1.Visible = true;
Label1.Text = "At least one upper case English letter." + " <br /> " +
"At least one lower case English letter," + "<br />" +
"At least one digit." + "<br />" +
"At least one special character." + "<br />" +
"Minimum 4 and maximum 12 in length . ";
}
}
public VentanaMantenimientoDao(IConfiguration config)
{
_db = new DBConnection(config);
}
public void OnRoundEnd(RoundEndEvent ev)
{
if (ConfigManager.Manager.Config.GetBoolValue("rank_enabled", true))
{
DBConnection db = new DBConnection(main);
switch (ev.Status)
{
case Smod2.API.ROUND_END_STATUS.CI_VICTORY:
foreach (Player p in PluginManager.Manager.Server.GetPlayers())
{
switch (p.TeamRole.Team)
{
case Smod2.API.Team.CLASSD:
db.AddPoint(p.SteamId, main.GetConfigInt("rank_point_win_ci_classd"));
break;
case Smod2.API.Team.CHAOS_INSURGENCY:
db.AddPoint(p.SteamId, main.GetConfigInt("rank_point_win_ci_ci"));
break;
case Smod2.API.Team.SPECTATOR:
db.AddPoint(p.SteamId, main.GetConfigInt("rank_point_win_ci_spectator"));
break;
}
}
return;
case Smod2.API.ROUND_END_STATUS.MTF_VICTORY:
foreach (Player p in PluginManager.Manager.Server.GetPlayers())
{
switch (p.TeamRole.Team)
{
case Smod2.API.Team.NINETAILFOX:
db.AddPoint(p.SteamId, main.GetConfigInt("rank_point_win_mtf_mtf"));
break;
case Smod2.API.Team.SCIENTIST:
db.AddPoint(p.SteamId, main.GetConfigInt("rank_point_win_mtf_scient"));
break;
case Smod2.API.Team.SPECTATOR:
db.AddPoint(p.SteamId, main.GetConfigInt("rank_point_win_mtf_spectator"));
break;
}
}
return;
case Smod2.API.ROUND_END_STATUS.SCP_CI_VICTORY:
foreach (Player p in PluginManager.Manager.Server.GetPlayers())
{
switch (p.TeamRole.Team)
{
case Smod2.API.Team.SCP:
db.AddPoint(p.SteamId, main.GetConfigInt("rank_point_win_scpci_scp"));
break;
case Smod2.API.Team.CHAOS_INSURGENCY:
db.AddPoint(p.SteamId, main.GetConfigInt("rank_point_win_scpci_ci"));
break;
case Smod2.API.Team.SPECTATOR:
db.AddPoint(p.SteamId, main.GetConfigInt("rank_point_win_scpci_spectator"));
break;
}
}
return;
case Smod2.API.ROUND_END_STATUS.SCP_VICTORY:
foreach (Player p in PluginManager.Manager.Server.GetPlayers())
{
switch (p.TeamRole.Team)
{
case Smod2.API.Team.SCP:
db.AddPoint(p.SteamId, main.GetConfigInt("rank_point_win_scp_scp"));
break;
case Smod2.API.Team.SPECTATOR:
db.AddPoint(p.SteamId, main.GetConfigInt("rank_point_win_scp_spectator"));
break;
}
}
return;
}
}
}
public VentanaMantenimientoDao(IConfiguration config, string con)
{
_db = new DBConnection(config, con);
}
public void OnPost(int id, int currentBooks, int addedBooks)
{
// Connect to Database
DBConnection dbstring = new DBConnection();
string DbConnection = dbstring.DbString();
SqlConnection conn = new SqlConnection(DbConnection);
conn.Open();
// SQL Query
using (SqlCommand command = new SqlCommand())
{
command.Connection = conn;
if (currentBooks == 0)
{
// First read PreloanBook Table as we need to know if any customers have preloaned the book as they will instantly loan the book
command.CommandText = @"SELECT TOP(@BFirst) UsernameId FROM PreLoanedBook WHERE BookId = @BId ORDER BY DatePreLoaned";
command.Parameters.AddWithValue("@BFirst", addedBooks);
command.Parameters.AddWithValue("@BId", id);
SqlDataReader reader = command.ExecuteReader(); // read records
PreLoanedBooks = new List <PreLoanedBook>();
// Get each username who pre-loan the book
while (reader.Read())
{
PreLoanedBook PreLoanedBook = new PreLoanedBook();
PreLoanedBook.CustomerId = reader.GetInt32(0);
PreLoanedBooks.Add(PreLoanedBook);
}
reader.Close();
// If the Book List is empty then no one has pre-loaned that book
if (PreLoanedBooks.Count != 0)
{
// Delete the records from the table for that book as the users who have the earliest date take priority
command.CommandText = @"DELETE FROM PreLoanedBook WHERE Id IN(SELECT TOP(@BFirst) Id FROM PreLoanedBook WHERE BookId = @BId ORDER BY DatePreLoaned)";
command.ExecuteNonQuery();
for (int i = 0; i < PreLoanedBooks.Count; i++)
{
// Add those records to LoanedBook Table & add the Dates
command.CommandText = @"INSERT INTO LoanedBook (UsernameId, BookId, DateLoaned, DateReturned) VALUES (@CId" + i + ", @BId, @DLoaned" + i + ", @DReturned" + i + ")";
command.Parameters.AddWithValue("@CId" + i, PreLoanedBooks[i].CustomerId);
// already defined BookId earlier on, so automatically added
DateTime currentDate = DateTime.Now; // get the current time
command.Parameters.AddWithValue("@DLoaned" + i, currentDate); // they now loan the book as of now
command.Parameters.AddWithValue("@DReturned" + i, currentDate.AddDays(7)); // this is the returned due date
command.ExecuteNonQuery();
}
// change the value - people who preloan the book take priorty
currentBooks = addedBooks - PreLoanedBooks.Count;
}
else
{
// If no one has preloaned the book we can just simply add it on
currentBooks += addedBooks;
}
}
else
{
// If no one has preloaned the book we can just simply add it on
currentBooks += addedBooks;
}
// Update the quantity
command.CommandText = @"UPDATE Book SET Quantity = @BQuantity WHERE Id = @BookId";
command.Parameters.AddWithValue("@BookId", id);
command.Parameters.AddWithValue("@BQuantity", currentBooks);
command.ExecuteNonQuery();
}
// Update the page
OnGet();
}
public static async Task AddWarningAsync(IUser User, DBConnection dbCon, bool ban = false)
{
ulong userid = User.Id;
bool Found = false;
string query = "SELECT * FROM user_profiles WHERE user_id = @userid;";
var cmd = new MySqlCommand(query, dbCon.Connection);
cmd.Parameters.Add("@userid", MySqlDbType.UInt64).Value = userid;
var reader = await cmd.ExecuteReaderAsync();
while (await reader.ReadAsync() && Found == false)
{
int warnings = reader.GetInt32(6) + 1;
if (warnings < 3 && ban == false)
{
// Warn them
cmd.Dispose();
reader.Close();
await User.SendMessageAsync("A global chat moderator has warned you for your actions. Please keep the chat mature!");
query = "UPDATE user_profiles SET count_warnings = @count_warnings WHERE user_id = @userid";
cmd = new MySqlCommand(query, dbCon.Connection);
cmd.Parameters.Add("@userid", MySqlDbType.UInt64).Value = userid;
cmd.Parameters.Add("@count_warnings", MySqlDbType.UInt32).Value = warnings;
try
{
Console.WriteLine("Warned user " + User.Username + ".");
Found = true;
await cmd.ExecuteNonQueryAsync();
cmd.Dispose();
}
catch (Exception e)
{
Console.WriteLine("Error: " + e.Message);
cmd.Dispose();
}
}
else
{
// Blacklist them
cmd.Dispose();
reader.Close();
await User.SendMessageAsync("A global chat moderator has warned you for your actions. You have been blacklisted!");
query = "UPDATE user_profiles SET count_warnings = @count_warnings, user_blacklisted = @blacklisted WHERE user_id = @userid";
cmd = new MySqlCommand(query, dbCon.Connection);
cmd.Parameters.Add("@userid", MySqlDbType.UInt64).Value = userid;
cmd.Parameters.Add("@count_warnings", MySqlDbType.UInt32).Value = 3;
cmd.Parameters.Add("@blacklisted", MySqlDbType.UInt32).Value = 1;
try
{
Console.WriteLine("Blacklisted user " + User.Username + ".");
Found = true;
await cmd.ExecuteNonQueryAsync();
cmd.Dispose();
}
catch (Exception e)
{
Console.WriteLine("Error: " + e.Message);
cmd.Dispose();
}
}
}
dbCon.Close();
}
public static long insObject(
string sessionGuid_in,
string ip_forLogPurposes_in,
SO_NWS_Attachment attachment_in,
SO_DIC__TextLanguage[] tx_Name_in,
SO_DIC__TextLanguage[] tx_Description_in,
bool selectIdentity_in,
out string guid_out,
out int[] errors_out
)
{
guid_out = "";
long _output = -1L;
Guid _sessionguid;
Sessionuser _sessionuser;
#region check...
List <int> _errorlist;
if (!check(
sessionGuid_in,
ip_forLogPurposes_in,
ref attachment_in,
out _sessionguid,
out _sessionuser,
out _errorlist
))
{
errors_out = _errorlist.ToArray();
return(_output);
}
#endregion
#region check Existence . . .
if (
(attachment_in.IFContent <= 0)
||
!DO_NWS_Content.isObject(attachment_in.IFContent)
)
{
_errorlist.Add(ErrorType.data__not_found);
errors_out = _errorlist.ToArray();
return(_output);
}
#endregion
// ToDos: here! should mark Content to be re-Approved!
// ToDos: here! or not allow if no approve permission
attachment_in.GUID
= guid_out
= Guid.NewGuid().ToString("N");
attachment_in.Order = DateTime.Now.Ticks;
Exception _exception = null;
#region DBConnection _con = DO__Utilities.DBConnection_createInstance(...);
DBConnection _con = DO__Utilities.DBConnection_createInstance(
DO__Utilities.DBServerType,
DO__Utilities.DBConnectionstring,
DO__Utilities.DBLogfile
);
#endregion
try {
//if (
// (
// (tx_Name_in != null)
// &&
// (tx_Name_in.Length != 0))
// ||
// (
// (tx_Description_in != null)
// &&
// (tx_Description_in.Length != 0)
// )
//) {
_con.Open();
_con.Transaction.Begin();
//}
#region content_in.TX_Name = ...;
if (
(tx_Name_in == null)
||
(tx_Name_in.Length == 0)
)
{
attachment_in.TX_Name_isNull = true;
}
else
{
attachment_in.TX_Name = SBO_DIC_Dic.insObject(
_con,
_sessionuser.IDApplication,
OGen.NTier.Kick.Libraries.BusinessLayer.Shared.TableFieldSource.NWS_ATTACHMENT__TX_NAME,
tx_Name_in
);
}
#endregion
#region content_in.TX_Description = ...;
if (
(tx_Description_in == null)
||
(tx_Description_in.Length == 0)
)
{
attachment_in.TX_Description_isNull = true;
}
else
{
attachment_in.TX_Description = SBO_DIC_Dic.insObject(
_con,
_sessionuser.IDApplication,
OGen.NTier.Kick.Libraries.BusinessLayer.Shared.TableFieldSource.NWS_ATTACHMENT__TX_DESCRIPTION,
tx_Description_in
);
}
#endregion
_output = DO_NWS_Attachment.insObject(
attachment_in,
selectIdentity_in,
_con
);
_errorlist.Add(ErrorType.news__attachment__successfully_created__WARNING);
#region _con.Transaction.Commit();
if (
_con.IsOpen
&&
_con.Transaction.InTransaction
)
{
_con.Transaction.Commit();
}
#endregion
} catch (Exception _ex) {
#region _con.Transaction.Rollback();
if (
_con.IsOpen
&&
_con.Transaction.InTransaction
)
{
_con.Transaction.Rollback();
}
#endregion
_exception = _ex;
} finally {
#region _con.Transaction.Terminate(); _con.Close(); _con.Dispose();
if (_con.IsOpen)
{
if (_con.Transaction.InTransaction)
{
_con.Transaction.Terminate();
}
_con.Close();
}
_con.Dispose();
#endregion
}
if (_exception != null)
{
#region SBO_LOG_Log.Log(ErrorType.data);
OGen.NTier.Kick.Libraries.BusinessLayer.SBO_LOG_Log.log(
_sessionuser,
LogType.error,
ErrorType.data,
-1L,
_sessionuser.IDApplication,
"{0}",
new string[] {
_exception.Message
}
);
#endregion
_errorlist.Add(ErrorType.data);
}
errors_out = _errorlist.ToArray();
return(_output);
}
private void UpdateDatabase(JObject data, string mode)
{
DBConnection db_connection = new DBConnection();
Hashtable shift_data = new Hashtable();
string company_code = data["company_code"].ToString();
string shift_code = data["shift_code"].ToString();
string shift_name = data["shift_desc"].ToString();
int check_normal_shift = Convert.ToInt32(data["check_if_normal_shift"]);
DateTime start_time = new DateTime();
string break_out = data["break_out"].ToString();
string break_in = data["break_in"].ToString();
DateTime end_time = new DateTime();
string normal_shift_grace_in = data["in_grace"].ToString();
string normal_shift_grace_break_out = data["break_out_grace"].ToString();
string normal_shift_grace_break_in = data["break_in_grace"].ToString();
string normal_shift_grace_out = data["out_grace"].ToString();
string ramdan_start_time = data["ramadan_in_time"].ToString();
string ramdan_end_time = data["ramadan_out_time"].ToString();
int check_night_shift = Convert.ToInt32(data["status_night_shift"]);
string night_shift = data["max_shift_end_cut_off_time"].ToString();
string night_shift_grace_in = data["grace_in"].ToString();
string night_shift_grace_out = data["grace_out"].ToString();
string night_shift_grace_break_in = data["grace_break_in"].ToString();
string night_shift_grace_break_out = data["grace_break_out"].ToString();
int check_overtime = Convert.ToInt32(data["overtime"]);
string min_overtime = data["min_overtime"].ToString();
string max_overtime = data["max_overtime"].ToString();
int check_half_day = Convert.ToInt32(data["status_half_day"]);
string half_day = data["half_day"].ToString();
string half_day_start = data["start_time_half_day"].ToString();
string half_day_end = data["end_time_half_day"].ToString();
string week_off_1 = data["weekly_off1"].ToString();
string week_off_2 = data["weekly_off2"].ToString();
string Branch_Code = data["branch"].ToString();
string Employee_Category_Code = data["category"].ToString();
int IsAutoShiftEligible = Convert.ToInt32(data["auto_checked"].ToString());
int IsActive = Convert.ToInt32(data["is_active"].ToString());
// The mode of the DB operation to be performed.
// I = Insert
// U = Update
shift_data.Add("Mode", mode);
// Basic data regarding the shift and settings.
shift_data.Add("CompanyCode", company_code);
shift_data.Add("ShiftCode ", shift_code.ToUpper());
shift_data.Add("ShiftName", shift_name);
DateTime.TryParse(data["in_time"].ToString(), out start_time);
shift_data.Add("StartTime", start_time);
DateTime.TryParse(data["out_time"].ToString(), out end_time);
shift_data.Add("EndTime", end_time);
shift_data.Add("HalfDayendtime", half_day_end == string.Empty ? Convert.ToDateTime(Convert.ToDateTime(DateTime.Today.ToShortDateString())) : Convert.ToDateTime(half_day_end));
if (Convert.ToInt32(data["status_night_shift"]) == 0)
{
shift_data.Add("MaxOverTime", "");
}
else
{
shift_data.Add("MaxOverTime", night_shift);
}
if (half_day == "select")
{
half_day = null;
}
shift_data.Add("HalfDay", half_day);
if (Convert.ToInt32(data["overtime"]) == 0)
{
shift_data.Add("MaxWorkTime", "");
shift_data.Add("minovertime", "");
}
else
{
shift_data.Add("MaxWorkTime", max_overtime);
shift_data.Add("minovertime", min_overtime);
}
// Processing Weekly Off data and settings.
if (week_off_1 == "select")
{
week_off_1 = null;
}
shift_data.Add("WeakOff1", week_off_1);
if (week_off_2 == "select")
{
week_off_2 = null;
}
shift_data.Add("WeakOff2", week_off_2);
shift_data.Add("breakout", break_out);
shift_data.Add("breakin", break_in);
shift_data.Add("sgrace", normal_shift_grace_in);
shift_data.Add("boutgrace", normal_shift_grace_break_out);
shift_data.Add("bingrace", normal_shift_grace_break_in);
shift_data.Add("egrace", normal_shift_grace_out);
shift_data.Add("InGrace", night_shift_grace_in == string.Empty ? "0" : night_shift_grace_in);
shift_data.Add("OutGrace", night_shift_grace_out == string.Empty ? "0" : night_shift_grace_out);
shift_data.Add("Bin_Grace", night_shift_grace_break_in == string.Empty ? "0" : night_shift_grace_break_in);
shift_data.Add("Bout_Grace", night_shift_grace_break_out == string.Empty ? "0" : night_shift_grace_break_out);
DateTime ramdan_start = Convert.ToDateTime(ramdan_start_time == string.Empty ? Convert.ToDateTime(Convert.ToDateTime(DateTime.Today.ToShortDateString())) : Convert.ToDateTime(ramdan_start_time));
shift_data.Add("Ramadan_StartTime", ramdan_start);
DateTime ramdan_end = Convert.ToDateTime(ramdan_end_time == string.Empty ? Convert.ToDateTime(Convert.ToDateTime(DateTime.Today.ToShortDateString())) : Convert.ToDateTime(ramdan_end_time));
shift_data.Add("Ramadan_EndTime", ramdan_end);
shift_data.Add("ifNormalShift", check_normal_shift.ToString());
//for autoshift
shift_data.Add("Branch_Code", Branch_Code);
shift_data.Add("Employee_Category_Code", Employee_Category_Code);
shift_data.Add("IsAutoShiftEligible", IsAutoShiftEligible);
shift_data.Add("IsActive", IsActive);
shift_data.Add("HalfDaystarttime", half_day_start == string.Empty ? Convert.ToDateTime(Convert.ToDateTime(DateTime.Today.ToShortDateString())) : Convert.ToDateTime(half_day_start));
db_connection.ExecuteStoredProcedureWithHashtable_WithoutReturn("General", shift_data);
}
public static void updObject(
string sessionGuid_in,
string ip_forLogPurposes_in,
SO_NWS_Attachment attachment_in,
SO_DIC__TextLanguage[] tx_Name_in,
SO_DIC__TextLanguage[] tx_Description_in,
out int[] errors_out
)
{
Guid _sessionguid;
Sessionuser _sessionuser;
#region check...
List <int> _errorlist;
if (!check(
sessionGuid_in,
ip_forLogPurposes_in,
ref attachment_in,
out _sessionguid,
out _sessionuser,
out _errorlist
))
{
errors_out = _errorlist.ToArray();
return;
}
#endregion
#region check existence . . .
SO_NWS_Attachment _attachment;
if (
attachment_in.IDAttachment <= 0
||
(
(_attachment = DO_NWS_Attachment.getObject(
attachment_in.IDAttachment
)) == null
)
)
{
_errorlist.Add(ErrorType.data__not_found);
errors_out = _errorlist.ToArray();
return;
}
#endregion
// ToDos: here! should mark Content to be re-Approved!
// ToDos: here! or not allow if no approve permission
Exception _exception = null;
#region DBConnection _con = DO__Utilities.DBConnection_createInstance(...);
DBConnection _con = DO__Utilities.DBConnection_createInstance(
DO__Utilities.DBServerType,
DO__Utilities.DBConnectionstring,
DO__Utilities.DBLogfile
);
#endregion
try {
_con.Open();
_con.Transaction.Begin();
#region TX_Name . . .
if ((tx_Name_in != null) && (tx_Name_in.Length != 0))
{
if (_attachment.TX_Name_isNull)
{
_attachment.TX_Name = SBO_DIC_Dic.insObject(
_con,
_sessionuser.IDApplication,
OGen.NTier.Kick.Libraries.BusinessLayer.Shared.TableFieldSource.NWS_ATTACHMENT__TX_NAME,
tx_Name_in
);
}
else
{
SBO_DIC_Dic.updObject(
_con,
_attachment.TX_Name,
tx_Name_in
);
}
}
#endregion
#region TX_Description . . .
if ((tx_Description_in != null) && (tx_Description_in.Length != 0))
{
if (_attachment.TX_Description_isNull)
{
_attachment.TX_Description = SBO_DIC_Dic.insObject(
_con,
_sessionuser.IDApplication,
OGen.NTier.Kick.Libraries.BusinessLayer.Shared.TableFieldSource.NWS_ATTACHMENT__TX_DESCRIPTION,
tx_Description_in
);
}
else
{
SBO_DIC_Dic.updObject(
_con,
_attachment.TX_Description,
tx_Description_in
);
}
}
#endregion
//_attachment.??? = attachment_in.???;
DO_NWS_Attachment.updObject(
_attachment,
true,
_con
);
_errorlist.Add(ErrorType.news__attachment__successfully_updated__WARNING);
#region _con.Transaction.Commit();
if (
_con.IsOpen
&&
_con.Transaction.InTransaction
)
{
_con.Transaction.Commit();
}
#endregion
} catch (Exception _ex) {
#region _con.Transaction.Rollback();
if (
_con.IsOpen
&&
_con.Transaction.InTransaction
)
{
_con.Transaction.Rollback();
}
#endregion
_exception = _ex;
} finally {
#region _con.Transaction.Terminate(); _con.Close(); _con.Dispose();
if (_con.IsOpen)
{
if (_con.Transaction.InTransaction)
{
_con.Transaction.Terminate();
}
_con.Close();
}
_con.Dispose();
#endregion
}
if (_exception != null)
{
#region SBO_LOG_Log.Log(ErrorType.data);
OGen.NTier.Kick.Libraries.BusinessLayer.SBO_LOG_Log.log(
_sessionuser,
LogType.error,
ErrorType.data,
-1L,
_sessionuser.IDApplication,
"{0}",
new string[] {
_exception.Message
}
);
#endregion
_errorlist.Add(ErrorType.data);
}
errors_out = _errorlist.ToArray();
}
/// <summary>
/// Selects FRM_Question values from Database and assigns them to the appropriate DO_FRM_Question property.
/// </summary>
/// <param name="IDQuestion_in">IDQuestion</param>
/// <param name="dbConnection_in">Database connection, making the use of Database Transactions possible on a sequence of operations across the same or multiple DataObjects</param>
/// <returns>null if FRM_Question doesn't exists at Database</returns>
public static SO_FRM_Question getObject(
long IDQuestion_in,
DBConnection dbConnection_in
)
{
SO_FRM_Question _output = null;
DBConnection _connection = (dbConnection_in == null)
? DO__Utilities.DBConnection_createInstance(
DO__Utilities.DBServerType,
DO__Utilities.DBConnectionstring,
DO__Utilities.DBLogfile
)
: dbConnection_in;
IDbDataParameter[] _dataparameters = new IDbDataParameter[] {
_connection.newDBDataParameter("IDQuestion_", DbType.Int64, ParameterDirection.InputOutput, IDQuestion_in, 0),
_connection.newDBDataParameter("IFQuestion__parent_", DbType.Int64, ParameterDirection.Output, null, 0),
_connection.newDBDataParameter("IFQuestiontype_", DbType.Int32, ParameterDirection.Output, null, 0),
_connection.newDBDataParameter("TX_Question_", DbType.Int64, ParameterDirection.Output, null, 0),
_connection.newDBDataParameter("TX_Details_", DbType.Int64, ParameterDirection.Output, null, 0),
_connection.newDBDataParameter("IsRequired_", DbType.Boolean, ParameterDirection.Output, null, 0),
_connection.newDBDataParameter("IsTemplate_", DbType.Boolean, ParameterDirection.Output, null, 0),
_connection.newDBDataParameter("IFApplication_", DbType.Int32, ParameterDirection.Output, null, 0),
_connection.newDBDataParameter("IFUser__audit_", DbType.Int64, ParameterDirection.Output, null, 0),
_connection.newDBDataParameter("Date__audit_", DbType.DateTime, ParameterDirection.Output, null, 0)
};
_connection.Execute_SQLFunction("sp0_FRM_Question_getObject", _dataparameters);
if (dbConnection_in == null)
{
_connection.Dispose();
}
if (_dataparameters[0].Value != DBNull.Value)
{
_output = new SO_FRM_Question();
if (_dataparameters[0].Value == System.DBNull.Value)
{
_output.IDQuestion = 0L;
}
else
{
_output.IDQuestion = (long)_dataparameters[0].Value;
}
if (_dataparameters[1].Value == System.DBNull.Value)
{
_output.IFQuestion__parent_isNull = true;
}
else
{
_output.IFQuestion__parent = (long)_dataparameters[1].Value;
}
if (_dataparameters[2].Value == System.DBNull.Value)
{
_output.IFQuestiontype_isNull = true;
}
else
{
_output.IFQuestiontype = (int)_dataparameters[2].Value;
}
if (_dataparameters[3].Value == System.DBNull.Value)
{
_output.TX_Question_isNull = true;
}
else
{
_output.TX_Question = (long)_dataparameters[3].Value;
}
if (_dataparameters[4].Value == System.DBNull.Value)
{
_output.TX_Details_isNull = true;
}
else
{
_output.TX_Details = (long)_dataparameters[4].Value;
}
if (_dataparameters[5].Value == System.DBNull.Value)
{
_output.IsRequired_isNull = true;
}
else
{
_output.IsRequired = (bool)_dataparameters[5].Value;
}
if (_dataparameters[6].Value == System.DBNull.Value)
{
_output.IsTemplate_isNull = true;
}
else
{
_output.IsTemplate = (bool)_dataparameters[6].Value;
}
if (_dataparameters[7].Value == System.DBNull.Value)
{
_output.IFApplication_isNull = true;
}
else
{
_output.IFApplication = (int)_dataparameters[7].Value;
}
if (_dataparameters[8].Value == System.DBNull.Value)
{
_output.IFUser__audit = 0L;
}
else
{
_output.IFUser__audit = (long)_dataparameters[8].Value;
}
if (_dataparameters[9].Value == System.DBNull.Value)
{
_output.Date__audit = new DateTime(1900, 1, 1);
}
else
{
_output.Date__audit = (DateTime)_dataparameters[9].Value;
}
_output.HasChanges = false;
return(_output);
}
return(null);
}
protected void Page_Load(object sender, System.EventArgs e)
{
//CommonFunctions.Connection.Open ();
MainAdapter = CommonFunctions.PrepareAdapter(CommonFunctions.GetConnection(), "SELECT * FROM Users WHERE ID = @UserID", SqlDbType.Int);
CountriesAdapter = CommonFunctions.PrepareAdapter(CommonFunctions.GetConnection(), "SELECT DISTINCT(Country) AS Country " +
"FROM Users WHERE (IfAgent = 1) AND (LEN(Country) > 0) AND NOT (ID = @UserID)", SqlDbType.Int);
AgentsAdapter = CommonFunctions.PrepareAdapter(CommonFunctions.GetConnection(), "SELECT -1 AS ID, 'Not referred by anyone' AS FullName " +
"UNION SELECT ID, LastName + ', ' + FirstName AS FullName FROM Users WHERE (Country = @Country) AND" +
" (IfAgent = 1) AND NOT (ID = @UserID)", SqlDbType.NVarChar, 300, SqlDbType.Int);
IfAdmin.Visible = AuthenticationManager.IfAdmin && (AuthenticationManager.UserID != userid);
IfAdminLabel.Visible = AuthenticationManager.IfAdmin && (AuthenticationManager.UserID != userid);
MainAdapter.SelectCommand.Parameters["@UserID"].Value = userid;
//lock (CommonFunctions.Connection)
if (MainAdapter.Fill(MainDataSet, "Users") == 0)
{
Response.Redirect(CommonFunctions.PrepareURL("InternalError.aspx"), true);
}
//CountryRequired.Enabled = (MainDataSet.Tables["Users"].Rows[0]["IfAgent"] is bool) &&
// (bool)MainDataSet.Tables["Users"].Rows[0]["IfAgent"];
DBConnection obj = new DBConnection();
try
{
if (!IsPostBack)
{
DataTable dt = VADBCommander.CountyDistinctSimpleList();
ddlCountries.DataSource = dt;
//ddlCountries.DataTextField = "country";
//ddlCountries.DataValueField = "country";
if (ddlCountries.Items.Contains(new ListItem(MainDataSet.Tables["Users"].Rows[0]["country"].ToString(),
MainDataSet.Tables["Users"].Rows[0]["country"].ToString())))
{
ddlCountries.SelectedValue = MainDataSet.Tables["Users"].Rows[0]["country"].ToString();
}
//ddlCountries.DataBind();
}
}
catch (Exception ex) { Response.Write(ex.Message); }
finally { obj.CloseConnection(); }
if (!IsPostBack)
{
EmailAddress.Text = MainDataSet.Tables["Users"].Rows[0]["Email"].ToString();
FirstName.Text = MainDataSet.Tables["Users"].Rows[0]["FirstName"].ToString();
LastName.Text = MainDataSet.Tables["Users"].Rows[0]["LastName"].ToString();
CompanyName.Text = MainDataSet.Tables["Users"].Rows[0]["CompanyName"].ToString();
Address.Text = MainDataSet.Tables["Users"].Rows[0]["Address"].ToString();
City.Text = MainDataSet.Tables["Users"].Rows[0]["City"].ToString();
State.Text = MainDataSet.Tables["Users"].Rows[0]["State"].ToString();
Zip.Text = MainDataSet.Tables["Users"].Rows[0]["Zip"].ToString();
//foreach (ListItem li in ddlCountries.Items)
//{
// if (li.Value.ToLower() == MainDataSet.Tables["Users"].Rows[0]["Country"].ToString().ToLower())
// {
// ddlCountries.SelectedValue = MainDataSet.Tables["Users"].Rows[0]["Country"].ToString();
// }
//}
PrimaryTelephone.Text = MainDataSet.Tables["Users"].Rows[0]["PrimaryTelephone"].ToString();
EveningTelephone.Text = MainDataSet.Tables["Users"].Rows[0]["EveningTelephone"].ToString();
DaytimeTelephone.Text = MainDataSet.Tables["Users"].Rows[0]["DaytimeTelephone"].ToString();
MobileTelephone.Text = MainDataSet.Tables["Users"].Rows[0]["MobileTelephone"].ToString();
Website.Text = MainDataSet.Tables["Users"].Rows[0]["Website"].ToString();
Registered.Text = MainDataSet.Tables["Users"].Rows[0]["Registered"].ToString();
PayTravelAgents.Checked = MainDataSet.Tables["Users"].Rows[0]["IfPayTravelAgents"] is bool?
(bool)MainDataSet.Tables["Users"].Rows[0]["IfPayTravelAgents"] : false;
ReservationSame.Checked = MainDataSet.Tables["Users"].Rows[0]["IfReservationSame"] is bool?
(bool)MainDataSet.Tables["Users"].Rows[0]["IfReservationSame"] : false;
ReservationNotSame.Checked = !ReservationSame.Checked;
ReservationEmail.Text = MainDataSet.Tables["Users"].Rows[0]["ReservationEmail"].ToString();
ReservationFirstName.Text = MainDataSet.Tables["Users"].Rows[0]["ReservationFirstName"].ToString();
ReservationLastName.Text = MainDataSet.Tables["Users"].Rows[0]["ReservationLastName"].ToString();
if (IfAdmin.Visible)
{
IfAdmin.SelectedIndex = (MainDataSet.Tables["Users"].Rows[0]["IfAdmin"] is bool) &&
(bool)MainDataSet.Tables["Users"].Rows[0]["IfAdmin"] ? 0 : 1;
}
ReservationSame_CheckedChanged(sender, e);
CountriesAdapter.SelectCommand.Parameters["@UserID"].Value = userid;
//lock (CommonFunctions.Connection)
CountriesAdapter.Fill(MainDataSet, "Countries");
AgentCountries.DataSource = MainDataSet;
if (!IsPostBack)
{
DataBind();
}
if (MainDataSet.Tables["Users"].Rows[0]["ReferredByID"] is int)
{
object country = null;
using (SqlConnection connection = CommonFunctions.GetConnection()) {
connection.Open();
SqlCommand getcountry = new SqlCommand("SELECT Country FROM Users WHERE ID = @UserID", connection);
getcountry.Parameters.Add("@UserID", SqlDbType.Int, 4);
getcountry.Parameters["@UserID"].Value = (int)MainDataSet.Tables["Users"].Rows[0]["ReferredByID"];
country = getcountry.ExecuteScalar();
connection.Close();
}
if (country is string)
{
try
{
AgentCountries.SelectedValue = (string)country;
}
catch (Exception)
{
}
}
AgentCountries_SelectedIndexChanged(sender, e);
try
{
Agents.SelectedValue = ((int)MainDataSet.Tables["Users"].Rows[0]["ReferredByID"]).ToString();
}
catch (Exception)
{
}
}
else
{
AgentCountries_SelectedIndexChanged(sender, e);
}
}
}
private void iniciarSesionToolStripMenuItem_Click(object sender, EventArgs e)
{
int tries = 3;
do
{
LogIn li = new LogIn();
li.ShowDialog();
if (li.Valid)
{
string user = li.User;
string password = Crypto.Encrypt(li.Password);
DataTable dt = DBConnection.CheckLogIn(user, password);
if (dt.Rows.Count == 1)
{
switch ((int)dt.Rows[0][0])
{
case 10000:
currentRole = new Role("SuperAdmin", 10000);
break;
case 10001:
currentRole = new Role("Admin", 10001);
break;
case 10002:
currentRole = new Role("Manager", 10002);
break;
case 10003:
currentRole = new Role("Employee", 10003);
break;
case 10004:
currentRole = new Role("No role", 10004);
break;
default:
currentRole = null;
break;
}
updateRole();
tsslUser.Text = (string)dt.Rows[0][2];
tsslRole.Text = currentRole.ToString();
if (!this.Visible)
{
Show();
}
break;
}
else
{
MessageBox.Show(null, "Usuario o contraseña incorrectos\nIntentos restantes: " + --tries, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
} while (tries > 0);
if (tries == 0)
{
MessageBox.Show("Usuario incorrecto muchas veces\nCerrando programa");
Close();
}
}
private void mostrarArticulosToolStripMenuItem_Click(object sender, EventArgs e)
{
dgvResultados.DataSource = DBConnection.getItems();
}
private void mostrarEstadosToolStripMenuItem_Click(object sender, EventArgs e)
{
dgvResultados.DataSource = DBConnection.GetStatuses();
}
internal static void Generate(
DBConnection cn, TextWriter writer, string namespaceDeclaration, Database database, IEnumerable <string> tableNames,
Configuration.SystemDevelopment.Database configuration)
{
writer.WriteLine(namespaceDeclaration);
foreach (var table in tableNames)
{
CodeGenerationStatics.AddSummaryDocComment(writer, "Contains logic that retrieves rows from the " + table + " table.");
writer.WriteLine("public static partial class " + GetClassName(cn, table) + " {");
var isRevisionHistoryTable = DataAccessStatics.IsRevisionHistoryTable(table, configuration);
var columns = new TableColumns(cn, table, isRevisionHistoryTable);
// Write nested classes.
DataAccessStatics.WriteRowClasses(
writer,
columns.AllColumns,
localWriter => {
if (!isRevisionHistoryTable)
{
return;
}
writer.WriteLine(
"public UserTransaction Transaction { get { return RevisionHistoryStatics.UserTransactionsById[ RevisionHistoryStatics.RevisionsById[ System.Convert.ToInt32( " +
EwlStatics.GetCSharpIdentifier(columns.PrimaryKeyAndRevisionIdColumn.PascalCasedNameExceptForOracle) + " ) ].UserTransactionId ]; } }");
},
localWriter => {
if (!columns.DataColumns.Any())
{
return;
}
var modClass = database.SecondaryDatabaseName + "Modification." +
StandardModificationStatics.GetClassName(cn, table, isRevisionHistoryTable, isRevisionHistoryTable);
var revisionHistorySuffix = StandardModificationStatics.GetRevisionHistorySuffix(isRevisionHistoryTable);
writer.WriteLine("public " + modClass + " ToModification" + revisionHistorySuffix + "() {");
writer.WriteLine(
"return " + modClass + ".CreateForSingleRowUpdate" + revisionHistorySuffix + "( " +
StringTools.ConcatenateWithDelimiter(
", ",
columns.AllColumnsExceptRowVersion.Select(i => EwlStatics.GetCSharpIdentifier(i.PascalCasedNameExceptForOracle)).ToArray()) + " );");
writer.WriteLine("}");
});
writeCacheClass(cn, writer, database, table, columns, isRevisionHistoryTable);
var isSmallTable = configuration.SmallTables != null && configuration.SmallTables.Any(i => i.EqualsIgnoreCase(table));
var tableUsesRowVersionedCaching = configuration.TablesUsingRowVersionedDataCaching != null &&
configuration.TablesUsingRowVersionedDataCaching.Any(i => i.EqualsIgnoreCase(table));
if (tableUsesRowVersionedCaching && columns.RowVersionColumn == null && !(cn.DatabaseInfo is OracleInfo))
{
throw new UserCorrectableException(
cn.DatabaseInfo is MySqlInfo
? "Row-versioned data caching cannot currently be used with MySQL databases."
: "Row-versioned data caching can only be used with the {0} table if you add a rowversion column.".FormatWith(table));
}
if (isSmallTable)
{
writeGetAllRowsMethod(writer, isRevisionHistoryTable, false);
}
writeGetRowsMethod(cn, writer, database, table, columns, isSmallTable, tableUsesRowVersionedCaching, isRevisionHistoryTable, false);
if (isRevisionHistoryTable)
{
if (isSmallTable)
{
writeGetAllRowsMethod(writer, true, true);
}
writeGetRowsMethod(cn, writer, database, table, columns, isSmallTable, tableUsesRowVersionedCaching, true, true);
}
writeGetRowMatchingPkMethod(cn, writer, database, table, columns, isSmallTable, tableUsesRowVersionedCaching, isRevisionHistoryTable);
if (isRevisionHistoryTable)
{
DataAccessStatics.WriteGetLatestRevisionsConditionMethod(writer, columns.PrimaryKeyAndRevisionIdColumn.Name);
}
if (tableUsesRowVersionedCaching)
{
var keyTupleTypeArguments = getPkAndVersionTupleTypeArguments(cn, columns);
writer.WriteLine("private static " + "Cache<System.Tuple<" + keyTupleTypeArguments + ">, BasicRow>" + " getRowsByPkAndVersion() {");
writer.WriteLine(
"return AppMemoryCache.GetCacheValue<{0}>( \"{1}\", () => new {0}( i => System.Tuple.Create( {2} ) ) ).RowsByPkAndVersion;".FormatWith(
"VersionedRowDataCache<System.Tuple<{0}>, System.Tuple<{1}>, BasicRow>".FormatWith(getPkTupleTypeArguments(columns), keyTupleTypeArguments),
database.SecondaryDatabaseName + table.TableNameToPascal(cn) + "TableRetrievalRowsByPkAndVersion",
StringTools.ConcatenateWithDelimiter(", ", Enumerable.Range(1, columns.KeyColumns.Count()).Select(i => "i.Item{0}".FormatWith(i)).ToArray())));
writer.WriteLine("}");
}
// Initially we did not generate this method for small tables, but we found a need for it when the cache is disabled since that will cause
// GetRowMatchingId to repeatedly query.
if (columns.KeyColumns.Count() == 1 && columns.KeyColumns.Single().Name.ToLower().EndsWith("id"))
{
writeToIdDictionaryMethod(writer, columns);
}
if (isRevisionHistoryTable)
{
DataAccessStatics.WriteRevisionDeltaExtensionMethods(writer, GetClassName(cn, table), columns.DataColumns);
}
writer.WriteLine("}"); // class
}
writer.WriteLine("}"); // namespace
}
private void mostrarPersonaToolStripMenuItem_Click(object sender, EventArgs e)
{
dgvResultados.DataSource = DBConnection.getStaff();
}
private static void writeResultSetCreatorBody(
DBConnection cn, TextWriter writer, Database database, string table, TableColumns tableColumns, bool tableUsesRowVersionedCaching,
bool excludesPreviousRevisions, string cacheQueryInDbExpression)
{
if (tableUsesRowVersionedCaching)
{
writer.WriteLine("var results = new List<Row>();");
writer.WriteLine(DataAccessStatics.GetConnectionExpression(database) + ".ExecuteInTransaction( delegate {");
// Query for the cache keys of the results.
writer.WriteLine(
"var keyCommand = {0};".FormatWith(
getInlineSelectExpression(
table,
tableColumns,
"{0}, \"{1}\"".FormatWith(
StringTools.ConcatenateWithDelimiter(", ", tableColumns.KeyColumns.Select(i => "\"{0}\"".FormatWith(i.Name)).ToArray()),
cn.DatabaseInfo is OracleInfo ? "ORA_ROWSCN" : tableColumns.RowVersionColumn.Name),
cacheQueryInDbExpression)));
writer.WriteLine(getCommandConditionAddingStatement("keyCommand"));
writer.WriteLine("var keys = new List<System.Tuple<{0}>>();".FormatWith(getPkAndVersionTupleTypeArguments(cn, tableColumns)));
writer.WriteLine(
"keyCommand.Execute( " + DataAccessStatics.GetConnectionExpression(database) + ", r => { while( r.Read() ) keys.Add( " +
"System.Tuple.Create( {0}, {1} )".FormatWith(
StringTools.ConcatenateWithDelimiter(
", ",
tableColumns.KeyColumns.Select((c, i) => c.GetDataReaderValueExpression("r", ordinalOverride: i)).ToArray()),
cn.DatabaseInfo is OracleInfo
? "({0})r.GetValue( {1} )".FormatWith(oracleRowVersionDataType, tableColumns.KeyColumns.Count())
: tableColumns.RowVersionColumn.GetDataReaderValueExpression("r", ordinalOverride: tableColumns.KeyColumns.Count())) + " ); } );");
writer.WriteLine("var rowsByPkAndVersion = getRowsByPkAndVersion();");
writer.WriteLine("var cachedKeyCount = keys.Where( i => rowsByPkAndVersion.ContainsKey( i ) ).Count();");
// If all but a few results are cached, execute a single-row query for each missing result.
writer.WriteLine("if( cachedKeyCount >= keys.Count() - 1 || cachedKeyCount >= keys.Count() * .99 ) {");
writer.WriteLine("foreach( var key in keys ) {");
writer.WriteLine("results.Add( new Row( rowsByPkAndVersion.GetOrAdd( key, () => {");
writer.WriteLine("var singleRowCommand = {0};".FormatWith(getInlineSelectExpression(table, tableColumns, "\"*\"", "false")));
foreach (var i in tableColumns.KeyColumns.Select((c, i) => new { column = c, index = i }))
{
writer.WriteLine(
"singleRowCommand.AddCondition( ( ({0})new {1}( key.Item{2} ) ).CommandCondition );".FormatWith(
DataAccessStatics.GetTableConditionInterfaceName(cn, database, table),
DataAccessStatics.GetEqualityConditionClassName(cn, database, table, i.column),
i.index + 1));
}
writer.WriteLine("var singleRowResults = new List<BasicRow>();");
writer.WriteLine(
"singleRowCommand.Execute( " + DataAccessStatics.GetConnectionExpression(database) +
", r => { while( r.Read() ) singleRowResults.Add( new BasicRow( r ) ); } );");
writer.WriteLine("return singleRowResults.Single();");
writer.WriteLine("} ) ) );");
writer.WriteLine("}");
writer.WriteLine("}");
// Otherwise, execute the full query.
writer.WriteLine("else {");
writer.WriteLine(
"var command = {0};".FormatWith(
getInlineSelectExpression(
table,
tableColumns,
cn.DatabaseInfo is OracleInfo ? "\"{0}.*\", \"ORA_ROWSCN\"".FormatWith(table) : "\"*\"",
cacheQueryInDbExpression)));
writer.WriteLine(getCommandConditionAddingStatement("command"));
writer.WriteLine("command.Execute( " + DataAccessStatics.GetConnectionExpression(database) + ", r => {");
writer.WriteLine(
"while( r.Read() ) results.Add( new Row( rowsByPkAndVersion.GetOrAdd( System.Tuple.Create( {0}, {1} ), () => new BasicRow( r ) ) ) );".FormatWith(
StringTools.ConcatenateWithDelimiter(", ", tableColumns.KeyColumns.Select(i => i.GetDataReaderValueExpression("r")).ToArray()),
cn.DatabaseInfo is OracleInfo
? "({0})r.GetValue( {1} )".FormatWith(oracleRowVersionDataType, tableColumns.AllColumns.Count())
: tableColumns.RowVersionColumn.GetDataReaderValueExpression("r")));
writer.WriteLine("} );");
writer.WriteLine("}");
writer.WriteLine("} );");
}
else
{
writer.WriteLine("var command = {0};".FormatWith(getInlineSelectExpression(table, tableColumns, "\"*\"", cacheQueryInDbExpression)));
writer.WriteLine(getCommandConditionAddingStatement("command"));
writer.WriteLine("var results = new List<Row>();");
writer.WriteLine(
"command.Execute( " + DataAccessStatics.GetConnectionExpression(database) +
", r => { while( r.Read() ) results.Add( new Row( new BasicRow( r ) ) ); } );");
}
// Add all results to RowsByPk.
writer.WriteLine("foreach( var i in results ) {");
var pkTupleCreationArgs = tableColumns.KeyColumns.Select(i => "i." + EwlStatics.GetCSharpIdentifier(i.PascalCasedNameExceptForOracle));
var pkTuple = "System.Tuple.Create( " + StringTools.ConcatenateWithDelimiter(", ", pkTupleCreationArgs.ToArray()) + " )";
writer.WriteLine("cache.RowsByPk[ " + pkTuple + " ] = i;");
if (excludesPreviousRevisions)
{
writer.WriteLine("cache.LatestRevisionRowsByPk[ " + pkTuple + " ] = i;");
}
writer.WriteLine("}");
writer.WriteLine("return results;");
}
public BillDao()
{
con = DBConnection.getConnection();
}
private static string getPkAndVersionTupleTypeArguments(DBConnection cn, TableColumns tableColumns)
{
return("{0}, {1}".FormatWith(
getPkTupleTypeArguments(tableColumns),
cn.DatabaseInfo is OracleInfo ? oracleRowVersionDataType : tableColumns.RowVersionColumn.DataTypeName));
}
