Programming Help

The Top 8 API Architectural Styles You Should Know in 2023

2023-08-12T00:31:00.004-07:00

The Top 8 API Architectural Styles You Should Know in 2023

REST (Representational State Transfer): A champion of simplicity and ubiquity, REST is an architectural style that primarily leverages HTTP methods. It enables easy interaction with resources, making it a go-to pattern for a multitude of applications and modern APIs.

SOAP (Simple Object Access Protocol): SOAP, a heavyweight contender in the API arena, thrives on complexity and power. It employs XML for defining structured communication. Although requiring a SOAP client and server, it compensates with its strength and robustness, much like a well-built off-road vehicle tackling rugged terrains.

GraphQL: A rising star in the API cosmos, GraphQL offers flexibility and precision. It lets clients ask for exactly what they need, reducing redundancy, and improving performance. Think of it as a personal shopper - you get just what you asked for, nothing more, nothing less.

gRPC (Google Remote Procedure Call): gRPC is the speedster of the API universe. Running on HTTP/2 and using binary data, it's all about performance and speed, especially for microservices architectures. It's like a high-speed train, ensuring quick and reliable communication.

WebSockets: If real-time and bi-directional communication is what you need, WebSockets are the answer. Ideal for chat applications, live streaming, and real-time data exchange, it's like having an open telephone line between clients and servers.

Webhooks: Webhooks are the town criers of the digital world. They notify clients when certain server-side events occur, making them perfect for event-driven architectures. Imagine them as your personal alert system, keeping you informed of what matters.

MQTT (Message Queuing Telemetry Transport): MQTT is a lightweight messenger, designed specifically for environments with limited resources, low bandwidth, and unreliable networks. Picture it as a postal worker determined to deliver your mail, come rain or shine.

AMQP (Advanced Message Queuing Protocol): A robust and standardized protocol, AMQP excels in middleware environments with its reliable messaging capabilities. It's like a well-oiled assembly line, efficiently moving messages where they need to go.

Which API architectural style should you use?

The best API architectural style for a particular application will depend on the specific requirements of the application, such as  -

1. The type of data that will be exchanged between the API and the client

2. The performance requirements of the API

3. The security requirements of the API

4. The scalability requirements of the API

Once you have considered these factors, you can start to narrow down your choices and choose the API architectural style that is best suited for your application.

Problem Solving Steps

2023-08-11T21:53:00.004-07:00

When facing challenges in life, it can be helpful to follow a problem-solving process to find effective solutions. Here are the steps for problem-solving in life:

1. Identify the problem: Clearly define and understand the issue you are facing. Be specific about what needs to be resolved.

2. Gather information: Collect relevant information and gather facts about the problem. This includes analyzing the causes and understanding the impact it has on your life.

3. Generate possible solutions: Brainstorm and come up with multiple potential solutions. Be open-minded and consider different approaches or perspectives.

4. Evaluate and select the best solution: Assess each potential solution and consider their feasibility, effectiveness, and potential consequences. Choose the solution that has the highest chance of resolving the problem.

5. Create an action plan: Develop a detailed plan of action to implement the chosen solution. Break it down into smaller steps to make it more manageable and set a realistic timeline.

6. Take action: Put your plan into motion and start taking tangible steps towards solving the problem. Stay committed and consistent with your actions.

7. Monitor and evaluate: Continuously evaluate the progress of your solution. Observe any changes or improvements and make necessary adjustments along the way.

8. Seek support if needed: Don't hesitate to seek help or guidance from others if you feel overwhelmed or if the problem requires expertise beyond your capabilities. This can include talking to friends, family, mentors, or professionals.

9. Learn from the experience: Reflect on the problem-solving process and the outcomes. Identify any lessons or insights gained from the experience that can help you handle similar challenges in the future.

Remember, problem-solving is not always a linear process. You may need to revisit some steps or adjust your approach based on new information that arises. Stay resilient, patient, and adaptable as you work towards finding solutions to the challenges that life presents.

Agile Development with a CI/CD pipeline

2023-08-10T23:08:00.010-07:00

Use this Super Simple Template to Learn How to Implement CI/CD in Your Agile Team.

Often, I see confusion surrounding the integration of Agile Development with a CI/CD pipeline.

This illustration isn't merely a CI/CD workflow, but an agile development process harmoniously intertwined with CI/CD flow. It is just a baseline diagram and the tools/technology used here are examples - feel free to replace them with equivalent tools or technology that suits your team's preferences and requirements.

Software Quality AssuranceMeasurement through Metric

2023-06-06T23:19:00.004-07:00

Measurement through metric i.e., 2 measures and analyze your goal/decision through graph for all the defects identified.

Goal/Decision: My goal is to identify that, at which level, the most defects have been raised. and after that I have to inform the respective team to take some actions to improve the quality in effected area/level.”

Metric: Overall Defect Weightage at Different Levels/Arti-crafts

According to analysis, there are 67% defects are identified in Code Level Testing with weightage 53% among other levels. So I will inform the Coding team to take required actions to improve their works.

Defect Prevention Techniques

2023-06-06T04:52:00.005-07:00

Defect Prevention Techniques

Exemplify techniques/methods/ways through which we can prevent Defect Injection in SRS (Requirement specification) and Design Specification e.g. Activity Diagram.

Click here to download Assignment

Flow chart design checklist

2023-06-06T02:48:00.005-07:00

Flow chart design checklist

1 Clearly define the objective or purpose of the flowchart. Identify what process or system the flowchart represents.

2 Determine the intended audience for the flowchart. Consider their level of knowledge and familiarity with the process to ensure the flowchart is appropriate and understandable for them.

3 Collect all the necessary information about the process or system that will be included in the flowchart. This may involve consulting subject matter experts or reviewing relevant documentation.

4 Decide the appropriate level of detail for the flowchart. It should be comprehensive enough to capture the essential steps and decision points without becoming overly complex or confusing.

5 Follow recognized standards and conventions for flowchart symbols. This ensures consistency and ease of understanding for those familiar with flowcharting.

6 Ensure the flowchart represents the correct sequence of steps and decisions. Verify that the arrows and connectors accurately indicate the flow from one symbol to another.

7 Walk through the flowchart step by step to validate its accuracy. Make sure it reflects the actual process or system accurately and that there are no logical errors or missing steps.

8 Aim for simplicity and clarity in the flowchart design. Avoid excessive complexity, unnecessary symbols, or overcrowding the diagram with too much information.

9 Label each symbol, decision point, and connector clearly and concisely. Use descriptive text that accurately represents the action or decision being made.

10 Have someone else review the flowchart to provide feedback and identify any areas that may need improvement. Make revisions as necessary to enhance clarity and accuracy.

11 Pay attention to the visual layout and formatting of the flowchart. Ensure that the symbols are neatly arranged, the text is readable, and the overall presentation is visually appealing.

How to get Attendance log from ZKteco Biometric Machine using ZKteco SDK

2018-11-29T19:48:00.002-08:00

ZKteco Attendance Device is widely used machine for bio-metric attendance and facial recognition attendance,

