public String insertRegistrationDetails(String userdetails)
{
String str = "Inserted data";
stringmessage message = new stringmessage();
String cs = System.Configuration.ConfigurationManager.ConnectionStrings["dbString"].ConnectionString;
System.Data.SqlClient.SqlConnection con = new System.Data.SqlClient.SqlConnection(cs);
System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand();
//SqlDataReader rdr = null;
try
{
con.Open();
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = "INSERT REGISTRATION (FIRSTNAME,LASTNAME,USERNAME,PASSWORD,EMAILADDRESS,PHONENUMBER,ADDRESS,ZIPCODE,STATUS) VALUES (" + userdetails + ")";
cmd.Connection = con;
cmd.ExecuteNonQuery();
con.Close();
}
catch (Exception e)
{
str = str + "Exception in insert" + e;
}
return(str);
}
public String insertRegistrationDetails(String details)
{
String str = "xyz";
stringmessage message = new stringmessage();
String cs = System.Configuration.ConfigurationManager.ConnectionStrings["dbString"].ConnectionString;
System.Data.SqlClient.SqlConnection con = new System.Data.SqlClient.SqlConnection(cs);
System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand();
//SqlDataReader rdr = null;
str = str + "1";
try
{
con.Open();
str = str + "2";
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = "INSERT REGISTRATION (FIRSTNAME,LASTNAME,USERNAME,PASSWORD,EMAILADDRESS,PHONENUMBER,DATEOFBIRTH,ADDRESS,ZIPCODE) VALUES (" + details + ")";
//cmd.CommandText = "INSERT login (email,password) VALUES (" + userDetails + ")";
str = str + "3";
/*cmd.CommandText = "INSERT UserDetails (email,password,firstName,lastName,phno,address,city,state,zipCode) VALUES ('" + userDetails.getEmail() + "'," +
* userDetails.getZipCode() + ")"; */
cmd.Connection = con;
cmd.ExecuteNonQuery();
str = str + "4";
con.Close();
str = str + "Inserted data";
}
catch (Exception e)
{
str = str + "Exception in insert" + e;
}
message.msg = str;
return(str);
}
public userDetails retrieveUserDetails(String username)
{
userDetails user = new userDetails();
List <userDetails> userdetaillist = new List <userDetails>();
String str = "Inserted data";
stringmessage message = new stringmessage();
String cs = System.Configuration.ConfigurationManager.ConnectionStrings["dbString"].ConnectionString;
System.Data.SqlClient.SqlConnection con = new System.Data.SqlClient.SqlConnection(cs);
System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand();
//SqlDataReader rdr = null;
try
{
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["dbString"].ConnectionString);
conn.Open();
SqlCommand cmd1 = new SqlCommand("Select * From REGISTRATION WHERE USERNAME= '******'", conn);
SqlDataReader reader = cmd1.ExecuteReader();
//String userName = ""; String pwd = "";
while (reader.Read())
{
user.username = reader.GetString(2);
user.emailaddress = reader.GetString(4);
user.mobilenumber = reader.GetDecimal(5);
user.address = reader.GetString(6);
user.zipcode = reader.GetDecimal(7);
}
reader.Close();
conn.Close();
}
catch (Exception e)
{
str = str + "Exception in insert" + e;
}
return(user);
}
public String insertItemDetails(String itemDetails)
{
String str = "";
//String insertJobDetails = items;
// insertJobDetails = insertJobDetails + ",sysdatetime(),sysdatetime(),'P'";
stringmessage message = new stringmessage();
string cs = System.Configuration.ConfigurationManager.ConnectionStrings["dbString"].ConnectionString;
System.Data.SqlClient.SqlConnection con = new System.Data.SqlClient.SqlConnection(cs);
System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand();
//SqlDataReader rdr = null;
try
{
con.Open();
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = "INSERT ITEMS (ITEMNAME,ITEMCATEGORY,QUANTITY,DATECREATED,CREATEDBY,YEARSOFUSAGE) VALUES (" + itemDetails + ")";
// cmd.CommandText = "INSERT JobDetails (ShortDescription,LongDescription,SkillSet,JobAddress,JobCity,JobZipCode,JobPay,JobDate,Category,SubCategory,CreatedBy,CreationDate,) VALUES ('testshort','testlong','testskill','test','test',64111,35,'3/10/2015','test','test','test',sysdatetime())";
cmd.Connection = con;
cmd.ExecuteNonQuery();
con.Close();
str = str + "Inserted data";
}
catch (Exception e)
{
str = str + "Exception in insert" + e;
}
message.msg = str;
return(str);
}
public String insertLoginDetails(String logindetails)
{
String str = "Inserted data";
stringmessage message = new stringmessage();
String cs = System.Configuration.ConfigurationManager.ConnectionStrings["dbString"].ConnectionString;
System.Data.SqlClient.SqlConnection con = new System.Data.SqlClient.SqlConnection(cs);
System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand();
//SqlDataReader rdr = null;
try
{
con.Open();
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = "INSERT LOGIN (USERNAME,PASSWORD) VALUES (" + logindetails + ")";
// cmd.CommandText = "INSERT LOGIN (USERNAME,PASSWORD) VALUES (" + logindetails + ")";
/*cmd.CommandText = "INSERT UserDetails (email,password,firstName,lastName,phno,address,city,state,zipCode) VALUES ('" + userDetails.getEmail() + "'," +
* userDetails.getZipCode() + ")"; */
cmd.Connection = con;
cmd.ExecuteNonQuery();
con.Close();
}
catch (Exception e)
{
str = str + "Exception in insert" + e;
}
return(str);
}
