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); }