Here is the function how to get the device log from Machine using ZKteco SDK.

public DataTable LogTable()

{

DataTable DT = new DataTable();

DT.Columns.Add("EmpID");

DT.Columns.Add("Logtime");

DT.Columns.Add("LogBranchId");

DT.Columns.Add("TTYPE");

DT.Columns.Add("Description");

return DT;

}

DataTable DTAttLog = LogTable();

public void GetLogfromMachine(int iMnumber, String MachineIP, String Port,String LogBranchId,String TTYPE)

{

//Setup columns and other UI stuff

//Set datasource of grid

//axCZKEM1 = new zkemkeeper.CZKEMClass();

//Cursor = Cursors.WaitCursor;

int idwErrorCode = 0;

setstatus("Connecting to device " + MachineIP + ":" + Port + ", please wait...");

bIsConnected = axCZKEM1.Connect_Net(MachineIP, Convert.ToInt32(Port));

if (bIsConnected)

{

//c1TrueDBGrid1[iMnumber - 1, "Status"] = "Connected";

c1TrueDBGrid1[iMnumber - 1, "F.Attempts"] = "0";

c1TrueDBGrid1[iMnumber - 1, "LSTime"] = DateTime.Now;

setstatus("Connected to device " + MachineIP + ":" + Port + "");

OutPut(MachineIP + ":" + Port + " Current State:Connected");

c1TrueDBGrid1.Refresh();

axCZKEM1.RegEvent(iMachineNumber, 65535);

#region GetLog

string sdwEnrollNumber = "";

//int idwTMachineNumber=0;

//int idwEMachineNumber=0;

int idwVerifyMode = 0;

int idwInOutMode = 0;

int idwYear = 0;

int idwMonth = 0;

int idwDay = 0;

int idwHour = 0;

int idwMinute = 0;

int idwSecond = 0;

int idwWorkcode = 0;

idwErrorCode = 0;

int iGLCount = 0;

int iIndex = 0;

//Cursor = Cursors.WaitCursor;

int LogRecivedCount = 0;

//axCZKEM1.EnableDevice(iMachineNumber, false);//disable the device

setstatus("Fetching log from device " + MachineIP + ":" + Port + ", please wait...");

if (axCZKEM1.ReadGeneralLogData(iMachineNumber))//read all the attendance records to the memory

{

LogRecivedCount = 0;

while (axCZKEM1.SSR_GetGeneralLogData(iMnumber, out sdwEnrollNumber, out idwVerifyMode,

out idwInOutMode, out idwYear, out idwMonth, out idwDay, out idwHour, out idwMinute, out idwSecond, ref idwWorkcode))//get records from the memory

{

//iGLCount++;

//lvLogs.Items.Add(iGLCount.ToString());

//lvLogs.Items[iIndex].SubItems.Add(sdwEnrollNumber);//modify by Darcy on Nov.26 2009

//lvLogs.Items[iIndex].SubItems.Add(idwVerifyMode.ToString());

//lvLogs.Items[iIndex].SubItems.Add(idwInOutMode.ToString());

//lvLogs.Items[iIndex].SubItems.Add(idwYear.ToString() + "-" + idwMonth.ToString() + "-" + idwDay.ToString() + " " + idwHour.ToString() + ":" + idwMinute.ToString() + ":" + idwSecond.ToString());

//lvLogs.Items[iIndex].SubItems.Add(idwWorkcode.ToString());

//iIndex++;

try

{

DTAttLog.Rows.Add(sdwEnrollNumber, idwYear.ToString() + "-" + idwMonth.ToString() + "-" + idwDay.ToString() + " " + idwHour.ToString() + ":" + idwMinute.ToString() + ":" + idwSecond.ToString(), LogBranchId, TTYPE, MachineIP+":"+Port);

}

catch (Exception)

{

// throw;

}

LogRecivedCount++;

setstatus("Fetching log from device " + MachineIP + ":" + Port + ", log fetched = " + LogRecivedCount + ", please wait...");

}

OutPut("Fetch Record from Machine Total Count was " + LogRecivedCount);

setstatus("Fetching log completed from device " + MachineIP + ":" + Port + ", log fetched = " + LogRecivedCount + "");

LogRecivedCount = 0;

}

else

{

//Cursor = Cursors.Default;

axCZKEM1.GetLastError(ref idwErrorCode);

if (idwErrorCode != 0)

{

OutPut("Reading data from terminal failed,ErrorCode: " + idwErrorCode.ToString());

setstatus("Reading data from terminal failed,ErrorCode: " + idwErrorCode.ToString() + " from device " + MachineIP + ":" + Port + "");

}

else

{

OutPut("No data from terminal returns!");

setstatus("No data from returns from device " + MachineIP + ":" + Port + "");

}

axCZKEM1.ClearGLog(iMachineNumber);

axCZKEM1.RefreshData(iMachineNumber);

//axCZKEM1.EnableDevice(iMachineNumber, true);//enable the device

#endregion

axCZKEM1.Disconnect();

}

else

{

axCZKEM1.GetLastError(ref idwErrorCode);

//c1TrueDBGrid1[iMnumber - 1, "Status"] = "ErrorCode=" + idwErrorCode.ToString();

OutPut("Unable to connect the device " + MachineIP + ":" + Port + ", ErrorCode=" + idwErrorCode.ToString());

c1TrueDBGrid1[iMnumber - 1, "LSTime"] = DateTime.Now;

setstatus("Unable to connect, ErrorCode: " + idwErrorCode.ToString() + " from device " + MachineIP + ":" + Port + "");

if (idwErrorCode == -7)

{

try

{

int ConAttempts = Convert.ToInt32(c1TrueDBGrid1[iMnumber - 1, "F.Attempts"]);

ConAttempts = ConAttempts + 1;

c1TrueDBGrid1[iMnumber - 1, "F.Attempts"] = ConAttempts;

c1TrueDBGrid1[iMnumber - 1, "LSTime"] = DateTime.Now;

if (ConAttempts >= 3)

{

TerminalActivateDeactivate(iMnumber, "InActive");

}

catch (Exception)

{

//throw;

}

axCZKEM1.Disconnect();

}

Crystal Report is not rendering/showing/runing in localhost visual studio

2018-01-21T23:42:00.003-08:00

Crystal report is not loading in browser, due to windows update, little workaround is required to get this issue fix.

Step1. If crystal report is installed on your system go to following path.

C:\inetpub\wwwroot\aspnet_client\system_web\4_0_30319\crystalreportviewers13

copy the folder "crystalreportviewers13" and paste in application root folder

Step2. Go to web.config file. modify section group in this way.

</sectionGroup>

</configSections>

</rptBuildProvider>

</crystalReportViewer>

</crystalReports>

</businessObjects>

The key value will be defined in the way

http://localhost:36409/ERPWeb//ERPWeb/crystalreportviewers13

OutOfMemoryException: Out of memory Saving Bitmap

2017-09-14T06:43:00.000-07:00

OutOfMemoryException: Out of memory Saving Bitmap

If out of memory exception occurs catch the exception and write the code which is in catch block

DataTable DT //result from DB

MemoryStream ms;

Bitmap bp;

for (int i = 0; i < DT.Rows.Count; i++)

{

String filename = DT.Rows[i]["ID"].ToString() + ".jpg";

string RootFolder = @"E:\FTPData\ERPWebForTest\StudentPictures";

string path = Path.Combine(RootFolder, filename);

try

{

ms = new MemoryStream((byte[])DT.Rows[i]["DisplayImage"]);

bp = new Bitmap(ms);

bp.Save(path);

}

catch (Exception) //in case of out of memory exception

{

ms = new MemoryStream((byte[])DT.Rows[i]["DisplayImage"]);

byte[] buffer = new byte[4096];

int byteSeq = ms.Read(buffer, 0, 4096);

ms.Write(buffer, 0, byteSeq);

}

Hotel Management System

2014-10-10T00:24:00.001-07:00

Dear All,

I am offering Hotel Management System for your Hotel Reservation, Restaurant. There are satisfied clients of this HMS using this system from 2 Years.

Hotel Management System is available for Sales in Pakistan and outside Pakistan for international Clients.

Hotel Management System with source code in C-sharp is also available in affordable price. now you can get source code and build the application by own.

Please contact
Skype: khalid.rafique84
Mobile # +923335761509
Features:

•Room Reservation

•Reservation Inquiries

•Room Services Records

•Guest/Customer Registration

•Companies Registration

•Room Registration/Settings

•Room Availability

•System Users and Roles

•Point Of Sale

•Stock Management

•Reports

Room Rent and Taxes Report

Services Report

Booking By Statuses Report

Cash Collection Report by Date

Invoice Report Multiple

Reservation Invoice

Daily Sales Report By Date

Paid Amount Report By Date

Police Report

Tax Reports

Stock Report (Daily Issuances, Balance Report, Daily Purchase, Daily Cost Report

Hotel Management System .. Booking Screen

SQL Job for Backup Database MDF/Log File Detaching.. Copying and Attaching Files

2014-06-03T03:31:00.001-07:00

SQL Job for Backup Database MDF/Log File Detaching.. Copying and Attaching Files

declare @cmdstring varchar(1000)

declare @cmdstring1 varchar(1000)

declare @BkpFromPath varchar(1000)

declare @BkpToPath varchar(1000)

declare @DbName varchar(100)

declare @i int

Set @DBName = 'CableBilling_DB' -- Database Name

Set @BkpFromPath = 'H:\LibraCables\Database\' -- DataBase Files location

Set @BkpToPath = 'H:\data11\' -- Destination Folder

Set @i = 15 -- back up Days

EXEC master.dbo.sp_detach_db @dbname = @DBName

set @cmdstring = 'copy '+@BkpFromPath+''+@DBName+'.mdf '+@BkpToPath+''+@DBName+'bkp'+

convert(varchar,datepart(year,getdate()))+convert(varchar,datepart(month,getdate()))+convert(varchar,datepart(day,getdate()))+'.mdf'

exec master..xp_cmdshell @cmdstring

set @cmdstring1 = 'copy '+@BkpFromPath+''+@DBName+'_log.ldf '+@BkpToPath+''+@DBName+'bkp'+convert(varchar,datepart(year,getdate()))+convert(varchar,datepart(month,getdate()))+convert(varchar,datepart(day,getdate()))+'_log.ldf'

exec master..xp_cmdshell @cmdstring1

declare @delmdfString varchar(1000)

declare @delmdfString1 varchar(1000)

WHILE @i < 50

BEGIN

SET @i = @i + 1

set @delmdfString = 'del H:\data\CableBilling_DBbkp'+convert(varchar,datepart(year,DATEADD(day,-@i,getdate())))

+convert(varchar,datepart(month,DATEADD(day,-@i,getdate())))+convert(varchar,datepart(day,DATEADD(day,-@i,getdate())))+'.mdf'

set @delmdfString1 = 'del H:\data\CableBilling_DBbkp'+convert(varchar,datepart(year,DATEADD(day,-@i,getdate())))

+convert(varchar,datepart(month,DATEADD(day,-@i,getdate())))+convert(varchar,datepart(day,DATEADD(day,-@i,getdate())))+'_log.ldf'

exec master..xp_cmdshell @delmdfString

exec master..xp_cmdshell @delmdfString1

END

--declare @DbName varchar(100)

--declare @BkpFromPath varchar(100)

declare @PathWithFileNamemdf varchar(100)

declare @pathwithFileNameldf varchar(100)

--Set @DBName = 'CableBilling_DB'

--Set @BkpFromPath = 'H:\LibraCables\Database\'

Set @PathWithFileNamemdf = ''+@BkpFromPath+@DBName+'.mdf'

Set @pathwithFileNameldf = ''+@BkpFromPath+@DBName+'_log.ldf'

Set @DBName = @DbName

EXEC sp_attach_db @dbname = @DBName,

@filename1 = @PathWithFileNamemdf,

@filename2 = @pathwithFileNameldf

Modifying Database Connection information Dynamically from the Application at run time

2013-02-14T04:29:00.000-08:00

Configuration File: Below is the Configuration File

xml version="1.0"?>

</configSections>

</startup>

</appSettings>

</configuration>

Application Screen: Below is the Configuration File

Code Behind File...

using System;

using System.Collections.Generic;

using System.ComponentModel;

using System.Data;

using System.Drawing;

using System.Linq;

using System.Text;

using System.Windows.Forms;

using System.Data.SqlClient;

using System.Configuration;

using System.Xml;

using System.Xml.Linq;

namespace ManagementSystem

{

public partial class frmDataBaseSetting : Form

{

public frmDataBaseSetting()

{

InitializeComponent();

}

static string constr = "";

static SqlConnection sqlcon = new SqlConnection();

static SqlTransaction SqlTran;

public bool SavePressed = false;

///

/// Authentication Enumneration

///

public enum EnumAuthenticationType

{

WindowsAuthentication = 1,

SQLServerAuthentication = 2

}

///

/// get the connection String Sql Authentication

///

private string connectionStringSqlAuth

{

get

{

return "user id=" + txtDBLoginId.Text +

";password=" + txtDBLoginPassword.Text +

";data source=" + txtServerName.Text +

";Initial Catalog=" + txtDBName.Text;

}

///

/// get the connection String Windows Suthentication

///

private string connectionStringWindowAuth

{

get

{

return "data source=" + txtServerName.Text +

";Initial Catalog=" + txtDBName.Text +

";Integrated Security=True";

}

///

/// Method for when Test Connection Button will Press

///

private void btnTestConnection_Click(object sender, EventArgs e)

{

if (txtServerName.Text.Equals(""))

{

MessageBox.Show("Enter Server Name!", rsCommon.CompanyName, MessageBoxButtons.OK, MessageBoxIcon.Error);

return ;

}

if (txtDBName.Text.Equals(""))

{

MessageBox.Show("Enter DataBase Name!",rsCommon.CompanyName, MessageBoxButtons.OK, MessageBoxIcon.Error);

return ;

}

if (cmbAuthenticationType.Text.Equals(""))

{

MessageBox.Show("Select Authentication Type!", rsCommon.CompanyName,
MessageBoxButtons.OK, MessageBoxIcon.Error);

return ;

}

if (cmbAuthenticationType.Text.Equals(
EnumAuthenticationType.SQLServerAuthentication.ToString()))

{

if (txtDBLoginId.Text.Equals(""))

{

MessageBox.Show("Enter DataBase Login Id!", rsCommon.CompanyName,
MessageBoxButtons.OK, MessageBoxIcon.Error);

return;

}

if (txtDBLoginPassword.Text.Equals(""))

{

MessageBox.Show("Enter DataBase Login Password!", rsCommon.CompanyName,
MessageBoxButtons.OK, MessageBoxIcon.Error);

return;

}

String ConnectionMasg = "";

if (IsvalidConnection(out ConnectionMasg))

{

if (!SavePressed)

{

MessageBox.Show(ConnectionMasg, rsCommon.CompanyName,
MessageBoxButtons.OK, MessageBoxIcon.Exclamation);

}

else

{

SavePressed = false;

                    string appPath =
                            System.IO.Path.GetDirectoryName(
                                 System.Reflection.Assembly.GetExecutingAssembly().Location);

string configFile = System.IO.Path.Combine(appPath,
"ManagementSystem.exe.config");

ExeConfigurationFileMap configFileMap = new ExeConfigurationFileMap();

configFileMap.ExeConfigFilename = configFile;

                    System.Configuration.Configuration config =
                              ConfigurationManager.OpenMappedExeConfiguration(configFileMap,
                                     ConfigurationUserLevel.None);

                    config.AppSettings.Settings.Remove("DbServerName");
                    config.AppSettings.Settings.Add("DbServerName",
   txtServerName.Text.Trim());

config.AppSettings.Settings.Remove("DbSchemaName");
config.AppSettings.Settings.Add("DbSchemaName", txtDBName.Text.Trim());

                    config.AppSettings.Settings.Remove("DBAuthenticationType");
                    config.AppSettings.Settings.Add("DBAuthenticationType",
                                                cmbAuthenticationType.Text.Trim());

config.AppSettings.Settings.Remove("DbUserId");
config.AppSettings.Settings.Add("DbUserId", txtDBLoginId.Text.Trim());

                    config.AppSettings.Settings.Remove("DbUserPassword");
                    config.AppSettings.Settings.Add("DbUserPassword",
      txtDBLoginPassword.Text.Trim());

config.Save();

ConfigurationManager.RefreshSection("appSettings");

                    MessageBox.Show("Database Setting information has been updated
                                     successfully", rsCommon.CompanyName,
                                     MessageBoxButtons.OK, MessageBoxIcon.Exclamation);

}

else

{

MessageBox.Show("Connection Not Succeed : " + ConnectionMasg,
rsCommon.CompanyName, MessageBoxButtons.OK, MessageBoxIcon.Error);

}

public bool IsvalidConnection(out String strMsg)

{

if (sqlcon.State == ConnectionState.Open)

{

sqlcon.Close();

}

try

{

String AuthenticationType = cmbAuthenticationType.Text;

if(AuthenticationType.Equals(
EnumAuthenticationType.WindowsAuthentication.ToString()))

{

constr = connectionStringWindowAuth;

}

else if (AuthenticationType.Equals(
EnumAuthenticationType.SQLServerAuthentication.ToString()))

{

constr = connectionStringSqlAuth;

}

else

{

constr = connectionStringSqlAuth;

}

sqlcon = new SqlConnection(constr);

sqlcon.Open();

if (sqlcon.State == ConnectionState.Open)

{

sqlcon.Close();

}

strMsg = "Test Connection Succeed";

return true;

}

catch (Exception ex)

{

strMsg = ex.Message;

return false;

}

finally

{

if (sqlcon.State == ConnectionState.Open)

{

sqlcon.Close();

}

private void frmDataBaseSetting_Load(object sender, EventArgs e)

{

try

{

txtServerName.Text =
ConfigurationManager.AppSettings["DbServerName"].ToString();

txtDBName.Text = ConfigurationManager.AppSettings["DbSchemaName"].ToString();

cmbAuthenticationType.Text =
ConfigurationManager.AppSettings["DBAuthenticationType"].ToString();

txtDBLoginId.Text = ConfigurationManager.AppSettings["DbUserId"].ToString();

txtDBLoginPassword.Text =
ConfigurationManager.AppSettings["DbUserPassword"].ToString();

                if (ConfigurationManager.
                             AppSettings["DBAuthenticationType"].ToString().
                             Equals(EnumAuthenticationType.WindowsAuthentication.ToString()))

{

txtDBLoginId.ReadOnly = true;

txtDBLoginPassword.ReadOnly = true;

}

                else if (ConfigurationManager.
                           AppSettings["DBAuthenticationType"].ToString().
                           Equals(EnumAuthenticationType.SQLServerAuthentication.ToString()))

{

txtDBLoginId.ReadOnly = false;

txtDBLoginPassword.ReadOnly = false;

}

catch (Exception ex)

{

}

///

/// Changing Athuentication Type

///

private void cmbAuthenticationType_SelectedIndexChanged(object sender, EventArgs e)

{

if(cmbAuthenticationType.Text.
Equals(EnumAuthenticationType.WindowsAuthentication.ToString()))

{

txtDBLoginId.ReadOnly = true;

txtDBLoginPassword.ReadOnly = true;

}

else if(cmbAuthenticationType.Text.
Equals(EnumAuthenticationType.SQLServerAuthentication.ToString()))

{

txtDBLoginId.ReadOnly = false;

txtDBLoginPassword.ReadOnly = false;

}

///

/// Save button Event

///

private void btnSave_Click(object sender, EventArgs e)

{

SavePressed = true;

btnTestConnection_Click(null,null);

}

Using Case in a SQL Query

2013-01-29T05:09:00.002-08:00

Using Case in Update Statement

UPDATE dbo.Customer SET stateDescription = CASE WHEN statecode = 'MA' THEN 'Massachusetts' WHEN statecode = 'VA' THEN 'Virginia' WHEN statecode = 'PA' THEN 'Pennsylvania' ELSE NULL END

Using Case in Select Statement
SELECT COUNT(*) AS TotalCustomers,
SUM(CASE WHEN statecode = 'MA' THEN 1 ELSE NULL END) AS TotalMassCustomers,
AVG(CASE WHEN statecode = 'MA' THEN totalsales ELSE NULL END) AS TotalMassSales
FROM dbo.Customer

Using Case in Stored Procedure

CREATE PROCEDURE dbo.getCustomerData @sortby VARCHAR(9), @sortdirection CHAR(4) AS 
SET nocount ON 

SELECT customerid, firstname, lastname, statecode, statedescription, totalsales FROM dbo.Customer ORDER BY  CASE @sortdirection 
     WHEN 'asc' THEN 
      CASE @sortby  
       WHEN 'firstname' THEN firstname  
       WHEN 'lastname' THEN lastname  
       END 
END  
ASC, CASE @sortdirection 
      WHEN 'desc' THEN 
       CASE @sortby  
       WHEN 'firstname' THEN firstname  
       WHEN 'lastname' THEN lastname  
       END 
END 
DESC GO EXEC dbo.getCustomerData 'lastname', 'desc'

Generating BarCode Using C-Sharp

2013-01-21T05:23:00.001-08:00

Following are the methods to generate the barcode using C-Sharp...

private void btn_GenerateBarCode_Click(object sender, EventArgs e)

{

GenerateBarCode();

}

private void GenerateBarCode()

{

int barSize = System.Convert.ToInt32(39);

System.Byte[] imgBarcode = Code39("*" + txtBarCodeText.Text + "*", barSize, false, "");

MemoryStream memStream = new MemoryStream(imgBarcode);

PictureBox_BarCodeResult.Image = new Bitmap(memStream);

//statbar.Panels[0].Text = "Done.";

this.Cursor = Cursors.Default;

}

// This Method is used in above method

public byte[] Code39(string code, int barSize, bool showCodeString, string title)

{

MyBarCodeClass c39 = new MyBarCodeClass();

string appPath = Path.GetDirectoryName(Application.ExecutablePath);

// Create stream....

MemoryStream ms = new MemoryStream();

c39.FontFamilyName = "Free 3 of 9";

c39.FontFileName = appPath + "\\FREE3OF9.TTF";

c39.FontSize = barSize;

c39.ShowCodeString = showCodeString;

if (title + "" != "")

c39.Title = title;

Bitmap objBitmap = c39.GenerateBarcode(code);

objBitmap.Save(ms, ImageFormat.Png);

//return bytes....

return ms.GetBuffer();

}

Bellow is the Class used in above Method

public class MyBarCodeClass

{

private const int _itemSepHeight = 3;

SizeF _titleSize = SizeF.Empty;

SizeF _barCodeSize = SizeF.Empty;

SizeF _codeStringSize = SizeF.Empty;

#region Barcode Title

private string _titleString = null;

private Font _titleFont = null;

public string Title

{

get { return _titleString; }

set { _titleString = value; }

}

public Font TitleFont

{

get { return _titleFont; }

set { _titleFont = value; }

}

#endregion

#region Barcode code string

private bool _showCodeString = false;

private Font _codeStringFont = null;

public bool ShowCodeString

{

get { return _showCodeString; }

set { _showCodeString = value; }

}

public Font CodeStringFont

{

get { return _codeStringFont; }

set { _codeStringFont = value; }

}

#endregion

#region Barcode Font

private Font _c39Font = null;

private float _c39FontSize = 12;

private string _c39FontFileName = null;

private string _c39FontFamilyName = null;

public string FontFileName

{

get { return _c39FontFileName; }

set { _c39FontFileName = value; }

}

public string FontFamilyName

{

get { return _c39FontFamilyName; }

set { _c39FontFamilyName = value; }

}

public float FontSize

{

get { return _c39FontSize; }

set { _c39FontSize = value; }

}

private Font Code39Font

{

get

{

if (_c39Font == null)

{

// Load the barcode font

PrivateFontCollection pfc = new PrivateFontCollection();

pfc.AddFontFile(_c39FontFileName);

FontFamily family = new FontFamily(_c39FontFamilyName, pfc);

_c39Font = new Font(family, _c39FontSize);

}

return _c39Font;

}

#endregion

public MyBarCodeClass()

{

_titleFont = new Font("Arial", 10);

_codeStringFont = new Font("Arial", 10);

}

#region Barcode Generation

public Bitmap GenerateBarcode(string barCode)

{

int bcodeWidth = 0;

int bcodeHeight = 0;

// Get the image container...

Bitmap bcodeBitmap = CreateImageContainer(barCode, ref bcodeWidth, ref bcodeHeight);

Graphics objGraphics = Graphics.FromImage(bcodeBitmap);

// Fill the background

objGraphics.FillRectangle(new SolidBrush(Color.White), new Rectangle(0, 0, bcodeWidth, bcodeHeight));

int vpos = 0;

// Draw the title string

if (_titleString != null)

{

objGraphics.DrawString(_titleString, _titleFont, new SolidBrush(Color.Black), XCentered((int)_titleSize.Width, bcodeWidth), vpos);

vpos += (((int)_titleSize.Height) + _itemSepHeight);

}

// Draw the barcode

objGraphics.DrawString(barCode, Code39Font, new SolidBrush(Color.Black), XCentered((int)_barCodeSize.Width, bcodeWidth), vpos);

// Draw the barcode string

if (_showCodeString)

{

vpos += (((int)_barCodeSize.Height));

objGraphics.DrawString(barCode, _codeStringFont, new SolidBrush(Color.Black), XCentered((int)_codeStringSize.Width, bcodeWidth), vpos);

}

// return the image...

return bcodeBitmap;

}

private Bitmap CreateImageContainer(string barCode, ref int bcodeWidth, ref int bcodeHeight)

{

Graphics objGraphics;

// Create a temporary bitmap...

Bitmap tmpBitmap = new Bitmap(1, 1, PixelFormat.Format32bppArgb);

objGraphics = Graphics.FromImage(tmpBitmap);

// calculate size of the barcode items...

if (_titleString != null)

{

_titleSize = objGraphics.MeasureString(_titleString, _titleFont);

bcodeWidth = (int)_titleSize.Width;

bcodeHeight = (int)_titleSize.Height + _itemSepHeight;

}

_barCodeSize = objGraphics.MeasureString(barCode, Code39Font);

bcodeWidth = Max(bcodeWidth, (int)_barCodeSize.Width);

bcodeHeight += (int)_barCodeSize.Height;

if (_showCodeString)

{

_codeStringSize = objGraphics.MeasureString(barCode, _codeStringFont);

bcodeWidth = Max(bcodeWidth, (int)_codeStringSize.Width);

bcodeHeight += (_itemSepHeight + (int)_codeStringSize.Height);

}

// dispose temporary objects...

objGraphics.Dispose();

tmpBitmap.Dispose();

return (new Bitmap(bcodeWidth, bcodeHeight, PixelFormat.Format32bppArgb));

}

#endregion

#region Auxiliary Methods

private int Max(int v1, int v2)

{

return (v1 > v2 ? v1 : v2);

}

private int XCentered(int localWidth, int globalWidth)

{

return ((globalWidth - localWidth) / 2);

}

#endregion

}

Selecting Record to using cursor in stored procedure

2012-12-26T23:32:00.000-08:00

Following is an example using cursor to fetch record from table and performing action on each row using while loop, also used try catch in this stored procedure

ALTER PROCEDURE [dbo].[Test_Procedure_By_Khalid]

(

-- Add the parameters for the stored procedure here

@TableName nvarchar(255),

@AreaName varchar(50),

@SysDate DateTime,

@ReturnCode INT OUTPUT

)

DECLARE @GraphID NVARCHAR(50)

DECLARE @PERIOD INT

DECLARE @MODELKEY NVARCHAR(50)

DECLARE @ORIGNALDATE NVARCHAR(50)

DECLARE @DATE INT

DECLARE @QTY INT

DECLARE @TOTALQTY INT

DECLARE @MODELKEYTYPE INT

DECLARE @SCREENID NVARCHAR(50)

DECLARE @RetailModelClassificationName NVARCHAR(50)

DECLARE @SELECTEDAREA varchar(50)

DECLARE @INF_Cursor INT

DECLARE @THEMONTH NVARCHAR(6)

DECLARE @LASTMONTH NVARCHAR(6)

DECLARE @LASTYEARMONTH NVARCHAR(6)

--Cursor Definition

DECLARE @Cur_TableParm CURSOR

BEGIN TRY

----------------------------

-- Start Transaction --

----------------------------

BEGIN TRANSACTION

-- Set Cursor to select data from Table CPT_TableParm

SET @Cur_TableParm = CURSOR FAST_FORWARD FOR

SELECT GraphID,ModelKey,AreaName,ModelClassificationName,ScreenID FROM CPT_TableParm

WHERE TableName = @TableName

AND ActFcType = 1

-- Executing Cursor to select data from Table CPT_TableParm

OPEN @Cur_TableParm

FETCH NEXT FROM @Cur_TableParm INTO

@GraphID, @MODELKEY,@SELECTEDAREA,

@RetailModelClassificationName,@SCREENID

-- Looping through cursor result

WHILE @@FETCH_STATUS = 0

BEGIN

Print @SELECTEDAREA+','+cast(@PERIOD as varchar)+'~'+@MODELKEY+'~'+@ORIGNALDATE+'~'+cast(@DATE as varchar)+'~'+cast(@QTY as varchar)+'~'+

cast(@TOTALQTY as varchar)+'~'+@GraphID+'~''3''~'+@SCREENID

SET @ReturnCode = 2

FETCH NEXT FROM @Cur_TableParm INTO

@GraphID, @MODELKEY,@SELECTEDAREA,

@RetailModelClassificationName,@SCREENID

END

-- Closing @Cur_TableParm to select data from CPT_TableParm

CLOSE @Cur_TableParm

DEALLOCATE @Cur_TableParm

END TRY

BEGIN CATCH

-- Rollback Transaction --

ROLLBACK TRANSACTION

-- Reset Cursor State

BEGIN

SET @INF_Cursor = CURSOR_STATUS('global','@Cur_TableParm')

IF @INF_Cursor = -1

BEGIN

DEALLOCATE @Cur_TableParm -- Delete Cursor

END

ELSE IF @INF_Cursor <> -3

BEGIN

CLOSE @Cur_TableParm -- Close Cursor

DEALLOCATE @Cur_TableParm -- Delete Cursor

END

PRINT ERROR_MESSAGE()

END

RETURN 999

END CATCH

Very Simple Data Access Layer for Three Tire Application

2012-12-04T01:54:00.001-08:00

Below code is for very simple Data Access Layer that can be use in three tier application, it also includes the Method used in with Transaction

using System;

using System.Configuration;

using System.Data.SqlClient;

using System.Data;

namespace DataAccessLayer

{

public static class DAcess

{

static string constr = "";

static SqlCommand sqlcom = new SqlCommand();

static SqlConnection sqlcon = new SqlConnection();

static SqlDataAdapter sqlda;

static SqlTransaction SqlTran;

public static void ConnectToDatabase()

{

if (sqlcon.State == ConnectionState.Closed)

{

constr = ConfigurationManager.ConnectionStrings["ZaaSConString"].ToString();

sqlcon = new SqlConnection(constr);

sqlcon.Open();

}

public static void DisconnectToDataBase()

{

if(sqlcon.State == ConnectionState.Open)

sqlcon.Close();

}

public static DataTable returnDataTable(string Query)

{

DataTable dtResult = new DataTable("ResultTable");

try

{

ConnectToDatabase();

sqlda = new SqlDataAdapter(Query, sqlcon);

sqlda.Fill(dtResult);

}

catch (Exception ex)

{

}

finally

{

}

return dtResult;

}

public static DataTable returnDataTableSpecial(string Query)

{

DataTable dtResult = new DataTable("ResultTable");

try

{

ConnectToDatabase();

sqlcom = new SqlCommand(Query, sqlcon, SqlTran);

sqlda = new SqlDataAdapter(sqlcom);

sqlda.Fill(dtResult);

}

catch (Exception ex)

{

}

finally

{

}

return dtResult;

}

public static int ExecuteQuery(string Query)

{

int Result = 0;

try

{

ConnectToDatabase();

sqlcom = new SqlCommand(Query, sqlcon);

Result = sqlcom.ExecuteNonQuery();

sqlcon.Close();

}

catch (Exception ex)

{

sqlcon.Close();

throw ex;

}

finally

{

sqlcon.Close();

}

return Result;

}

public static int NewExecuteQuery(string Query)

{

int Result = 0;

sqlcom = new SqlCommand(Query, sqlcon, SqlTran);

Result = sqlcom.ExecuteNonQuery();

return Result;

}

public static void StartTransaction()

{

SqlTran = sqlcon.BeginTransaction(IsolationLevel.ReadUncommitted);

}

public static void CommitTransaction()

{

SqlTran.Commit();

}

public static void RollBackTransaction()

{

SqlTran.Rollback();

}

public static void CloseTransaction()

{

SqlTran.Dispose();

}

public static string returnScalar(string Query)

{

string ResultString = "";

try

{

ConnectToDatabase();

sqlcom = new SqlCommand(Query, sqlcon);

ResultString = Convert.ToString(sqlcom.ExecuteScalar());

sqlcon.Close();

}

catch (Exception ex)

{

sqlcon.Close();

throw ex;

}

finally

{

sqlcon.Close();

}

return ResultString;

}

public static string NewreturnScalar(string Query)

{

string ResultString = "";

sqlcom = new SqlCommand(Query, sqlcon,SqlTran);

ResultString = Convert.ToString(sqlcom.ExecuteScalar());

return ResultString;

}

File Attachment and saving on serving in Silverlight, Using Relay Command in MVVM Structure

2012-11-21T22:37:00.001-08:00

Add Relay Command in View Model

///

/// Rlc Command for Attach Command

///

public RelayCommand rlcAttach

{

get

{

return new RelayCommand(AttachCommand);

}

Property for FilesList to upload

///

/// Property for List of Files To upload

///

public List<FileInfo> FilesToUpload

{

get { return lstFilesToUpload; }

set

{

lstFilesToUpload = value;

RaisePropertyChanged("FilesToUpload");

}

Method getting file information in List FilesToUpload

///

/// Method for go to Attach Command

///

protected void AttachCommand()

{

try

{

OpenFileDialog fileDialog = new OpenFileDialog();

fileDialog.Multiselect = true;

//.doc, .xls, .csv, .txt

if (fileDialog.ShowDialog() == true)

{

FilesToUpload = fileDialog.Files.ToList();

}

catch (Exception ex)

{

//MessageBox.Show(ex.Message);

}

Finally Method To send Files over the server using file handler in Web Project.

///

/// Method for go to Save Command

///

protected void SaveCommand()

{

try

{

foreach (FileInfo file in FilesToUpload)

{

//Define the Url object for the Handler

String ApplicationURL = System.Windows.Browser.HtmlPage.Document.DocumentUri.ToString();

String UploderHandlerURI = ApplicationURL.Substring(0, ApplicationURL.LastIndexOf('/') + 1) + "UploadFileHandler.ashx";

UriBuilder handlerUrl = new UriBuilder(UploderHandlerURI);

//Set the QueryString

handlerUrl.Query = "InputFile=" + file.Name;

FileStream FsInputFile = file.OpenRead();

//Define the WebClient for Uploading the Data

WebClient webClient = new WebClient();

//An async class for writing the file to the server

webClient.OpenWriteCompleted += (s, evt) =>

{

UploadFileData(FsInputFile, evt.Result);

evt.Result.Close();

FsInputFile.Close();

};

webClient.OpenWriteAsync(handlerUrl.Uri);

Attachments.Add(file.Name);

}

catch (Exception)

{

//MessageBox.Show(ex.Message);

}

Supporting Method UploadFileData in above lines....

///

/// The Below Method read the data from the input file stream

/// and write into the out stream

///

private void UploadFileData(Stream inputFile, Stream resultFile)

{

byte[] fileData = new byte[4096];

int fileDataToRead;

while ((fileDataToRead =inputFile.Read(fileData, 0, fileData.Length)) != 0)

{

resultFile.Write(fileData, 0, fileDataToRead);

}

File Handler in Web Project...

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.IO;

namespace DistributionExpress.Web

{

///

/// Summary description for UploadFileHandler

///

public class UploadFileHandler : IHttpHandler

{

public void ProcessRequest(HttpContext context)

{

string filename = context.Request.QueryString["InputFile"].ToString();

using (FileStream fileStream = File.Create(context.Server.MapPath("~/FilesServer/" + filename)))

{

byte[] bufferData = new byte[4096];

int bytesToBeRead;

while ((bytesToBeRead = context.Request.InputStream.Read(bufferData, 0, bufferData.Length)) != 0)

{

fileStream.Write(bufferData, 0, bytesToBeRead);

}

fileStream.Close();

}

public bool IsReusable

{

get

{

return false;

}

Allowing only Decimal values in Text Box Csharp

2012-11-21T22:17:00.002-08:00

You can handle this in keyPress event of Text Box as in following way....

private void textBox1_KeyPress(object sender, KeyPressEventArgs e)

{

if (!char.IsControl(e.KeyChar)

&& !char.IsDigit(e.KeyChar)

&& e.KeyChar != '.')

{

e.Handled = true;

}

// only allow one decimal point

if (e.KeyChar == '.'

&& (sender as TextBox).Text.IndexOf('.') > -1)

{

e.Handled = true;

}

Handling xaml not found error while navigating to non-existing xaml form

2012-09-18T04:11:00.002-07:00

In some cases in your silverlight application the link is present for non-existing or old xaml view form. which does not exist in actual or removed after any updation. In this case while nevigating to this form silverlight runtime exception will occur. To handle this exception you need to add NavigationFailed event for the frame.

In Xaml:

<sdk:Frame Height="175" HorizontalAlignment="Left" Margin="48,92,0,0" Name="frame1" VerticalAlignment="Top" Width="293" BorderBrush="#006C1313" NavigationFailed="frame1_NavigationFailed" />

In Xaml.cs

private void frame1_NavigationFailed(object sender, NavigationFailedEventArgs e)

{

e.Handled = true;

this.frame1.Navigate(new Uri("/Testview/ErrorPage.xaml", UriKind.Relative));

}

How to navigate the frame to another view in another silver-light project under same solution

2012-09-18T04:04:00.000-07:00

You can navigate from one view to another view in different silver-light project under same solution by using the following code.

private void button1_Click(object sender, RoutedEventArgs

{

this.frame1.Navigate(new Uri("/MyNewSDXProject;component/TestViews/MyTestUC.xaml", UriKind.Relative));

}

Xaml will look like this:

<UserControl x:Class="SilverlighProjectTestingApp.MainPage"

xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"

xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"

xmlns:d="http://schemas.microsoft.com/expression/blend/2008"

xmlns:mc="http://schemas.openxmlformats.org/markup-compatibility/2006"

xmlns:navigation="clr-namespace:System.Windows.Controls;assembly=System.Windows.Controls.Navigation"

mc:Ignorable="d"

d:DesignHeight="300" d:DesignWidth="400" xmlns:sdk="http://schemas.microsoft.com/winfx/2006/xaml/presentation/sdk">

<sdk:Frame Height="175" HorizontalAlignment="Left" Margin="48,92,0,0" Name="frame1" VerticalAlignment="Top" Width="293" BorderBrush="#006C1313" NavigationFailed="frame1_NavigationFailed" />

</Grid>

</UserControl>

Updating any Object through Linq Query

2012-04-17T04:43:00.003-07:00

public class TestClass

{

public String RollNo { get; set; }

public String Name { get; set; }

public String ClassName { get; set; }

}

ObservableCollection<TestClass> aaa = new ObservableCollection<TestClass>();

aaa.Add(new TestClass() {

RollNo = "1602", Name = "Khalid Rafique", ClassName = "A" });

aaa.Add(new TestClass() {

RollNo = "1702", Name = "Jamal Ali Khan", ClassName = "A" });

Method1

var result = aaa.Where(c => c.RollNo == "1702");

foreach (TestClass tc in result)

{

tc.Name = textBox4.Text;

tc.ClassName = textBox1.Text;

}

Method2

aaa

.Where(c => c.RollNo == "1702")

.Update(m =>

{

m.Name = textBox4.Text;

m.ClassName = textBox1.Text;

});

Following is the class having extensible Method of Linq update.

public static class LinqExtensableMethods

{

public static void Update(this IEnumerable source, params Action[] updates)

{

if (source == null)

throw new ArgumentNullException("source");

if (updates == null)

throw new ArgumentNullException("updates");

foreach (T item in source)

{

foreach (Action update in updates)

{

update(item);

}

Method3

var result = ocTextClass .Where(c => c.RollNo == "1702").ToList().ForEach(tc => tc.Name=TextBox.Text);

Creating Cut, Copy, Paste Context menu for all textboxs in silverlight using Style in App.xaml

2012-04-16T22:59:00.000-07:00

This article will provide you the help for creating Cut, Copy, Paste Context menu for all textboxs in silverlight using Style in App.xaml. This style will work for every Textbox that you will add in any form of your application..

App.xaml

xmlns:my="clr-namespace:YourApplicationNameSpace"

<Application.Resources>

Style>

Application.Resources>

ControlCustomBehaviors.cs

using System;

using System.Net;

using System.Windows;

using System.Windows.Controls;

using System.Windows.Documents;

using System.Windows.Ink;

using System.Windows.Input;

using System.Windows.Media;

using System.Windows.Media.Animation;

using System.Windows.Shapes;

using System.Windows.Interactivity;

namespace YourApplicationNameSpace

{

public class ControlCustomBehaviors : Behavior<Control>

{

#region Set Context Menu

public static DependencyProperty SetMenuProperty =

DependencyProperty.RegisterAttached("SetMenu",

typeof(object),

typeof(ControlCustomBehaviors), new PropertyMetadata(null, SetMenuProp));

private static TextBox tBox;

private static void SetMenuProp(DependencyObject d, DependencyPropertyChangedEventArgs e)

{

tBox = d as TextBox;

CreateMenu();

tBox.MouseRightButtonDown += new MouseButtonEventHandler(AssociatedObject_MouseRightButtonDown);

tBox.MouseRightButtonUp += new MouseButtonEventHandler(AssociatedObject_MouseRightButtonUp);

tBox.SetValue(ContextMenuService.ContextMenuProperty, _contextMenu);

}

public static object GetSetMenu(UIElement obj)

{

return (object)obj.GetValue(SetMenuProperty);

}

public static void SetSetMenu(DependencyObject obj, object txtbox)

{

obj.SetValue(SetMenuProperty, txtbox);

}

private static ContextMenu _contextMenu;

private static MenuItem _copy;

private static MenuItem _cut;

private static MenuItem _paste;

private static void CreateMenu()

{

_contextMenu = new ContextMenu();

_cut = new MenuItem();

_cut.Header = "Cut";

_cut.Click += new RoutedEventHandler(cut_Click);

_contextMenu.Items.Add(_cut);

_copy = new MenuItem();

_copy.Header = "Copy";

_copy.Click += new RoutedEventHandler(copy_Click);

_contextMenu.Items.Add(_copy);

_paste = new MenuItem();

_paste.Header = "Paste";

_paste.Click += new RoutedEventHandler(paste_Click);

_contextMenu.Items.Add(_paste);

}

static void paste_Click(object sen, RoutedEventArgs e)

{

tBox.SelectedText = Clipboard.GetText();

_contextMenu.IsOpen = false;

tBox.Focus();

}

static void cut_Click(object sen, RoutedEventArgs e)

{

Clipboard.SetText(tBox.SelectedText);

tBox.SelectedText = string.Empty;

_contextMenu.IsOpen = false;

tBox.Focus();

}

static void copy_Click(object sen, RoutedEventArgs e)

{

Clipboard.SetText(tBox.SelectedText);

_contextMenu.IsOpen = false;

tBox.Focus();

}

static void AssociatedObject_MouseRightButtonUp(object Sender, MouseButtonEventArgs e)

{

if (Clipboard.ContainsText() && tBox.IsReadOnly == false && tBox.IsEnabled == true)

{

_paste.IsEnabled = true;

}

else

{

_paste.IsEnabled = false;

}

if (string.IsNullOrEmpty(tBox.SelectedText))

{

_cut.IsEnabled = false;

_copy.IsEnabled = false;

}

else

{

_cut.IsEnabled = true;

_copy.IsEnabled = true;

}

_contextMenu.IsOpen = true;

tBox.Focus();

}

static void AssociatedObject_MouseRightButtonDown(object sender, MouseButtonEventArgs e)

{

tBox = sender as TextBox;

e.Handled = true;

}

#endregion

}

How to find the nth Highest Salary from Employee Table

2012-04-13T05:01:00.000-07:00

You can find out the nth Highest Salary from the Employee Table by using following systax

select top 1 * from testEmp
where Emp_Id not in
(select top (n-1) Emp_Id from testEmp order by salary desc)
order by salary desc

Let Suppose following is you table

Emp_Id	Employee_Name	Salary
1602	Khalid Rafique	40000
1650	Jamal Ali Khan	45000
1530	Farhan Khan	29000
1533	Abid sultan	33000
1535	Atiq Khan	38000
1730	Rashid Ali	21000

if you want to find 2nd highest salary, you need to have to write the following query

select top 1 * from testEmp 
where Emp_Id not in
(select top (2-1) Emp_Id from testEmp order by salary desc)
order by salary desc

Result:

Emp_Id	Employee_Name	Salary
1602	Khalid Rafique	40000

if you want to find 3rd highest salary, you need to have to write the following query

select top 1 * from testEmp 
where Emp_Id not in
(select top (3-1) Emp_Id from testEmp order by salary desc)
order by salary desc

Result:

Emp_Id	Employee_Name	Salary
1535	Atiq Khan	38000

if you want to find 4rd highest salary, you need to have to write the following query

select top 1 * from testEmp 
where Emp_Id not in
(select top (4-1) Emp_Id from testEmp order by salary desc)
order by salary desc

Result:

Emp_Id	Employee_Name	Salary
1533	Abid sultan	33000

How to find the dupliate record in sql w.r.t columns

2012-04-13T02:34:00.001-07:00

You can find the duplicate record using the folloing query with respect to columns sal and age
if you have Users table

LoginId	Password	UserName	Sal	Age
admin	1153291460	Khalid Rafique	1100.00000000	25
asdf	tyro1	aa	1200.00000000	28
tyro	tyro1	Test Account	1200.00000000	28
tyro23	tyro1	Test Account	1200.00000000	28

One Way

select u1.* from Users u1 
inner join
  (select Sal, Age,COUNT(*)as [Count] from Users

   group by Sal,Age
   having COUNT(*)>1) 
as t1
on u1.Sal = t1.Sal and u1.Age =t1.Age

2nd Way

select * from Users
where CAST(Sal as varchar)+'-'+CAST(Age as varchar) in
(select CAST(Sal as varchar)+'-'+CAST(Age as varchar) from Users
 group by Sal,Age
 having COUNT(*)>1)

following will be the result of Query:

LoginId	Password	UserName	Sal	Age
asdf	tyro1	aa	1200.00000000	28
tyro	tyro1	Test Account	1200.00000000	28
tyro23	tyro1	Test Account	1200.00000000	28

How to create own Grid property binder class in silver light

2012-04-03T00:12:00.002-07:00

    
public static class GridPropertyBinder
{
  #region Visibility
  public static readonly DependencyProperty VisibilityBindingProperty = 
            DependencyProperty.RegisterAttached(
                                                "VisibilityBinding",
                                                typeof(object),
                                                typeof(GridPropertyBinder),
                                                new PropertyMetadata(null,
GridPropertyBinder.VisibilityBinding_PropertyChanged));

  public static object GetVisibilityBinding(DependencyObject source)
  {
     return (object)source.GetValue(GridPropertyBinder.VisibilityBindingProperty);
  }
  public static void SetVisibilityBinding(DependencyObject target, 
                                          object value)
  {
     target.SetValue(GridPropertyBinder.VisibilityBindingProperty, value);
  }
  private static void VisibilityBinding_PropertyChanged(DependencyObject d, 
                                                        DependencyPropertyChangedEventArgs e)
  {
     DataGridColumn column = d as DataGridColumn;
     if (column == null) { return; }
     if ((bool)e.NewValue)
     {
       column.Visibility = Visibility.Visible;
     }
     else
     {
        column.Visibility = Visibility.Collapsed;
     }
  }
  #endregion
}