1000 Projects
<<<Classroom & Online Training's on android, Java, .Net, C, C++, Big Data Hadoop, SAP, SQL, Oracle, Sales Force>>>

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:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
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.


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.