public static List <UsersTable> GetAll()
{
DBOperations objdb = new DBOperations(Properties.Settings.Default.payRoll);
List <UsersTable> lstUsersTable = new List <UsersTable>();
UsersTable objUsersTable = new UsersTable();
string strGetOneRecord = "SELECT * FROM [UsersTable]";
string[] strAddParameterName = new string[] { };
object[] objAddparametervalue = new object[] { };
DataTable objtab = new DataTable();
objtab = objdb.ExecuteGetAllQuery(strGetOneRecord, strAddParameterName, objAddparametervalue);
for (int i = 0; i < objtab.Rows.Count; i++)
{
int intId;
objUsersTable = new UsersTable();
int.TryParse(objtab.Rows[i]["Id"].ToString(), out intId);
objUsersTable.Id = intId;
objUsersTable.Name = objtab.Rows[i]["Name"] != null ? objtab.Rows[i]["Name"].ToString() : string.Empty;
objUsersTable.Password = objtab.Rows[i]["Password"] != null ? objtab.Rows[i]["Password"].ToString() : string.Empty;
lstUsersTable.Add(objUsersTable);
}
return(lstUsersTable);
}
/* public Response Delete()
* {
* DBOperations objdb = new DBOperations(Properties.Settings.Default.payRoll);
* string strDelete = "DELETE FROM [UsersTable] WHERE Id=@Id";
* string[] strAddParameterName = new string[] { "Id" };
* object[] objAddparametervalue = new object[] { this.Id };
* if (!objdb.ExecuteQuery(strDelete, strAddParameterName, objAddparametervalue))
*
* return new Response(9999, string.Format(Failure_MSG, "delete"));
* else
*
* return new Response(5555, string.Format(SUCCESS_MSG, "deleted"));
* }
*
* public Response Update()
* {
* DBOperations objdb = new DBOperations(Properties.Settings.Default.payRoll);
* string strUpsate = @"UPDATE [SuperMarket].[dbo].[UsersTable]
* SET [Name] = @Name
* ,[Password] = @Password, nvarchar(50),>
* WHERE Id=@Id ";
* string[] strAddParameterName = new string[] { "Name", "Password", "Id" };
* object[] objAddparametervalue = new object[] { this.Name, this.Password, this.Id };
* if (!objdb.ExecuteQuery(strUpsate, strAddParameterName, objAddparametervalue))
* return new Response(9999, string.Format(Failure_MSG, "update"));
* else
* return new Response(5555, string.Format(SUCCESS_MSG, "updated"));
* }*/
public static UsersTable Get(int workerId)
{
DBOperations objdb = new DBOperations(Properties.Settings.Default.payRoll);
UsersTable objUsersTable = new UsersTable();
string strGetOneRecord = "SELECT * FROM [Transaction] where Id=@Id";
string[] strAddParameterName = new string[] { "Id" };
object[] objAddparametervalue = new object[] { objUsersTable.Id };
System.Data.DataTable objtab = objdb.ExecuteGetAllQuery(strGetOneRecord, strAddParameterName, objAddparametervalue);
return(objUsersTable);
}
public Response Delete(UsersTable objUsersTable)
{
DBOperations objdb = new DBOperations(Properties.Settings.Default.payRoll);
string strDelete = "DELETE FROM [UsersTable] WHERE Id=@Id";
string[] strAddParameterName = new string[] { "Id" };
object[] objAddparametervalue = new object[] { objUsersTable.Id };
if (!objdb.ExecuteQuery(strDelete, strAddParameterName, objAddparametervalue))
{
return(new Response(9999, string.Format(Failure_MSG, "delete")));
}
else
{
return(new Response(5555, string.Format(SUCCESS_MSG, "deleted")));
}
}
public Response Create(UsersTable objUsersTable)
{
SQLConnector.DBOperations objdb = new DBOperations(Properties.Settings.Default.payRoll);
string stInsert = @"INSERT INTO [UsersTable]([Name] ,[Password])
VALUES (@Name,@Password)";
string[] strAddParameterName = new string[] { "Name", "Password" };
object[] objAddparametervalue = new object[] { objUsersTable.Name, objUsersTable.Password };
if (!objdb.ExecuteQuery(stInsert, strAddParameterName, objAddparametervalue))
{
return(new Response(9999, string.Format(Failure_MSG, "insert")));
}
else
{
return(new Response(5555, string.Format(SUCCESS_MSG, "inserted")));
}
}
public Response Update(UsersTable objUsersTable)
{
DBOperations objdb = new DBOperations(Properties.Settings.Default.payRoll);
string strUpsate = @"UPDATE [SuperMarket].[dbo].[UsersTable]
SET [Name] = @Name
,[Password] = @Password, nvarchar(50),>
WHERE Id=@Id ";
string[] strAddParameterName = new string[] { "Name", "Password", "Id" };
object[] objAddparametervalue = new object[] { objUsersTable.Name, objUsersTable.Password, objUsersTable.Id };
if (!objdb.ExecuteQuery(strUpsate, strAddParameterName, objAddparametervalue))
{
return(new Response(9999, string.Format(Failure_MSG, "update")));
}
else
{
return(new Response(5555, string.Format(SUCCESS_MSG, "updated")));
}
}