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