public override object ConvertTo(ITypeDescriptorContext context, CultureInfo culture, object value, Type destinationType)
{
if (typeof(string).Equals(destinationType))
{
DbParameterListExt list = value as DbParameterListExt;
if (list != null)
{
StringBuilder sb = new StringBuilder();
for (int i = 0; i < list.Count; i++)
{
if (i > 0)
{
sb.Append("|");
}
sb.Append(list[i].Name);
sb.Append(";");
sb.Append(list[i].Type);
sb.Append(";");
sb.Append(list[i].DataSize);
sb.Append(";");
sb.Append(list[i].Direction);
if (list[i].Value != null)
{
sb.Append(";");
sb.Append(list[i].Value);
}
}
return(sb.ToString());
}
return(string.Empty);
}
return(base.ConvertTo(context, culture, value, destinationType));
}
private void btOK_Click(object sender, EventArgs e)
{
Results = new DbParameterListExt();
for (int i = 0; i < listBox1.Items.Count; i++)
{
Results.Add(listBox1.Items[i] as DbCommandParam);
}
this.DialogResult = DialogResult.OK;
}
public void LoadData(DbParameterListExt list)
{
Results = list;
if (list != null)
{
for (int i = 0; i < list.Count; i++)
{
listBox1.Items.Add(list[i]);
list[i].AfterNameChange += new EventHandler(DialogCommandParameters_AfterNameChange);
}
}
else
{
Results = new DbParameterListExt();
}
}
public override object EditValue(ITypeDescriptorContext context, IServiceProvider provider, object value)
{
if (context != null && context.Instance != null && provider != null)
{
IWindowsFormsEditorService edSvc = (IWindowsFormsEditorService)provider.GetService(typeof(IWindowsFormsEditorService));
if (edSvc != null)
{
DbParameterListExt list = value as DbParameterListExt;
DialogCommandParameters dlg = new DialogCommandParameters();
dlg.LoadData(list);
if (edSvc.ShowDialog(dlg) == System.Windows.Forms.DialogResult.OK)
{
value = dlg.Results;
}
}
}
return(value);
}
private void btNew_Click(object sender, EventArgs e)
{
int n = 1;
string nm = "@p1";
while (true)
{
bool bFound = false;
for (int i = 0; i < listBox1.Items.Count; i++)
{
DbCommandParam p = listBox1.Items[i] as DbCommandParam;
if (p != null)
{
if (string.Compare(nm, p.Name, StringComparison.OrdinalIgnoreCase) == 0)
{
bFound = true;
break;
}
}
}
if (bFound)
{
n++;
nm = string.Format(CultureInfo.InvariantCulture, "@p{0}", n);
}
else
{
break;
}
}
DbCommandParam pNew = new DbCommandParam(new EPField());
pNew.Name = nm;
if (Results == null)
{
Results = new DbParameterListExt();
}
Results.Add(pNew);
pNew.AfterNameChange += DialogCommandParameters_AfterNameChange;
n = listBox1.Items.Add(pNew);
listBox1.SelectedIndex = n;
}
private void InitializeComponent()
{
LimnorDatabase.DbParameterListExt dbparameterlistext1 = new LimnorDatabase.DbParameterListExt();
System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(CreateResetCode));
this.LabeLHEAD = new System.Windows.Forms.Label();
this.LabelLOGIN = new System.Windows.Forms.Label();
this.TextBoxLOGIN = new System.Windows.Forms.TextBox();
this.ButtonCREATE = new System.Windows.Forms.Button();
this.components = new System.ComponentModel.Container();
this.WebLoginManager1 = new LimnorDatabase.WebLoginManager(this.components);
this.MailSender1 = new Limnor.Net.MailSender();
this.EasyDataSet1 = new LimnorDatabase.EasyDataSet();
((System.ComponentModel.ISupportInitialize)(EasyDataSet1)).BeginInit();
this.SuspendLayout();
//
// LabeLHEAD
//
this.LabeLHEAD.Font = new System.Drawing.Font("Algerian", 12F, ((System.Drawing.FontStyle)((System.Drawing.FontStyle.Bold | System.Drawing.FontStyle.Italic))));
this.LabeLHEAD.ForeColor = System.Drawing.Color.Navy;
this.LabeLHEAD.Location = new System.Drawing.Point(73, 65);
this.LabeLHEAD.Name = "LabeLHEAD";
this.LabeLHEAD.Size = new System.Drawing.Size(283, 23);
this.LabeLHEAD.TabIndex = 0;
this.LabeLHEAD.Text = "CREATE PASSWORD RESET CODE";
//
// LabelLOGIN
//
this.LabelLOGIN.Font = new System.Drawing.Font("Microsoft Sans Serif", 11.25F, ((System.Drawing.FontStyle)((System.Drawing.FontStyle.Bold | System.Drawing.FontStyle.Italic))));
this.LabelLOGIN.ForeColor = System.Drawing.Color.Navy;
this.LabelLOGIN.Location = new System.Drawing.Point(26, 141);
this.LabelLOGIN.Name = "LabelLOGIN";
this.LabelLOGIN.Size = new System.Drawing.Size(114, 23);
this.LabelLOGIN.TabIndex = 1;
this.LabelLOGIN.Text = "LOGIN NAME";
//
// TextBoxLOGIN
//
this.TextBoxLOGIN.Location = new System.Drawing.Point(160, 144);
this.TextBoxLOGIN.Name = "TextBoxLOGIN";
this.TextBoxLOGIN.Size = new System.Drawing.Size(238, 20);
this.TextBoxLOGIN.TabIndex = 2;
//
// ButtonCREATE
//
this.ButtonCREATE.Font = new System.Drawing.Font("Microsoft Sans Serif", 11.25F, System.Drawing.FontStyle.Bold);
this.ButtonCREATE.Location = new System.Drawing.Point(160, 192);
this.ButtonCREATE.Name = "ButtonCREATE";
this.ButtonCREATE.Size = new System.Drawing.Size(107, 28);
this.ButtonCREATE.TabIndex = 3;
this.ButtonCREATE.Text = "CREATE";
this.ButtonCREATE.UseVisualStyleBackColor = true;
this.ButtonCREATE.Click += new System.EventHandler(this.Click_618b62c7);
//
// WebLoginManager1
//
this.WebLoginManager1.ComponentName = "WebLoginManager1";
this.WebLoginManager1.ConnectionID = new System.Guid("1a3e6d80-9bb0-4583-8429-2967b832ae28");
this.WebLoginManager1.DefaultConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\\Users\\rishabh\\OneDrive\\Documents\\" +
"SOFTWAREMERCHANT.mdb;Mode=ReadWrite;";
this.WebLoginManager1.DefaultConnectionType = typeof(System.Data.OleDb.OleDbConnection);
this.WebLoginManager1.FailedMessageLableId = null;
this.WebLoginManager1.ID = new System.Guid("e799cdf3-976e-407d-9d3a-3010d7f826a3");
this.WebLoginManager1.InactivityMinutes = 0;
this.WebLoginManager1.LabelToShowLoginFailedMessage = null;
this.WebLoginManager1.LoginFailedMessage = null;
this.WebLoginManager1.LoginPermissionFailedMessage = null;
this.WebLoginManager1.PasswordHash = WindowsUtility.EnumPasswordHash.SHA256;
this.WebLoginManager1.UserAccountIdFieldName = "USERiD";
this.WebLoginManager1.UserAccountLevelFieldName = "USER LEVEL";
this.WebLoginManager1.UserAccountLoginFieldName = "LOGIN NAME";
this.WebLoginManager1.UserAccountPasswordFieldName = "PASSWORD";
this.WebLoginManager1.UserAccountResetCodeFieldName = "RESET CODE";
this.WebLoginManager1.UserAccountResetCodeTimeFieldName = "RESET CODE EXPIRE";
this.WebLoginManager1.UserAccountSaltFieldName = "SALT";
this.WebLoginManager1.UserAccountTableName = "GLASS";
//
// EasyDataSet1
//
this.EasyDataSet1.ConnectionID = new System.Guid("1a3e6d80-9bb0-4583-8429-2967b832ae28");
this.EasyDataSet1.DataSetName = "Data_fa3c1d71-7a61-4a1a-9c36-59a8e5585c91";
this.EasyDataSet1.DefaultConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\\Users\\rishabh\\OneDrive\\Documents\\" +
"SOFTWAREMERCHANT.mdb;Mode=ReadWrite;";
this.EasyDataSet1.DefaultConnectionType = typeof(System.Data.OleDb.OleDbConnection);
this.EasyDataSet1.Description = null;
this.EasyDataSet1.DynamicParameters = dbparameterlistext1;
this.EasyDataSet1.Field_DataSize = new int[] {
255
};
this.EasyDataSet1.Field_FieldCaption = new string[] {
null
};
this.EasyDataSet1.Field_FieldText = new string[] {
"[GLASS].[E-MAIL]"
};
this.EasyDataSet1.Field_FromTableName = new string[] {
"GLASS"
};
this.EasyDataSet1.Field_Indexed = new bool[] {
false
};
this.EasyDataSet1.Field_IsIdentity = new bool[] {
false
};
this.EasyDataSet1.Field_Name = new string[] {
"E-MAIL"
};
this.EasyDataSet1.Field_OleDbType = new System.Data.OleDb.OleDbType[] {
System.Data.OleDb.OleDbType.VarWChar
};
this.EasyDataSet1.Field_ReadOnly = new bool[] {
false
};
this.EasyDataSet1.From = "[GLASS]";
this.EasyDataSet1.GroupBy = null;
this.EasyDataSet1.Having = null;
this.EasyDataSet1.IsFieldImage = new bool[] {
false
};
this.EasyDataSet1.Limit = null;
this.EasyDataSet1.Name = "EasyDataSet1";
this.EasyDataSet1.OrderBy = null;
this.EasyDataSet1.Param_Name = new string[] {
"@loginName"
};
this.EasyDataSet1.Param_OleDbType = new System.Data.OleDb.OleDbType[] {
System.Data.OleDb.OleDbType.VarWChar
};
this.EasyDataSet1.Param_Value = new string[] {
"System.String, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c5" +
"61934e089|"
};
this.EasyDataSet1.TableName = "Table2873653136";
this.EasyDataSet1.UpdatableTableName = null;
this.EasyDataSet1.Where = "[GLASS].[LOGIN NAME] = @loginName";
//
// CreateResetCode
//
this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 13F);
this.ClientSize = new System.Drawing.Size(444, 327);
this.Controls.Add(this.LabeLHEAD);
this.Controls.Add(this.LabelLOGIN);
this.Controls.Add(this.TextBoxLOGIN);
this.Controls.Add(this.ButtonCREATE);
this.DrawingLayerList = ((Limnor.Drawing2D.DrawingLayerHeaderList)(resources.GetObject("$this.DrawingLayerList")));
this.Name = "CreateResetCode";
this.Text = "CreateResetCode";
WebLoginManager1.CreateDataTable();
EasyDataSet1.CreateDataTable();
EasyDataSet1.Query();
((System.ComponentModel.ISupportInitialize)(EasyDataSet1)).EndInit();
this.ResumeLayout(false);
this.PerformLayout();
}
private void InitializeComponent()
{
System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(CreateNewUser));
LimnorDatabase.SQLNoneQuery sqlnonequery1 = new LimnorDatabase.SQLNoneQuery();
LimnorDatabase.DbParameterListExt dbparameterlistext1 = new LimnorDatabase.DbParameterListExt();
this.Label1 = new System.Windows.Forms.Label();
this.PictureBox1 = new System.Windows.Forms.PictureBox();
this.LabelLNM = new System.Windows.Forms.Label();
this.LabelSTATE = new System.Windows.Forms.Label();
this.LabelCONTACT = new System.Windows.Forms.Label();
this.LabelLOGIN = new System.Windows.Forms.Label();
this.LabelFNM = new System.Windows.Forms.Label();
this.LabelLEVEL = new System.Windows.Forms.Label();
this.LabelEMAIL = new System.Windows.Forms.Label();
this.TextBoxLNM = new System.Windows.Forms.TextBox();
this.TextBoxSTATE = new System.Windows.Forms.TextBox();
this.TextBoxCONTACT = new System.Windows.Forms.TextBox();
this.TextBoxEMAIL = new System.Windows.Forms.TextBox();
this.TextBoxLOGIN = new System.Windows.Forms.TextBox();
this.TextBoxLEVEL = new System.Windows.Forms.TextBox();
this.TextBoxFNM = new System.Windows.Forms.TextBox();
this.ButtonCREATE = new System.Windows.Forms.Button();
this.LabelMSG = new System.Windows.Forms.Label();
this.components = new System.ComponentModel.Container();
this.EasyUpdator1 = new LimnorDatabase.EasyUpdator(this.components);
this.EasyDataSet1 = new LimnorDatabase.EasyDataSet();
this.WebLoginManager1 = new LimnorDatabase.WebLoginManager(this.components);
this.MailSender1 = new Limnor.Net.MailSender();
((System.ComponentModel.ISupportInitialize)(EasyDataSet1)).BeginInit();
((System.ComponentModel.ISupportInitialize)(PictureBox1)).BeginInit();
this.SuspendLayout();
//
// Label1
//
this.Label1.Font = new System.Drawing.Font("Microsoft Sans Serif", 12F, ((System.Drawing.FontStyle)((System.Drawing.FontStyle.Bold | System.Drawing.FontStyle.Italic))));
this.Label1.ForeColor = System.Drawing.SystemColors.ActiveCaptionText;
this.Label1.Location = new System.Drawing.Point(158, 27);
this.Label1.Name = "Label1";
this.Label1.Size = new System.Drawing.Size(111, 23);
this.Label1.TabIndex = 0;
this.Label1.Text = "NEW USER";
//
// PictureBox1
//
this.PictureBox1.Image = ((System.Drawing.Image)(resources.GetObject("PictureBox1.Image")));
this.PictureBox1.Location = new System.Drawing.Point(175, 53);
this.PictureBox1.Name = "PictureBox1";
this.PictureBox1.Size = new System.Drawing.Size(64, 44);
this.PictureBox1.TabIndex = 1;
this.PictureBox1.TabStop = false;
//
// LabelLNM
//
this.LabelLNM.Font = new System.Drawing.Font("Microsoft Sans Serif", 11.25F, ((System.Drawing.FontStyle)((System.Drawing.FontStyle.Bold | System.Drawing.FontStyle.Italic))));
this.LabelLNM.ForeColor = System.Drawing.Color.Navy;
this.LabelLNM.Location = new System.Drawing.Point(31, 168);
this.LabelLNM.Name = "LabelLNM";
this.LabelLNM.Size = new System.Drawing.Size(121, 23);
this.LabelLNM.TabIndex = 2;
this.LabelLNM.Text = " LAST NAME";
//
// LabelSTATE
//
this.LabelSTATE.Font = new System.Drawing.Font("Microsoft Sans Serif", 11.25F, ((System.Drawing.FontStyle)((System.Drawing.FontStyle.Bold | System.Drawing.FontStyle.Italic))));
this.LabelSTATE.ForeColor = System.Drawing.Color.Navy;
this.LabelSTATE.Location = new System.Drawing.Point(78, 203);
this.LabelSTATE.Name = "LabelSTATE";
this.LabelSTATE.Size = new System.Drawing.Size(74, 23);
this.LabelSTATE.TabIndex = 2;
this.LabelSTATE.Text = " STATE";
//
// LabelCONTACT
//
this.LabelCONTACT.Font = new System.Drawing.Font("Microsoft Sans Serif", 11.25F, ((System.Drawing.FontStyle)((System.Drawing.FontStyle.Bold | System.Drawing.FontStyle.Italic))));
this.LabelCONTACT.ForeColor = System.Drawing.Color.Navy;
this.LabelCONTACT.Location = new System.Drawing.Point(31, 239);
this.LabelCONTACT.Name = "LabelCONTACT";
this.LabelCONTACT.Size = new System.Drawing.Size(121, 23);
this.LabelCONTACT.TabIndex = 2;
this.LabelCONTACT.Text = "CONTACT NO";
//
// LabelLOGIN
//
this.LabelLOGIN.Font = new System.Drawing.Font("Microsoft Sans Serif", 11.25F, ((System.Drawing.FontStyle)((System.Drawing.FontStyle.Bold | System.Drawing.FontStyle.Italic))));
this.LabelLOGIN.ForeColor = System.Drawing.Color.Navy;
this.LabelLOGIN.Location = new System.Drawing.Point(31, 322);
this.LabelLOGIN.Name = "LabelLOGIN";
this.LabelLOGIN.Size = new System.Drawing.Size(121, 23);
this.LabelLOGIN.TabIndex = 2;
this.LabelLOGIN.Text = " LOGIN NAME";
//
// LabelFNM
//
this.LabelFNM.Font = new System.Drawing.Font("Microsoft Sans Serif", 11.25F, ((System.Drawing.FontStyle)((System.Drawing.FontStyle.Bold | System.Drawing.FontStyle.Italic))));
this.LabelFNM.ForeColor = System.Drawing.Color.Navy;
this.LabelFNM.Location = new System.Drawing.Point(31, 131);
this.LabelFNM.Name = "LabelFNM";
this.LabelFNM.Size = new System.Drawing.Size(121, 23);
this.LabelFNM.TabIndex = 2;
this.LabelFNM.Text = " FIRST NAME";
//
// LabelLEVEL
//
this.LabelLEVEL.Font = new System.Drawing.Font("Microsoft Sans Serif", 11.25F, ((System.Drawing.FontStyle)((System.Drawing.FontStyle.Bold | System.Drawing.FontStyle.Italic))));
this.LabelLEVEL.ForeColor = System.Drawing.Color.Navy;
this.LabelLEVEL.Location = new System.Drawing.Point(43, 362);
this.LabelLEVEL.Name = "LabelLEVEL";
this.LabelLEVEL.Size = new System.Drawing.Size(109, 23);
this.LabelLEVEL.TabIndex = 2;
this.LabelLEVEL.Text = "USER LEVEL";
//
// LabelEMAIL
//
this.LabelEMAIL.Font = new System.Drawing.Font("Microsoft Sans Serif", 11.25F, ((System.Drawing.FontStyle)((System.Drawing.FontStyle.Bold | System.Drawing.FontStyle.Italic))));
this.LabelEMAIL.ForeColor = System.Drawing.Color.Navy;
this.LabelEMAIL.Location = new System.Drawing.Point(78, 275);
this.LabelEMAIL.Name = "LabelEMAIL";
this.LabelEMAIL.Size = new System.Drawing.Size(74, 23);
this.LabelEMAIL.TabIndex = 2;
this.LabelEMAIL.Text = " E-MAIL";
//
// TextBoxLNM
//
this.TextBoxLNM.Location = new System.Drawing.Point(248, 169);
this.TextBoxLNM.Name = "TextBoxLNM";
this.TextBoxLNM.Size = new System.Drawing.Size(200, 20);
this.TextBoxLNM.TabIndex = 3;
//
// TextBoxSTATE
//
this.TextBoxSTATE.Location = new System.Drawing.Point(248, 204);
this.TextBoxSTATE.Name = "TextBoxSTATE";
this.TextBoxSTATE.Size = new System.Drawing.Size(200, 20);
this.TextBoxSTATE.TabIndex = 3;
//
// TextBoxCONTACT
//
this.TextBoxCONTACT.Location = new System.Drawing.Point(248, 240);
this.TextBoxCONTACT.Name = "TextBoxCONTACT";
this.TextBoxCONTACT.Size = new System.Drawing.Size(200, 20);
this.TextBoxCONTACT.TabIndex = 3;
//
// TextBoxEMAIL
//
this.TextBoxEMAIL.Location = new System.Drawing.Point(248, 276);
this.TextBoxEMAIL.Name = "TextBoxEMAIL";
this.TextBoxEMAIL.Size = new System.Drawing.Size(200, 20);
this.TextBoxEMAIL.TabIndex = 3;
//
// TextBoxLOGIN
//
this.TextBoxLOGIN.Location = new System.Drawing.Point(248, 323);
this.TextBoxLOGIN.Name = "TextBoxLOGIN";
this.TextBoxLOGIN.Size = new System.Drawing.Size(200, 20);
this.TextBoxLOGIN.TabIndex = 3;
//
// TextBoxLEVEL
//
this.TextBoxLEVEL.Location = new System.Drawing.Point(248, 363);
this.TextBoxLEVEL.Name = "TextBoxLEVEL";
this.TextBoxLEVEL.Size = new System.Drawing.Size(200, 20);
this.TextBoxLEVEL.TabIndex = 3;
//
// TextBoxFNM
//
this.TextBoxFNM.Location = new System.Drawing.Point(248, 132);
this.TextBoxFNM.Name = "TextBoxFNM";
this.TextBoxFNM.Size = new System.Drawing.Size(200, 20);
this.TextBoxFNM.TabIndex = 3;
//
// ButtonCREATE
//
this.ButtonCREATE.Font = new System.Drawing.Font("Microsoft Sans Serif", 9.75F, System.Drawing.FontStyle.Bold);
this.ButtonCREATE.Location = new System.Drawing.Point(248, 401);
this.ButtonCREATE.Name = "ButtonCREATE";
this.ButtonCREATE.Size = new System.Drawing.Size(200, 32);
this.ButtonCREATE.TabIndex = 4;
this.ButtonCREATE.Text = "CREATE";
this.ButtonCREATE.UseVisualStyleBackColor = true;
this.ButtonCREATE.Click += new System.EventHandler(this.Click_cbaeeb88);
//
// LabelMSG
//
this.LabelMSG.Font = new System.Drawing.Font("Microsoft Sans Serif", 9.75F, System.Drawing.FontStyle.Bold);
this.LabelMSG.ForeColor = System.Drawing.Color.Black;
this.LabelMSG.Location = new System.Drawing.Point(304, 436);
this.LabelMSG.Name = "LabelMSG";
this.LabelMSG.Size = new System.Drawing.Size(82, 23);
this.LabelMSG.TabIndex = 5;
this.LabelMSG.Text = "MESSAGE";
//
// EasyUpdator1
//
this.EasyUpdator1.ConnectionID = new System.Guid("1a3e6d80-9bb0-4583-8429-2967b832ae28");
this.EasyUpdator1.DefaultConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\\Users\\rishabh\\OneDrive\\Documents\\" +
"SOFTWAREMERCHANT.mdb;Mode=ReadWrite;";
this.EasyUpdator1.DefaultConnectionType = typeof(System.Data.OleDb.OleDbConnection);
sqlnonequery1.CommandType = LimnorDatabase.enmNonQueryType.Insert;
sqlnonequery1.MultiRow = false;
sqlnonequery1.Param_Name = new string[] {
"@firstname",
"@lastname",
"@state",
"@contact",
"@email",
"@loginname",
"@level"
};
sqlnonequery1.Param_OleDbType = new System.Data.OleDb.OleDbType[] {
System.Data.OleDb.OleDbType.VarWChar,
System.Data.OleDb.OleDbType.VarWChar,
System.Data.OleDb.OleDbType.VarWChar,
System.Data.OleDb.OleDbType.VarWChar,
System.Data.OleDb.OleDbType.VarWChar,
System.Data.OleDb.OleDbType.VarWChar,
System.Data.OleDb.OleDbType.Integer
};
sqlnonequery1.Param_Value = new string[] {
"System.String, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c5" +
"61934e089|",
"System.String, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c5" +
"61934e089|",
"System.String, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c5" +
"61934e089|",
"System.String, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c5" +
"61934e089|",
"System.String, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c5" +
"61934e089|",
"System.String, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c5" +
"61934e089|",
"System.Int32, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c56" +
"1934e089|0"
};
sqlnonequery1.SQL = "INSERT INTO [GLASS] ([FIRST NAME],[LAST NAME],[STATE],[CONTACT NO],[E-MAIL],[LOGI" +
"N NAME],[USER LEVEL]) VALUES (@firstname,@lastname,@state,@contact,@email,@logi" +
"nname,@level)";
sqlnonequery1.TableName = "";
this.EasyUpdator1.ExecutionCommand = sqlnonequery1;
this.EasyUpdator1.LastInsertID = 0;
this.EasyUpdator1.Name = "EasyUpdator1";
//
// EasyDataSet1
//
this.EasyDataSet1.ConnectionID = new System.Guid("1a3e6d80-9bb0-4583-8429-2967b832ae28");
this.EasyDataSet1.DataSetName = "Data_632670bb-cd86-4824-abd7-fddafa4cf860";
this.EasyDataSet1.DefaultConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\\Users\\rishabh\\OneDrive\\Documents\\" +
"SOFTWAREMERCHANT.mdb;Mode=ReadWrite;";
this.EasyDataSet1.DefaultConnectionType = typeof(System.Data.OleDb.OleDbConnection);
this.EasyDataSet1.Description = null;
this.EasyDataSet1.DynamicParameters = dbparameterlistext1;
this.EasyDataSet1.Field_DataSize = new int[] {
4
};
this.EasyDataSet1.Field_FieldCaption = new string[] {
null
};
this.EasyDataSet1.Field_FieldText = new string[] {
"[GLASS].[USERiD]"
};
this.EasyDataSet1.Field_FromTableName = new string[] {
"GLASS"
};
this.EasyDataSet1.Field_Indexed = new bool[] {
true
};
this.EasyDataSet1.Field_IsIdentity = new bool[] {
true
};
this.EasyDataSet1.Field_Name = new string[] {
"USERiD"
};
this.EasyDataSet1.Field_OleDbType = new System.Data.OleDb.OleDbType[] {
System.Data.OleDb.OleDbType.Integer
};
this.EasyDataSet1.Field_ReadOnly = new bool[] {
true
};
this.EasyDataSet1.From = "[GLASS]";
this.EasyDataSet1.GroupBy = null;
this.EasyDataSet1.Having = null;
this.EasyDataSet1.IsFieldImage = new bool[] {
false
};
this.EasyDataSet1.Limit = null;
this.EasyDataSet1.Name = "EasyDataSet1";
this.EasyDataSet1.OrderBy = null;
this.EasyDataSet1.Param_Name = new string[] {
"@loginName"
};
this.EasyDataSet1.Param_OleDbType = new System.Data.OleDb.OleDbType[] {
System.Data.OleDb.OleDbType.VarWChar
};
this.EasyDataSet1.Param_Value = new string[] {
"System.String, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c5" +
"61934e089|"
};
this.EasyDataSet1.TableName = "Table3486311435";
this.EasyDataSet1.UpdatableTableName = "GLASS";
this.EasyDataSet1.Where = "[GLASS].[LOGIN NAME] = @loginName";
//
// WebLoginManager1
//
this.WebLoginManager1.ComponentName = "WebLoginManager1";
this.WebLoginManager1.ConnectionID = new System.Guid("1a3e6d80-9bb0-4583-8429-2967b832ae28");
this.WebLoginManager1.DefaultConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\\Users\\rishabh\\OneDrive\\Documents\\" +
"SOFTWAREMERCHANT.mdb;Mode=ReadWrite;";
this.WebLoginManager1.DefaultConnectionType = typeof(System.Data.OleDb.OleDbConnection);
this.WebLoginManager1.FailedMessageLableId = null;
this.WebLoginManager1.ID = new System.Guid("5f30d976-45da-4402-8cd0-daf9b4f58c1d");
this.WebLoginManager1.InactivityMinutes = 0;
this.WebLoginManager1.LabelToShowLoginFailedMessage = null;
this.WebLoginManager1.LoginFailedMessage = null;
this.WebLoginManager1.LoginPermissionFailedMessage = null;
this.WebLoginManager1.PasswordHash = WindowsUtility.EnumPasswordHash.SHA256;
this.WebLoginManager1.UserAccountIdFieldName = "USERiD";
this.WebLoginManager1.UserAccountLevelFieldName = "USER LEVEL";
this.WebLoginManager1.UserAccountLoginFieldName = "LOGIN NAME";
this.WebLoginManager1.UserAccountPasswordFieldName = "PASSWORD";
this.WebLoginManager1.UserAccountResetCodeFieldName = "RESET CODE";
this.WebLoginManager1.UserAccountResetCodeTimeFieldName = "RESET CODE EXPIRE";
this.WebLoginManager1.UserAccountSaltFieldName = "SALT";
this.WebLoginManager1.UserAccountTableName = "GLASS";
//
// CreateNewUser
//
this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 13F);
this.ClientSize = new System.Drawing.Size(472, 478);
this.Controls.Add(this.Label1);
this.Controls.Add(this.PictureBox1);
this.Controls.Add(this.LabelLNM);
this.Controls.Add(this.LabelSTATE);
this.Controls.Add(this.LabelCONTACT);
this.Controls.Add(this.LabelLOGIN);
this.Controls.Add(this.LabelFNM);
this.Controls.Add(this.LabelLEVEL);
this.Controls.Add(this.LabelEMAIL);
this.Controls.Add(this.TextBoxLNM);
this.Controls.Add(this.TextBoxSTATE);
this.Controls.Add(this.TextBoxCONTACT);
this.Controls.Add(this.TextBoxEMAIL);
this.Controls.Add(this.TextBoxLOGIN);
this.Controls.Add(this.TextBoxLEVEL);
this.Controls.Add(this.TextBoxFNM);
this.Controls.Add(this.ButtonCREATE);
this.Controls.Add(this.LabelMSG);
this.DrawingLayerList = ((Limnor.Drawing2D.DrawingLayerHeaderList)(resources.GetObject("$this.DrawingLayerList")));
this.Name = "CreateNewUser";
this.Text = "CreateNewUser";
EasyDataSet1.CreateDataTable();
EasyDataSet1.Query();
WebLoginManager1.CreateDataTable();
((System.ComponentModel.ISupportInitialize)(EasyDataSet1)).EndInit();
((System.ComponentModel.ISupportInitialize)(PictureBox1)).EndInit();
this.ResumeLayout(false);
this.PerformLayout();
}
private void InitializeComponent()
{
System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(Form1));
LimnorDatabase.DbParameterListExt dbparameterlistext1 = new LimnorDatabase.DbParameterListExt();
LimnorDatabase.SQLNoneQuery sqlnonequery1 = new LimnorDatabase.SQLNoneQuery();
this.Label1 = new System.Windows.Forms.Label();
this.PictureBox1 = new System.Windows.Forms.PictureBox();
this.LabelLNM = new System.Windows.Forms.Label();
this.LabelFNM = new System.Windows.Forms.Label();
this.LabelSTATE = new System.Windows.Forms.Label();
this.LabelCONTACT = new System.Windows.Forms.Label();
this.LabelEMAIL = new System.Windows.Forms.Label();
this.LabelLOGIN = new System.Windows.Forms.Label();
this.LabelPASS = new System.Windows.Forms.Label();
this.TextBoxFNM = new System.Windows.Forms.TextBox();
this.TextBoxLNM = new System.Windows.Forms.TextBox();
this.TextBoxSTATE = new System.Windows.Forms.TextBox();
this.TextBoxCONTACT = new System.Windows.Forms.TextBox();
this.TextBoxEMAIL = new System.Windows.Forms.TextBox();
this.TextBoxLOGIN = new System.Windows.Forms.TextBox();
this.TextBoxPASSword = new System.Windows.Forms.TextBox();
this.ButtonCREATE = new System.Windows.Forms.Button();
this.LabelMSG = new System.Windows.Forms.Label();
this.Lblaccount = new System.Windows.Forms.Label();
this.ButtoNLOGIN = new System.Windows.Forms.Button();
this.components = new System.ComponentModel.Container();
this.WebLoginManager1 = new LimnorDatabase.WebLoginManager(this.components);
this.EasyDataSet1 = new LimnorDatabase.EasyDataSet();
this.EasyUpdator1 = new LimnorDatabase.EasyUpdator(this.components);
this.MailSender1 = new Limnor.Net.MailSender();
((System.ComponentModel.ISupportInitialize)(EasyDataSet1)).BeginInit();
((System.ComponentModel.ISupportInitialize)(PictureBox1)).BeginInit();
this.SuspendLayout();
//
// Label1
//
this.Label1.Font = new System.Drawing.Font("Microsoft Sans Serif", 20.25F, ((System.Drawing.FontStyle)((System.Drawing.FontStyle.Bold | System.Drawing.FontStyle.Italic))));
this.Label1.ForeColor = System.Drawing.Color.Navy;
this.Label1.Location = new System.Drawing.Point(316, 20);
this.Label1.Name = "Label1";
this.Label1.Size = new System.Drawing.Size(220, 30);
this.Label1.TabIndex = 0;
this.Label1.Text = "SIGNUP HERE";
//
// PictureBox1
//
this.PictureBox1.Image = ((System.Drawing.Image)(resources.GetObject("PictureBox1.Image")));
this.PictureBox1.Location = new System.Drawing.Point(384, 53);
this.PictureBox1.Name = "PictureBox1";
this.PictureBox1.Size = new System.Drawing.Size(64, 44);
this.PictureBox1.TabIndex = 1;
this.PictureBox1.TabStop = false;
//
// LabelLNM
//
this.LabelLNM.Font = new System.Drawing.Font("Microsoft Sans Serif", 15.75F, System.Drawing.FontStyle.Bold);
this.LabelLNM.ForeColor = System.Drawing.Color.Navy;
this.LabelLNM.Location = new System.Drawing.Point(166, 162);
this.LabelLNM.Name = "LabelLNM";
this.LabelLNM.Size = new System.Drawing.Size(160, 23);
this.LabelLNM.TabIndex = 2;
this.LabelLNM.Text = "LAST NAME";
//
// LabelFNM
//
this.LabelFNM.Font = new System.Drawing.Font("Microsoft Sans Serif", 15.75F, System.Drawing.FontStyle.Bold);
this.LabelFNM.ForeColor = System.Drawing.Color.Navy;
this.LabelFNM.Location = new System.Drawing.Point(166, 125);
this.LabelFNM.Name = "LabelFNM";
this.LabelFNM.Size = new System.Drawing.Size(170, 23);
this.LabelFNM.TabIndex = 2;
this.LabelFNM.Text = "FIRST NAME";
//
// LabelSTATE
//
this.LabelSTATE.Font = new System.Drawing.Font("Microsoft Sans Serif", 15.75F, System.Drawing.FontStyle.Bold);
this.LabelSTATE.ForeColor = System.Drawing.Color.Navy;
this.LabelSTATE.Location = new System.Drawing.Point(166, 200);
this.LabelSTATE.Name = "LabelSTATE";
this.LabelSTATE.Size = new System.Drawing.Size(94, 23);
this.LabelSTATE.TabIndex = 2;
this.LabelSTATE.Text = "STATE";
//
// LabelCONTACT
//
this.LabelCONTACT.Font = new System.Drawing.Font("Microsoft Sans Serif", 15.75F, System.Drawing.FontStyle.Bold);
this.LabelCONTACT.ForeColor = System.Drawing.Color.Navy;
this.LabelCONTACT.Location = new System.Drawing.Point(166, 236);
this.LabelCONTACT.Name = "LabelCONTACT";
this.LabelCONTACT.Size = new System.Drawing.Size(160, 23);
this.LabelCONTACT.TabIndex = 2;
this.LabelCONTACT.Text = "CONTACT NO";
//
// LabelEMAIL
//
this.LabelEMAIL.Font = new System.Drawing.Font("Microsoft Sans Serif", 15.75F, System.Drawing.FontStyle.Bold);
this.LabelEMAIL.ForeColor = System.Drawing.Color.Navy;
this.LabelEMAIL.Location = new System.Drawing.Point(166, 275);
this.LabelEMAIL.Name = "LabelEMAIL";
this.LabelEMAIL.Size = new System.Drawing.Size(98, 23);
this.LabelEMAIL.TabIndex = 2;
this.LabelEMAIL.Text = "E-MAIL";
//
// LabelLOGIN
//
this.LabelLOGIN.Font = new System.Drawing.Font("Microsoft Sans Serif", 15.75F, System.Drawing.FontStyle.Bold);
this.LabelLOGIN.ForeColor = System.Drawing.Color.Navy;
this.LabelLOGIN.Location = new System.Drawing.Point(166, 321);
this.LabelLOGIN.Name = "LabelLOGIN";
this.LabelLOGIN.Size = new System.Drawing.Size(160, 23);
this.LabelLOGIN.TabIndex = 2;
this.LabelLOGIN.Text = "LOGIN NAME";
//
// LabelPASS
//
this.LabelPASS.Font = new System.Drawing.Font("Microsoft Sans Serif", 15.75F, System.Drawing.FontStyle.Bold);
this.LabelPASS.ForeColor = System.Drawing.Color.Navy;
this.LabelPASS.Location = new System.Drawing.Point(166, 365);
this.LabelPASS.Name = "LabelPASS";
this.LabelPASS.Size = new System.Drawing.Size(160, 23);
this.LabelPASS.TabIndex = 2;
this.LabelPASS.Text = "PASSWORD";
//
// TextBoxFNM
//
this.TextBoxFNM.Location = new System.Drawing.Point(489, 125);
this.TextBoxFNM.Name = "TextBoxFNM";
this.TextBoxFNM.Size = new System.Drawing.Size(270, 20);
this.TextBoxFNM.TabIndex = 3;
//
// TextBoxLNM
//
this.TextBoxLNM.Location = new System.Drawing.Point(489, 165);
this.TextBoxLNM.Name = "TextBoxLNM";
this.TextBoxLNM.Size = new System.Drawing.Size(270, 20);
this.TextBoxLNM.TabIndex = 3;
//
// TextBoxSTATE
//
this.TextBoxSTATE.Location = new System.Drawing.Point(489, 203);
this.TextBoxSTATE.Name = "TextBoxSTATE";
this.TextBoxSTATE.Size = new System.Drawing.Size(270, 20);
this.TextBoxSTATE.TabIndex = 3;
//
// TextBoxCONTACT
//
this.TextBoxCONTACT.Location = new System.Drawing.Point(489, 242);
this.TextBoxCONTACT.Name = "TextBoxCONTACT";
this.TextBoxCONTACT.Size = new System.Drawing.Size(270, 20);
this.TextBoxCONTACT.TabIndex = 3;
//
// TextBoxEMAIL
//
this.TextBoxEMAIL.Location = new System.Drawing.Point(489, 278);
this.TextBoxEMAIL.Name = "TextBoxEMAIL";
this.TextBoxEMAIL.Size = new System.Drawing.Size(270, 20);
this.TextBoxEMAIL.TabIndex = 3;
//
// TextBoxLOGIN
//
this.TextBoxLOGIN.Location = new System.Drawing.Point(489, 322);
this.TextBoxLOGIN.Name = "TextBoxLOGIN";
this.TextBoxLOGIN.Size = new System.Drawing.Size(270, 20);
this.TextBoxLOGIN.TabIndex = 3;
//
// TextBoxPASSword
//
this.TextBoxPASSword.Location = new System.Drawing.Point(489, 365);
this.TextBoxPASSword.Name = "TextBoxPASSword";
this.TextBoxPASSword.Size = new System.Drawing.Size(270, 20);
this.TextBoxPASSword.TabIndex = 3;
//
// ButtonCREATE
//
this.ButtonCREATE.Font = new System.Drawing.Font("Microsoft Sans Serif", 15.75F, System.Drawing.FontStyle.Bold);
this.ButtonCREATE.ForeColor = System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(0)))), ((int)(((byte)(192)))));
this.ButtonCREATE.Location = new System.Drawing.Point(489, 408);
this.ButtonCREATE.Name = "ButtonCREATE";
this.ButtonCREATE.Size = new System.Drawing.Size(200, 36);
this.ButtonCREATE.TabIndex = 4;
this.ButtonCREATE.Text = "CREATE";
this.ButtonCREATE.UseVisualStyleBackColor = true;
this.ButtonCREATE.Click += new System.EventHandler(this.Click_5b21a0d7);
//
// LabelMSG
//
this.LabelMSG.Font = new System.Drawing.Font("Microsoft Sans Serif", 14.25F, System.Drawing.FontStyle.Bold);
this.LabelMSG.ForeColor = System.Drawing.Color.Black;
this.LabelMSG.Location = new System.Drawing.Point(489, 478);
this.LabelMSG.Name = "LabelMSG";
this.LabelMSG.Size = new System.Drawing.Size(114, 23);
this.LabelMSG.TabIndex = 5;
this.LabelMSG.Text = "MESSAGE";
//
// Lblaccount
//
this.Lblaccount.Font = new System.Drawing.Font("Microsoft Sans Serif", 18F, System.Drawing.FontStyle.Bold);
this.Lblaccount.Location = new System.Drawing.Point(166, 551);
this.Lblaccount.Name = "Lblaccount";
this.Lblaccount.Size = new System.Drawing.Size(318, 31);
this.Lblaccount.TabIndex = 3;
this.Lblaccount.Text = "Already have an account?";
//
// ButtoNLOGIN
//
this.ButtoNLOGIN.Font = new System.Drawing.Font("Microsoft Sans Serif", 15.75F, System.Drawing.FontStyle.Bold);
this.ButtoNLOGIN.ForeColor = System.Drawing.Color.Navy;
this.ButtoNLOGIN.Location = new System.Drawing.Point(489, 551);
this.ButtoNLOGIN.Name = "ButtoNLOGIN";
this.ButtoNLOGIN.Size = new System.Drawing.Size(200, 39);
this.ButtoNLOGIN.TabIndex = 6;
this.ButtoNLOGIN.Text = "LOGIN";
this.ButtoNLOGIN.UseVisualStyleBackColor = true;
this.ButtoNLOGIN.Click += new System.EventHandler(this.Click_22df9cba);
//
// WebLoginManager1
//
this.WebLoginManager1.ComponentName = "WebLoginManager1";
this.WebLoginManager1.ConnectionID = new System.Guid("50dc8941-d656-4888-9c35-65ce28a08610");
this.WebLoginManager1.DefaultConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\\Users\\rishabh\\OneDrive\\Documents\\" +
"SOFTWAREMERCHANT.mdb;Mode=ReadWrite;";
this.WebLoginManager1.DefaultConnectionType = typeof(System.Data.OleDb.OleDbConnection);
this.WebLoginManager1.FailedMessageLableId = null;
this.WebLoginManager1.ID = new System.Guid("5866f8b1-508e-47f0-9c59-c07e6893ab70");
this.WebLoginManager1.InactivityMinutes = 0;
this.WebLoginManager1.LabelToShowLoginFailedMessage = null;
this.WebLoginManager1.LoginFailedMessage = null;
this.WebLoginManager1.LoginPermissionFailedMessage = null;
this.WebLoginManager1.PasswordHash = WindowsUtility.EnumPasswordHash.SHA256;
this.WebLoginManager1.UserAccountIdFieldName = "USERiD";
this.WebLoginManager1.UserAccountLevelFieldName = "USER LEVEL";
this.WebLoginManager1.UserAccountLoginFieldName = "LOGIN NAME";
this.WebLoginManager1.UserAccountPasswordFieldName = "PASSWORD";
this.WebLoginManager1.UserAccountResetCodeFieldName = "RESET CODE";
this.WebLoginManager1.UserAccountResetCodeTimeFieldName = "RESET CODE EXPIRE";
this.WebLoginManager1.UserAccountSaltFieldName = "SALT";
this.WebLoginManager1.UserAccountTableName = "GLASS";
//
// EasyDataSet1
//
this.EasyDataSet1.ConnectionID = new System.Guid("50dc8941-d656-4888-9c35-65ce28a08610");
this.EasyDataSet1.DataSetName = "Data_cfc53ca6-cc5c-4dad-a6bf-cc872e254d13";
this.EasyDataSet1.DefaultConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\\Users\\rishabh\\OneDrive\\Documents\\" +
"SOFTWAREMERCHANT.mdb;Mode=ReadWrite;";
this.EasyDataSet1.DefaultConnectionType = typeof(System.Data.OleDb.OleDbConnection);
this.EasyDataSet1.Description = null;
this.EasyDataSet1.DynamicParameters = dbparameterlistext1;
this.EasyDataSet1.Field_DataSize = new int[] {
4
};
this.EasyDataSet1.Field_FieldCaption = new string[] {
null
};
this.EasyDataSet1.Field_FieldText = new string[] {
"[GLASS].[USERiD]"
};
this.EasyDataSet1.Field_FromTableName = new string[] {
"GLASS"
};
this.EasyDataSet1.Field_Indexed = new bool[] {
true
};
this.EasyDataSet1.Field_IsIdentity = new bool[] {
true
};
this.EasyDataSet1.Field_Name = new string[] {
"USERiD"
};
this.EasyDataSet1.Field_OleDbType = new System.Data.OleDb.OleDbType[] {
System.Data.OleDb.OleDbType.Integer
};
this.EasyDataSet1.Field_ReadOnly = new bool[] {
true
};
this.EasyDataSet1.From = "[GLASS]";
this.EasyDataSet1.GroupBy = null;
this.EasyDataSet1.Having = null;
this.EasyDataSet1.IsFieldImage = new bool[] {
false
};
this.EasyDataSet1.Limit = null;
this.EasyDataSet1.Name = "EasyDataSet1";
this.EasyDataSet1.OrderBy = null;
this.EasyDataSet1.Param_Name = new string[] {
"@loginName"
};
this.EasyDataSet1.Param_OleDbType = new System.Data.OleDb.OleDbType[] {
System.Data.OleDb.OleDbType.VarWChar
};
this.EasyDataSet1.Param_Value = new string[] {
"System.String, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c5" +
"61934e089|"
};
this.EasyDataSet1.TableName = "Table4010146875";
this.EasyDataSet1.UpdatableTableName = "GLASS";
this.EasyDataSet1.Where = "[GLASS].[LOGIN NAME] = @loginName";
//
// EasyUpdator1
//
this.EasyUpdator1.ConnectionID = new System.Guid("50dc8941-d656-4888-9c35-65ce28a08610");
this.EasyUpdator1.DefaultConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\\Users\\rishabh\\OneDrive\\Documents\\" +
"SOFTWAREMERCHANT.mdb;Mode=ReadWrite;";
this.EasyUpdator1.DefaultConnectionType = typeof(System.Data.OleDb.OleDbConnection);
sqlnonequery1.CommandType = LimnorDatabase.enmNonQueryType.Insert;
sqlnonequery1.MultiRow = false;
sqlnonequery1.Param_Name = new string[] {
"@FIRSTNM",
"@LASTNM",
"@STATE",
"@CONTACT",
"@EMAIL",
"@LOGINNM",
"@PASS"
};
sqlnonequery1.Param_OleDbType = new System.Data.OleDb.OleDbType[] {
System.Data.OleDb.OleDbType.VarWChar,
System.Data.OleDb.OleDbType.VarWChar,
System.Data.OleDb.OleDbType.VarWChar,
System.Data.OleDb.OleDbType.VarWChar,
System.Data.OleDb.OleDbType.VarWChar,
System.Data.OleDb.OleDbType.VarWChar,
System.Data.OleDb.OleDbType.VarWChar
};
sqlnonequery1.Param_Value = new string[] {
"System.String, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c5" +
"61934e089|",
"System.String, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c5" +
"61934e089|",
"System.String, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c5" +
"61934e089|",
"System.String, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c5" +
"61934e089|",
"System.String, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c5" +
"61934e089|",
"System.String, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c5" +
"61934e089|",
"System.String, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c5" +
"61934e089|"
};
sqlnonequery1.SQL = "INSERT INTO [GLASS] ([FIRST NAME],[LAST NAME],[STATE],[CONTACT NO],[E-MAIL],[LOGI" +
"N NAME],[PASSWORD]) VALUES (@FIRSTNM,@LASTNM,@STATE,@CONTACT,@EMAIL,@LOGINNM,@P" +
"ASS)";
sqlnonequery1.TableName = "";
this.EasyUpdator1.ExecutionCommand = sqlnonequery1;
this.EasyUpdator1.LastInsertID = 0;
this.EasyUpdator1.Name = "EasyUpdator1";
//
// Form1
//
this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 13F);
this.BackColor = System.Drawing.Color.Teal;
this.ClientSize = new System.Drawing.Size(917, 618);
this.Controls.Add(this.Label1);
this.Controls.Add(this.PictureBox1);
this.Controls.Add(this.LabelLNM);
this.Controls.Add(this.LabelFNM);
this.Controls.Add(this.LabelSTATE);
this.Controls.Add(this.LabelCONTACT);
this.Controls.Add(this.LabelEMAIL);
this.Controls.Add(this.LabelLOGIN);
this.Controls.Add(this.LabelPASS);
this.Controls.Add(this.TextBoxFNM);
this.Controls.Add(this.TextBoxLNM);
this.Controls.Add(this.TextBoxSTATE);
this.Controls.Add(this.TextBoxCONTACT);
this.Controls.Add(this.TextBoxEMAIL);
this.Controls.Add(this.TextBoxLOGIN);
this.Controls.Add(this.TextBoxPASSword);
this.Controls.Add(this.ButtonCREATE);
this.Controls.Add(this.LabelMSG);
this.Controls.Add(this.Lblaccount);
this.Controls.Add(this.ButtoNLOGIN);
this.DrawingLayerList = ((Limnor.Drawing2D.DrawingLayerHeaderList)(resources.GetObject("$this.DrawingLayerList")));
this.Name = "Form1";
this.Text = "Form1";
WebLoginManager1.CreateDataTable();
EasyDataSet1.CreateDataTable();
EasyDataSet1.Query();
((System.ComponentModel.ISupportInitialize)(EasyDataSet1)).EndInit();
((System.ComponentModel.ISupportInitialize)(PictureBox1)).EndInit();
this.ResumeLayout(false);
this.PerformLayout();
}
public override object ConvertFrom(ITypeDescriptorContext context, CultureInfo culture, object value)
{
if (value is string)
{
string data = value as string;
if (!string.IsNullOrEmpty(data))
{
string[] ss = data.Split('|');
DbParameterListExt ps = new DbParameterListExt();
for (int i = 0; i < ss.Length; i++)
{
if (!string.IsNullOrEmpty(ss[i]))
{
string[] ss2 = ss[i].Split(';');
if (ss2.Length > 1)
{
EPField f = new EPField();
DbCommandParam p = new DbCommandParam(f);
if (!string.IsNullOrEmpty(ss2[0]))
{
if (!ss2[0].StartsWith("@", StringComparison.Ordinal))
{
f.Name = string.Format(CultureInfo.InvariantCulture, "@{0}", ss2[0]);
}
else
{
f.Name = ss2[0];
}
if (!string.IsNullOrEmpty(ss2[1]))
{
f.OleDbType = (OleDbType)Enum.Parse(typeof(OleDbType), ss2[1]);
if (ss2.Length > 2)
{
int n;
if (int.TryParse(ss2[2], out n))
{
f.DataSize = n;
}
if (ss2.Length > 3)
{
p.Direction = (ParameterDirection)Enum.Parse(typeof(ParameterDirection), ss2[3]);
if (ss2.Length > 4)
{
f.SetValue(ss2[4]);
}
}
}
ps.Add(p);
}
}
}
}
}
return(ps);
}
else
{
return(new DbParameterListExt());
}
}
return(base.ConvertFrom(context, culture, value));
}
