public bool InsertNewUser(User _user) { try { using (SqlConnection con = new SqlConnection(GetConnectionString.connect())) { con.Open(); SqlCommand cmd = new SqlCommand("INSERT INTO [DhwUsers] (FirstName,LastName,Email,[Mobile],[Address],Pincode) Values (@Firstname,@lastname,@email,@mobile,@address,@pincode)", con); cmd.Parameters.AddWithValue("@Firstname", _user.FirstName); cmd.Parameters.AddWithValue("@lastname", _user.LastName); cmd.Parameters.AddWithValue("@email", _user.Email); cmd.Parameters.AddWithValue("@mobile", _user.MobileNO); cmd.Parameters.AddWithValue("@address", _user.Address); cmd.Parameters.AddWithValue("@pincode", _user.Pincode); cmd.ExecuteNonQuery(); con.Close(); } return(true); } catch { //Log(ex) return(false); } }
internal bool InsertCommandData(CommandService cmdService) { using (SqlConnection con = new SqlConnection(GetConnectionString.connect())) { try { con.Open(); SqlCommand cmd = new SqlCommand(string.Format("INSERT INTO [dbo].[MalayalamLanguageBase]([MalayalamWord],[Manglish])VALUES(N'{0}' ,@Manglish)", cmdService.Malayalam), con); cmd.Parameters.AddWithValue("@Manglish", cmdService.Manglish); cmd.ExecuteNonQuery(); return(true); } catch (Exception) { return(false); } finally { con.Close(); } } }
internal List <CommandService> GetAllCommands() { List <CommandService> listcmd = new List <CommandService>(); using (SqlConnection con = new SqlConnection(GetConnectionString.connect())) { try { con.Open(); SqlCommand cmd = new SqlCommand("Select * from MalayalamLanguageBase", con); SqlDataReader rdr = cmd.ExecuteReader(); if (rdr.HasRows) { while (rdr.Read()) { CommandService MalCmd = new CommandService { Malayalam = rdr["MalayalamWord"].ToString(), Manglish = rdr["Manglish"].ToString() }; listcmd.Add(MalCmd); } } } catch (Exception) { throw; } finally { } } return(listcmd); }
public bool InsertData(CommandService cmdService) { try { using (SqlConnection con = new SqlConnection(GetConnectionString.connect())) { con.Open(); SqlCommand cmd = new SqlCommand("INSERT INTO [dbo].[DhwCommand] ([Manglish],[Malayalam] )VALUES (@Manglish,@Malayalam)", con); cmd.Parameters.AddWithValue("@Manglish", cmdService.Manglish); cmd.Parameters.AddWithValue("@Malayalam", cmdService.Malayalam); cmd.ExecuteNonQuery(); con.Close(); } return(true); } catch { //Log(ex) return(false); } }