static void PopulateTerms(List <AyurvedicDictionaryTerm> terms)
{
// In this sample, we use a local database (MS Access) for demo purposes, because
// it is easy to deploy.
// You can use the Entity Framework or other ORM (Object-Relational Mapping) technology
// to retrieve all items (Terms) from a data table.
AccessDataSource ds = new AccessDataSource();
ds.DataFile = NiaMdbFilePath;
ds.SelectCommand = "SELECT * FROM [Terms] ORDER BY [DEVANAGARI]";
IEnumerable data = ds.Select(new DataSourceSelectArguments());
if (data is DataView)
{
DataView dataView = data as DataView;
for (int i = 0; i < dataView.Count; i++)
{
AyurvedicDictionaryTerm item = new AyurvedicDictionaryTerm();
item.Id = (int)dataView[i]["ID"];
item.Devanagari = (string)dataView[i]["DEVANAGARI"];
item.IAST = (string)dataView[i]["IAST"];
item.HarvardKyoto = (string)dataView[i]["HarvardKyoto"];
item.EnglishText = (string)dataView[i]["ENGLISH"];
terms.Add(item);
}
}
}
private bool validataemmailid()
{
string emailid = email_txt.Text.Substring(email_txt.Text.IndexOf("@") + 1);
DataTable myTable = new DataTable();
AccessDataSource AD = new AccessDataSource("~/gensym_accounts.mdb", "SELECT [company] AS [company], [valid] AS [valid]FROM useraccounts ORDER BY [company] DESC");
DataView dv = (DataView)AD.Select(DataSourceSelectArguments.Empty);
myTable = dv.ToTable();
string companyname;
for (int i = 0; i < myTable.Rows.Count; i++)
{
companyname = myTable.Rows[i]["company"].ToString();
if (emailid.Trim().ToUpper().Contains(companyname.Trim().ToUpper().ToString()))
{
if (myTable.Rows[i]["valid"].ToString() == "True")
{
return(true);
}
else
{
HttpCookie str = new HttpCookie("errorstring", "THIS EMAIL ID IS CURRENTLY NOT ALLOWED BY INSTANT TEMP, PLEASE CONTACT US FOR MORE INFORMATION ");
Response.Cookies.Add(str);
return(false);
}
}
}
AD.InsertCommand = "INSERT INTO useraccounts(emailid, [password], company, valid) VALUES ('" + email_txt.Text + "',' ','" + emailid.Trim() + "',0)";
AD.Insert();
return(true);
}
public void BindGuideCourseGridView()
{
int guideCode = -1;
if (Session["LoggedInGuideCode"] != null)
{
guideCode = (int)Session["LoggedInGuideCode"];
}
AccessDataSource DS = new AccessDataSource();
DS.DataFile = "~/App_Data/Matnas_Database.accdb";
DS.SelectCommand = @"SELECT Courses.CourseName, Rooms.RoomName, WorkingDays.Name, WorkingHours.HourName
FROM (((((TimeTable INNER JOIN
Rooms ON TimeTable.RoomCode = Rooms.RoomCode) INNER JOIN
WorkingDays ON TimeTable.[Day] = WorkingDays.DayCode) INNER JOIN
WorkingHours ON TimeTable.[Hour] = WorkingHours.HourCode) INNER JOIN
GuidesInCourses ON TimeTable.GuideCourseCode = GuidesInCourses.GuideCourseCode) INNER JOIN
Courses ON GuidesInCourses.CourseCode = Courses.CourseCode)
WHERE GuidesInCourses.GuideCode = " + guideCode + "";
GridViewGuides.DataSource = DS;
GridViewGuides.DataBind();
if (GridViewGuides.Rows.Count > 0)
{
GridViewGuides.HeaderRow.Cells[0].Text = "Course Name";
GridViewGuides.HeaderRow.Cells[1].Text = "Room name";
GridViewGuides.HeaderRow.Cells[2].Text = "Day";
GridViewGuides.HeaderRow.Cells[3].Text = "Hour";
}
}
protected void login_btn_Click(object sender, EventArgs e)
{
DataTable accountstable = new DataTable();
AccessDataSource AD = new AccessDataSource("~/gensym_accounts.mdb", "SELECT username,password FROM admin_accounts WHERE ((username = ?) AND (password = ?))");
AD.SelectParameters.Add("username", username_txt.Text);
AD.SelectParameters.Add("password", password_txt.Text);
DataView dv = (DataView)AD.Select(DataSourceSelectArguments.Empty);
accountstable = dv.ToTable();
if (accountstable.Rows.Count == 1)
{
content.Visible = true;
login_div.Visible = false;
string sec_cook = FormsAuthentication.HashPasswordForStoringInConfigFile(password_txt.Text, "sha1");
HttpCookie sec = new HttpCookie("val", sec_cook);
sec.Expires = DateTime.Now.AddHours(2);
Response.Cookies.Set(sec);
}
else
{
content.Visible = false;
Response.Cookies["val"].Expires = DateTime.Now.AddHours(-1);
error_lbl.Text = "INVALID USERNAME AND PASSWORD";
}
}
protected void Button1_Click(object sender, EventArgs e)
{
AccessDataSource vd3 = new AccessDataSource();
vd3.DataFile = Server.MapPath(".") + "//App_Data/db1.mdb";
vd3.SelectCommandType = SqlDataSourceCommandType.Text;
vd3.SelectCommand = "Select * from chuyenbay where noidi=@noidi and noiden=@noiden and ngaydi=@ngaydi";
vd3.SelectParameters.Add("noidi", TypeCode.String, DropDownList1.SelectedItem.Value.ToString());
vd3.SelectParameters.Add("noiden", TypeCode.String, DropDownList2.SelectedItem.Value.ToString());
vd3.SelectParameters.Add("ngaydi", TypeCode.String, Calendar1.SelectedDate.DayOfWeek.ToString());
GridView1.DataSource = vd3;
GridView1.DataBind();
if (RadioButtonList1.SelectedValue == "khuhoi")
{
AccessDataSource vd2 = new AccessDataSource();
vd2.DataFile = Server.MapPath(".") + "//App_Data/db1.mdb";
vd2.SelectCommandType = SqlDataSourceCommandType.Text;
vd2.SelectCommand = "Select * from chuyenbay where noidi=@noidi and noiden=@noiden and ngaydi=@ngaydi";
vd2.SelectParameters.Add("noidi", TypeCode.String, DropDownList2.SelectedItem.Value.ToString());
vd2.SelectParameters.Add("noiden", TypeCode.String, DropDownList1.SelectedItem.Value.ToString());
vd2.SelectParameters.Add("ngaydi", TypeCode.String, Calendar2.SelectedDate.DayOfWeek.ToString());
GridView2.DataSource = vd2;
GridView2.DataBind();
}
}
/// <summary>
/// Initializes a new instance of the <see cref="AccessTransactionalDataSource"/> class.
/// </summary>
/// <param name="dataSource">The data source.</param>
/// <param name="isolationLevel">The isolation level.</param>
/// <param name="forwardEvents">if set to <c>true</c> [forward events].</param>
public AccessTransactionalDataSource(AccessDataSource dataSource, IsolationLevel?isolationLevel, bool forwardEvents) : base(new AccessDataSourceSettings() { DefaultCommandTimeout = dataSource.DefaultCommandTimeout, StrictMode = dataSource.StrictMode, SuppressGlobalEvents = dataSource.SuppressGlobalEvents || forwardEvents })
{
if (dataSource == null)
{
throw new ArgumentNullException(nameof(dataSource), $"{nameof(dataSource)} is null.");
}
Name = dataSource.Name;
m_BaseDataSource = dataSource;
m_Connection = dataSource.CreateConnection();
if (isolationLevel == null)
{
m_Transaction = m_Connection.BeginTransaction();
}
else
{
m_Transaction = m_Connection.BeginTransaction(isolationLevel.Value);
}
if (forwardEvents)
{
ExecutionStarted += (sender, e) => dataSource.OnExecutionStarted(e);
ExecutionFinished += (sender, e) => dataSource.OnExecutionFinished(e);
ExecutionError += (sender, e) => dataSource.OnExecutionError(e);
ExecutionCanceled += (sender, e) => dataSource.OnExecutionCanceled(e);
}
AuditRules = dataSource.AuditRules;
UserValue = dataSource.UserValue;
}
public static void SaveDocument(DocObj doc)
{
using (AccessDataSource dataSource = new AccessDataSource("~/App_Data/Reader.mdb", "")) {
dataSource.UpdateCommand = String.Format(@"
UPDATE
[Documents]
SET
[Documents].[Author] = @Author,
[Documents].[Title] = @Title,
[Documents].[Chapter] = @Chapter,
[Documents].[Body] = @Body,
[Documents].[Book] = @Book,
[Documents].[_Year] = @_Year
WHERE [Documents].[Id] = {{guid {0}}}
", doc.Id.ToString("B"));
dataSource.UpdateParameters.Add("Author", DbType.String, doc.Author);
dataSource.UpdateParameters.Add("Title", DbType.String, doc.Title);
dataSource.UpdateParameters.Add("Chapter", DbType.String, doc.Chapter);
dataSource.UpdateParameters.Add("Body", DbType.String, doc.Content);
dataSource.UpdateParameters.Add("Book", DbType.String, doc.Book);
dataSource.UpdateParameters.Add("_Year", DbType.String, doc.Year);
dataSource.Update();
}
}
protected void LinkButton5_Click(object sender, EventArgs e)
{
CheckBox chkbox = new CheckBox();
AccessDataSource ads = new AccessDataSource();
ads.DataFile = "~/APP_Data/mystore.mdb";
for (int i = 0; i < GridView1.Rows.Count; i++)
{
chkbox = (CheckBox)GridView1.Rows[i].FindControl("CheckBox1");
if (chkbox.Checked)
{
ads.InsertCommand = "insert into temp(cartCustomer,ProductID,ProductName,UnitPrice,Quantity) values(?,?,?,?,?)";
//string cn = Session["cartName"].ToString();
//string pid = GridView1.Rows[i].Cells[1].Text;
//string pn = GridView1.Rows[i].Cells[2].Text;
//string up =((Label)GridView1.Rows[i].FindControl("unitPrice")).Text;
ads.InsertParameters.Clear();
ads.InsertParameters.Add("cartCustomer", Session["cartName"].ToString());
ads.InsertParameters.Add("ProductID", GridView1.Rows[i].Cells[1].Text);
ads.InsertParameters.Add("ProductName", GridView1.Rows[i].Cells[2].Text);
ads.InsertParameters.Add("UnitPrice", ((Label)GridView1.Rows[i].FindControl("Label2")).Text);
ads.InsertParameters.Add("Quantity", GridView1.Rows[i].Cells[4].Text);
ads.Insert();
}
}
ads.Dispose();
Response.Redirect("finishOrd.aspx");
}
public void SelectFromAccessDataSourceControlSearch()
{
SelectFromAccessDataSourceControl();
Grid grid = new Grid();
SetupGrid(grid);
AccessDataSource ds = new AccessDataSource();
ds.SelectCommand = "select * from Employees";
ds.ID = "test1";
ds.DataFile = Path + "\\App_Data\\Nwind.mdb";
Testpage.Controls.Add(ds);
grid.DataSourceId = ds.ID;
grid.Search = "ol -olav";
StringBuilder sb = new StringBuilder();
StringWriter sw = new StringWriter(sb);
HtmlTextWriter gridwriter = new HtmlTextWriter(sw);
grid.RenderControl(gridwriter);
Assert.Less(grid.MasterTable.Rows.Count, employees);
}
static void Main(string[] args)
{
var settings = Settings.Default;
var ds = new AccessDataSource(settings.DatabaseConnectionString);
ds.TestConnection();
//Connection strings:
//https://www.connectionstrings.com/access/
//If you see The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine
//https://www.connectionstrings.com/the-microsoft-ace-oledb-12-0-provider-is-not-registered-on-the-local-machine/
//This didn't work for me. I can only open MDB files, not accdb files.
//Fortunately it is easy to change the type using Save As in Access.
var filter = new { EmailSent = false }; //This could also be a SQL WHERE string
var newRows = ds.From <Table1>(filter).ToCollection().Execute();
if (newRows.Count > 0)
{
using (var emailClient = new SmtpClient())
{
emailClient.Connect(settings.SmtpServer, settings.SmtpPort, SecureSocketOptions.Auto);
//Remove any OAuth functionality as we won't be using it.
emailClient.AuthenticationMechanisms.Remove("XOAUTH2");
emailClient.Authenticate(settings.SmtpUsername, settings.SmtpPassword);
foreach (var row in newRows)
{
//Create and send the message
var message = new MimeMessage();
message.To.Add(new MailboxAddress(settings.ToAddress));
message.From.Add(new MailboxAddress(settings.FromAddress));
message.Subject = "This is a test for record " + row.Id;
//We will say we are sending HTML. But there are options for plaintext etc.
message.Body = new TextPart(TextFormat.Html)
{
Text = "Hello " + row.Name
};
emailClient.Send(message);
Console.WriteLine("Send email for " + row.Id);
//Update the database
row.EmailSent = true;
ds.Update(row).Execute();
}
emailClient.Disconnect(true);
}
}
else
{
Console.WriteLine("No new rows");
}
}
/// <summary>
/// 单DML语句操作
/// </summary>
/// <param name="id">SQL语句ID编号</param>
/// <param name="obj">输入输出对象</param>
/// <returns></returns>
public string execDml(string id, Object obj)
{
resultSql = "";
if (id == "")
{
throw new Exception("参数不全");
}
if (obj == null)
{
throw new Exception("参数不全");
}
daoStruct = parseDao.ObtainConfig(id);
if (daoStruct.DbType.Length <= 0 || daoStruct.ConStr.Length <= 0 || daoStruct.SqlStr.Length <= 0)
{
throw new Exception("配置参数不全");
}
string sql = "";
sql = setSql(obj, daoStruct.SqlStr);
resultSql = sql;
//记录SQL
if (daoStruct.IsLog)
{
WriteLogin.writeDBLog(daoStruct.Desc, resultSql);
}
if (sql.Length <= 0)
{
throw new Exception("构造SQL语句出错");
}
IDataSource dataSource = null;
switch (daoStruct.DbType)
{
case "oracle":
dataSource = new OracleDataSource(daoStruct);
break;
case "mysql":
dataSource = new MySqlDataSource(daoStruct);
break;
case "sql":
dataSource = new SqlDataSource(daoStruct);
break;
case "access":
dataSource = new AccessDataSource(daoStruct);
break;
case "sqllite":
dataSource = new SqlLiteDataSource(daoStruct);
break;
}
if (dataSource != null)
{
dataSource.SingleExecute(sql);
}
return("");
}
/// <summary>
/// Prepare DML
/// </summary>
/// <param name="ids">SQL语句ID编号</param>
/// <param name="objs">输入对象</param>
/// <returns></returns>
public string execPrepare(string id, Object obj)
{
try
{
resultSql = "";
if (id == null)
{
throw new Exception("参数不全");
}
if (obj == null)
{
throw new Exception("参数不全");
}
daoStruct = parseDao.ObtainConfig(id);
if (daoStruct.DbType.Length <= 0 || daoStruct.ConStr.Length <= 0 || daoStruct.SqlStr.Length <= 0)
{
throw new Exception("配置参数不全");
}
string sql = daoStruct.SqlStr;
resultSql = sql;
if (daoStruct.IsLog)
{
WriteLogin.writeDBLog(daoStruct.Desc, sql);
}
List <DTOClass> dtolist = setDto(obj);
if (sql.Length <= 0)
{
throw new Exception("构造SQL语句出错");
}
IDataSource dataSource = null;
switch (daoStruct.DbType)
{
case "oracle":
dataSource = new OracleDataSource(daoStruct);
break;
case "mysql":
dataSource = new MySqlDataSource(daoStruct);
break;
case "sql":
dataSource = new SqlDataSource(daoStruct);
break;
case "access":
dataSource = new AccessDataSource(daoStruct);
break;
case "sqllite":
dataSource = new SqlLiteDataSource(daoStruct);
break;
}
dataSource.PrepareExcute(sql, dtolist);
}
catch (Exception ex)
{
throw new Exception(ex.Message, ex);
}
return("");
}
protected override void OnLoad(EventArgs e) {
base.OnLoad(e);
// Initializes a data source.
ds = new AccessDataSource("~/nwind.mdb", "SELECT [CategoryName]," +
"[ProductName], [ProductSales], [ShippedDate] FROM [ProductReports]");
// Initializes ASPxPivotGrid.
ASPxPivotGrid1 = new ASPxPivotGrid();
// Binds ASPxPivotGrid to the data source.
ASPxPivotGrid1.DataSource = ds;
// Places the Pivot Grid onto a page.
form1.Controls.Add(ASPxPivotGrid1);
if (ASPxPivotGrid1.Fields.Count != 0)
return;
// Creates pivot grid fields for all data source fields.
ASPxPivotGrid1.RetrieveFields();
// Locates the pivot grid fields in appropriate areas.
ASPxPivotGrid1.Fields["CategoryName"].Area = PivotArea.RowArea;
ASPxPivotGrid1.Fields["ProductName"].Area = PivotArea.RowArea;
ASPxPivotGrid1.Fields["ShippedDate"].Area = PivotArea.ColumnArea;
ASPxPivotGrid1.Fields["ProductSales"].Area = PivotArea.DataArea;
ASPxPivotGrid1.Fields["ShippedDate"].GroupInterval = PivotGroupInterval.DateYear;
}
public void ProvideRowInsertion(ASPxScheduler control, AccessDataSource dataSource)
{
dataSource.Inserted += new SqlDataSourceStatusEventHandler(AppointmentsDataSource_Inserted);
control.AppointmentRowInserting += new ASPxSchedulerDataInsertingEventHandler(ControlOnAppointmentRowInserting);
control.AppointmentRowInserted += new ASPxSchedulerDataInsertedEventHandler(ControlOnAppointmentRowInserted);
control.AppointmentsInserted += new PersistentObjectsEventHandler(ControlOnAppointmentsInserted);
}
protected void dsProducts_Init(object sender, EventArgs e)
{
AccessDataSource dataSource = sender as AccessDataSource;
GridViewDetailRowTemplateContainer container = dataSource.NamingContainer as GridViewDetailRowTemplateContainer;
dataSource.SelectParameters["CategoryID"].DefaultValue = container.KeyValue.ToString();
}
public static DocObj GetDocument(Guid id)
{
using (AccessDataSource dataSource = new AccessDataSource("~/App_Data/Reader.mdb", "")) {
dataSource.SelectCommand = String.Format(@"
SELECT *
FROM [Documents]
WHERE [Documents].[Id] = {{guid {0}}}", id.ToString("B"));
dataSource.SelectParameters.Add("Id", DbType.Guid, id.ToString());
DataView view = (DataView)dataSource.Select(DataSourceSelectArguments.Empty);
if (view.Count > 0)
{
return(new DocObj()
{
Id = (Guid)(view.Table.Rows[0]["Id"]),
Author = Convert.ToString(view.Table.Rows[0]["Author"]),
Book = Convert.ToString(view.Table.Rows[0]["Book"]),
Content = Convert.ToString(view.Table.Rows[0]["Body"]),
Title = Convert.ToString(view.Table.Rows[0]["Title"]),
Chapter = Convert.ToString(view.Table.Rows[0]["Chapter"]),
Year = Convert.ToString(view.Table.Rows[0]["_Year"]),
});
}
}
return(null);
}
/// <summary>
/// Initializes a new instance of the <see cref="AccessTransactionalDataSource" /> class.
/// </summary>
/// <param name="dataSource">The data source.</param>
/// <param name="forwardEvents">if set to <c>true</c> [forward events].</param>
/// <param name="connection">The connection.</param>
/// <param name="transaction">The transaction.</param>
/// <exception cref="System.ArgumentNullException">
/// </exception>
internal AccessTransactionalDataSource(AccessDataSource dataSource, bool forwardEvents, OleDbConnection connection, OleDbTransaction transaction) : base(new AccessDataSourceSettings() { DefaultCommandTimeout = dataSource.DefaultCommandTimeout, StrictMode = dataSource.StrictMode, SuppressGlobalEvents = dataSource.SuppressGlobalEvents || forwardEvents })
{
if (dataSource == null)
{
throw new ArgumentNullException(nameof(dataSource), $"{nameof(dataSource)} is null.");
}
if (connection == null)
{
throw new ArgumentNullException(nameof(connection), $"{nameof(connection)} is null.");
}
if (transaction == null)
{
throw new ArgumentNullException(nameof(transaction), $"{nameof(transaction)} is null.");
}
Name = dataSource.Name;
m_BaseDataSource = dataSource;
m_Connection = connection;
m_Transaction = transaction;
if (forwardEvents)
{
ExecutionStarted += (sender, e) => dataSource.OnExecutionStarted(e);
ExecutionFinished += (sender, e) => dataSource.OnExecutionFinished(e);
ExecutionError += (sender, e) => dataSource.OnExecutionError(e);
ExecutionCanceled += (sender, e) => dataSource.OnExecutionCanceled(e);
}
AuditRules = dataSource.AuditRules;
UserValue = dataSource.UserValue;
}
void cmbChild_Callback(object sender, DevExpress.Web.ASPxClasses.CallbackEventArgsBase e)
{
ASPxComboBox cmbChild = (ASPxComboBox)sender;
AccessDataSource cmbChildAccessDataSource = (AccessDataSource)cmbChild.NamingContainer.FindControl("asdChild");
cmbChildAccessDataSource.SelectParameters[0].DefaultValue = e.Parameter;
cmbChild.DataBindItems();
}
public AccessDataSourceConnectionChooserPanel(AccessDataSourceDesigner accessDataSourceDesigner, AccessDataSource accessDataSource) : base(accessDataSourceDesigner)
{
this._accessDataSource = accessDataSource;
this._accessDataSourceDesigner = accessDataSourceDesigner;
this.InitializeComponent();
this.InitializeUI();
this.DataFile = this._accessDataSource.DataFile;
}
private void InitializeDataSuorce()
{
string path = Server.MapPath("~/App_Data/NorthWind.mdb");
const string command = "SELECT * FROM [Products]";
ads = new AccessDataSource(path, command);
ads.Selecting += ads_Selecting;
}
private void Insert(OrderedDictionary newValues, AccessDataSource datasource)
{
foreach (var item in newValues.Keys)
{
datasource.InsertParameters[(string)item].DefaultValue = Convert.ToString(newValues[item]);
}
datasource.Insert();
}
protected void DetailsView1_ItemInserted(object sender, DetailsViewInsertedEventArgs e)
{
AccessDataSource ads = new AccessDataSource();
ads.DataFile = "~/date/blog_Data.mdb";
ads.SelectCommand = "SELECT * FROM blogCategory ";
DataView dv = (DataView)ads.Select(DataSourceSelectArguments.Empty);
}
private static int GetCategoryId()
{
AccessDataSource ds = new AccessDataSource();
ds.SelectCommand = "SELECT TOP 1 CategoryID FROM Categories ORDER BY CategoryID DESC";
ds.ID = "test1";
ds.DataFile = Path + "\\App_Data\\Nwind.mdb";
return((int)((DataView)ds.Select(DataSourceSelectArguments.Empty))[0]["CategoryID"]);
}
private void Update(OrderedDictionary keys, OrderedDictionary newValues, AccessDataSource datasource)
{
foreach (var item in newValues.Keys)
{
datasource.UpdateParameters[(string)item].DefaultValue = Convert.ToString(newValues[item]);
}
datasource.UpdateParameters[nwd2.UpdateParameters.Count - 1].DefaultValue = Convert.ToString(keys[0]);
datasource.Update();
}
public static IEnumerable GetAllEmployees()
{
AccessDataSource ads = new AccessDataSource();
ads.DataSourceMode = SqlDataSourceMode.DataReader;
ads.DataFile = "~//App_Data//Northwind.mdb";
ads.SelectCommand = "SELECT EmployeeID,FirstName,LastName FROM Employees";
return(ads.Select(DataSourceSelectArguments.Empty));
}
private void PopualData()
{
using (AccessDataSource dc = new AccessDataSource())
{
var v = dc.NameDatas.OrderBy(a => a.Adress).ThenBy(a => a.Bill).ThenBy(a => Date).ThenBy(a => Branch).ThenBy(a => agent).ToList();
gvData.DataSoure = v;
gvData.DataBind();
}
}
protected void Page_Load(object sender, EventArgs e)
{
AccessDataSource vd3 = new AccessDataSource();
vd3.DataFile = Server.MapPath(".") + "//App_Data/db1.mdb";
vd3.SelectCommandType = SqlDataSourceCommandType.Text;
vd3.SelectCommand = "Select * from chuyenbay";
GridView1.DataSource = vd3;
GridView1.DataBind();
}
public AccessDataSource AttachSoftDeleteRulesWithUser(AccessDataSource source)
{
var currentUser1 = source.From(EmployeeTableName).WithLimits(1).ToObject <Employee>().Execute();
return(source.WithRules(
new SoftDeleteRule("DeletedFlag", true, OperationTypes.SelectOrDelete),
new UserDataRule("DeletedByKey", "EmployeeKey", OperationTypes.Delete),
new DateTimeRule("DeletedDate", DateTimeKind.Local, OperationTypes.Delete)
).WithUser(currentUser1));
}
public AccessDataSource AttachRules(AccessDataSource source)
{
return(source.WithRules(
new DateTimeRule("CreatedDate", DateTimeKind.Local, OperationTypes.Insert),
new DateTimeRule("UpdatedDate", DateTimeKind.Local, OperationTypes.InsertOrUpdate),
new UserDataRule("CreatedByKey", "EmployeeKey", OperationTypes.Insert),
new UserDataRule("UpdatedByKey", "EmployeeKey", OperationTypes.InsertOrUpdate),
new ValidateWithValidatable(OperationTypes.InsertOrUpdate)
));
}
protected void DataListDataBind()
{
AccessDataSource ads = new AccessDataSource();
ads.DataFile = "~/App_Data/mystore.mdb";
//Sql_StringChar sql_String = new Sql_StringChar();//动态数据源
//sql_String.ConnectionString = sql_String.sql_char;//连接字符串
GetCa_id();
ads.SelectCommand = "SELECT * FROM [Product] where ca_id=" + ca_id + " ";
DataView dv = (DataView)ads.Select(DataSourceSelectArguments.Empty);
PagedDataSource objPage = new PagedDataSource();
objPage.DataSource = dv;
objPage.AllowPaging = true;
objPage.PageSize = 3;
int TolPage;
TolPage = objPage.PageCount;
int CurPage;
if (Request.QueryString["Page"] != null)
{
CurPage = Convert.ToInt32(Request.QueryString["Page"]);
}
else
{
CurPage = 1;
}
objPage.CurrentPageIndex = CurPage - 1;
//pagenum.Text = CurPage.ToString();
//pagecount.Text = objPage.PageCount + "";
lnkFirst.NavigateUrl = Request.CurrentExecutionFilePath + "?Page=1" + "&PageSize=" + Convert.ToString(objPage.PageSize);
lnkLast.NavigateUrl = Request.CurrentExecutionFilePath + "?Page=" + TolPage.ToString() + "&PageSize=" + Convert.ToString(objPage.PageSize);
if (!objPage.IsFirstPage)
{
lnkPrev.NavigateUrl = Request.CurrentExecutionFilePath + "?Page=" + Convert.ToString(CurPage - 1) + "&PageSize=" + Convert.ToString(objPage.PageSize);
}
else
{
lnkPrev.Visible = false;
lnkFirst.Visible = false;
}
if (!objPage.IsLastPage)
{
lnkNext.NavigateUrl = Request.CurrentExecutionFilePath + "?Page=" + Convert.ToString(CurPage + 1) + "&PageSize=" + Convert.ToString(objPage.PageSize);
}
else
{
lnkNext.Visible = false;
lnkLast.Visible = false;
}
DataList1.DataSource = objPage;
DataList1.DataBind();
}
protected void LoginButton_Click(object sender, EventArgs e)
{
AccessDataSource ads = new AccessDataSource();
ads.DataFile = "~/App_Data/Xalsa.mdb";
if (this.Username.Text.Length == 0 | this.Password.Text.Length == 0)
{
this.Label1.ForeColor = System.Drawing.Color.Red;
this.Label1.Text = "Login failed!";
this.Username.Text = "";
this.Password.Text = "";
return;
}
ads.SelectParameters.Add("Username", this.Username.Text);
ads.SelectParameters.Add("Password", this.Password.Text);
ads.SelectCommand = "SELECT * FROM [Login] WHERE [Username] = @Username AND [Password] = @Password";
DataView dv = (DataView)ads.Select(DataSourceSelectArguments.Empty);
if (dv.Count == 0)
{
this.Label1.ForeColor = System.Drawing.Color.Red;
this.Label1.Text = "Account details does not exist. Please register.";
this.Username.Text = "";
this.Password.Text = "";
return;
}
this.Session["Username"] = dv[0].Row["Username"].ToString();
this.Session["UserType"] = dv[0].Row["UserType"].ToString();
if (this.Session["UserType"].ToString().Equals("member"))
Response.Redirect("MembersHome.aspx");
else if (this.Session["UserType"].ToString().Equals("admin"))
Response.Redirect("AdminHome.aspx");
}
// Constructors
public AccessDataSourceView(AccessDataSource owner, string name, System.Web.HttpContext context) {}
public static AccessDataSource GetSqlCommandString(DBTablesNames TableName)
{
AccessDataSource ADS = new AccessDataSource();
DataTable dt = new DataTable();
ADS.DataFile = AATSWEBPath;
switch (TableName)
{
case DBTablesNames.TBLTrainee:
ADS.SelectCommand = "SELECT TraineeID, TraineeName, NameInEnglish, NationalityId, Mobile, tel, Email, City, Address, mony, accname, countryId, TimeIn FROM TBLTrainee";
ADS.InsertCommand = @"INSERT INTO TBLTrainee (TraineeID, TraineeName, NameInEnglish, NationalityId, Mobile, tel, Email, City, Address, mony, accname, countryId, TimeIn)
VALUES (@TraineeID, @TraineeName, @NameInEnglish, @NationalityId, @Mobile, @tel, @Email, @City, @Address, @mony, @accname, @countryId, NOW())";
ADS.UpdateCommand = @"UPDATE TBLTrainee SET TraineeName = @TraineeName, NameInEnglish = @NameInEnglish, NationalityId = @NationalityId, Mobile = @Mobile,
tel = @tel, Email = @Email, City = @City, Address = @Address, mony = @mony, accname = @accname, countryId = @countryId, TimeIn = NOW()
Where TraineeID = @TraineeID";
ADS.DeleteCommand = @"DELETE FROM TBLTrainee WHERE (TraineeID = @TraineeID)";
//string xxx = ADS.InsertParameters.Count.ToString();
//dt = LoadTableAATSWEB(ADS.SelectCommand);
break;
case DBTablesNames.Cdcountry:
ADS.SelectCommand = "Select countryId, country From Cdcountry";
ADS.InsertCommand = "";
ADS.UpdateCommand = "";
ADS.DeleteCommand = "";
break;
case DBTablesNames.CdNationality:
ADS.SelectCommand = "Select NationalityId, Nationality From CdNationality";
ADS.InsertCommand = "";
ADS.UpdateCommand = "";
ADS.DeleteCommand = "";
break;
default:
break;
}
OleDbConnection con = ConnectionAATSWEB;
con.Open();
dt = con.GetOleDbSchemaTable(OleDbSchemaGuid.Columns, new object[] { null, null, TableName.ToString(), null });
foreach (DataRow row in dt.Rows)
{
//(int)row["DATA_TYPE"]
int datatype = Convert.ToInt16(row["DATA_TYPE"]);
ADS.InsertParameters.Add(row["COLUMN_NAME"].ToString(), ColumnType(datatype), "");
ADS.UpdateParameters.Add(row["COLUMN_NAME"].ToString(), ColumnType(datatype), "");
ADS.DeleteParameters.Add(row["COLUMN_NAME"].ToString(), ColumnType(datatype), "");
}
return ADS;
}
