1000 Projects

Back To My Village Project SRS

June 21, 2012

The main objective of developing this Back To My Village Project Software requirement specification is to find the requirements of the software system like developing language, back end software, other external software’s used in this Back To My Village Project SRS.


Find the below Login details Code for Back To My Village Project:

using System;
using System.Data;
using System.Configuration;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.SqlClient;
using BackToMyVillage;
///


<summary><code> /// Summary description for clsLogin
/// </code></summary>

&nbsp;

public class clsLogin
{
public clsLogin()
{
//
// TODO: Add constructor logic here
//
}
public static string UserName { get; set; }
public static string Password { get; set; }
public static string Role { get; set; }

//public string GetUserLogin()
//{
// try
// {
// SqlParameter[] p = new SqlParameter[3];

// p[0] = new SqlParameter("@UserName", UserName);
// p[0].SqlDbType = SqlDbType.VarChar;

// p[1] = new SqlParameter("@Password", Password);
// p[1].SqlDbType = SqlDbType.VarChar;

// p[2] = new SqlParameter("@Role", SqlDbType.VarChar, 20);
// p[2].Direction = ParameterDirection.Output;

// SqlHelper.ExecuteNonQuery(Connection.con, CommandType.StoredProcedure, "sp_EmpLoginChecking", p);

// return this.Role = Convert.ToString(p[2].Value.ToString());
// }
// catch (Exception ex)
// {
// throw new ArgumentException(ex.Message);
// }
//}

SqlConnection cn;
SqlCommand cmd;

public int GetUserId()
{
try
{
cn = new SqlConnection(Connection.con);
cn.Open();
cmd = new SqlCommand("select max(UserId) from tbl_UserMaster", cn);
int id = Convert.ToInt32(cmd.ExecuteScalar());
return id;
}
catch (Exception ex)
{
throw new ArgumentException(ex.Message);
}
}

public object GetUserIdByLoginDetails(string str1, string p)
{
try
{
cn = new SqlConnection(Connection.con);
cn.Open();
cmd = new SqlCommand("select UserId from tbl_UserLogin where User_LoginId='" + str1 + "' and User_Password='" + p + "'", cn);
int id = Convert.ToInt32(cmd.ExecuteScalar());
return id;
}
catch (Exception ex)
{
throw new ArgumentException(ex.Message);
}
}
public string GetUserLogin(out int Id)
{
try
{
SqlParameter[] p = new SqlParameter[4];

p[0] = new SqlParameter("@LoginName", UserName );
p[1] = new SqlParameter("@Password", Password);
p[2] = new SqlParameter("@Role", SqlDbType.VarChar, 50);
p[2].Direction = ParameterDirection.Output;
p[3] = new SqlParameter("@Vole_Mem_id", SqlDbType.Int);
p[3].Direction = ParameterDirection.Output;

SqlHelper.ExecuteNonQuery(Connection.con, CommandType.StoredProcedure, "spLoginChecking", p);
Role = Convert.ToString(p[2].Value);
if (Role != "NoUser")
Id = Convert.ToInt32(p[3].Value);
else
Id = 0;
return Role;
}
catch (Exception ex)
{
throw new ArgumentException(ex.Message);
}
}

/////
////
public static void ActiveVolunteerOnlineStatus(int Id)
{
try
{
string str = "Update tbl_VolunteerOnline set [status]=1 where VounteerId=" + Id;
SqlHelper.ExecuteNonQuery(Connection.con, CommandType.Text, str);
}
catch (Exception ex)
{
throw new ArgumentException(ex.Message);
}
}

public static void InActiveVolunteerOnlineStatus(int Id)
{
try
{
string str = "Update tbl_VolunteerOnline set [status]=0 where VolunteerId=" + Id;
SqlHelper.ExecuteNonQuery(Connection.con, CommandType.Text, str);
}
catch (Exception ex)
{
throw new ArgumentException(ex.Message);
}
}

public static void ActiveMemberOnlineStatus(int Id)
{
try
{
string str = "Update tbl_MenberOnline set [status]=1 where MemberId=" + Id;
SqlHelper.ExecuteNonQuery(Connection.con, CommandType.Text, str);
}
catch (Exception ex)
{
throw new ArgumentException(ex.Message);
}
}

public static void InActiveMemberOnlineStatus(int Id)
{
try
{
string str = "Update tbl_MemberOnline set [status]=0 where MemberId=" + Id;
SqlHelper.ExecuteNonQuery(Connection.con, CommandType.Text, str);
}
catch (Exception ex)
{
throw new ArgumentException(ex.Message);
}
}

public static DataSet GetOnlineVolunteerData()
{
try
{
return SqlHelper.ExecuteDataset(Connection.con, CommandType.StoredProcedure, "sp_GetOnlineVolunteerData");
}
catch (Exception ex)
{
throw new ArgumentException(ex.Message);
}
}

public static DataSet GetOnlineMemberData()
{
try
{
return SqlHelper.ExecuteDataset(Connection.con, CommandType.StoredProcedure, "sp_GetOnlineMemberData");
}
catch (Exception ex)
{
throw new ArgumentException(ex.Message);
}
}
}

Download Back To My Village Project SRS (Software Requirement Specification), Paper Presentation, Documentation, full Code.


The following two tabs change content below.
Hi, Find more on FB...

Latest posts by Ramesh Gavva/Kasarla shanthan (see all)

posted in CSE Projects with Source Code by Ramesh Gavva/Kasarla shanthan

Follow comments via the RSS Feed | Leave a comment | Trackback URL


‹‹‹ Back to My Village Project Abstract

Back To My Village Project Documentation ›››

Custom Search

Leave Your Comment

 
Copyright 2014 | Powered by 1000Projects.org | Developed by WikiHands.