public static void UpdateData(IJPDetails objEmployee, int Id) //Update data in database { using (var con = new SqlConnection(Constr)) { var query = @" UPDATE [dbo].[IJPDetails] SET [Job] = '" + objEmployee.Job + "',[Experience] = '" + objEmployee.Experience + "',[LastDate] = '" + objEmployee.LastDate + "',[ApplicationReceived] = '" + objEmployee.ApplicationReceived + "',[Quantity] = '" + objEmployee.Quantity + "',[IJPStatus] = '" + objEmployee.IJPStatus + "'WHERE Id='" + Id + "'"; con.Open(); var cmd = new SqlCommand(query, con); cmd.ExecuteNonQuery(); con.Close(); } }
public static void SaveUser(IJPDetails objEmployee) //Insert data in database { using (var con = new SqlConnection(Constr)) { using (var cmd = new SqlCommand("INSERT INTO [dbo].[IJPDetails] VALUES(@Job,@Experience,@LastDate,@ApplicationReceived,@Quantity,@IJPStatus)")) { cmd.CommandType = CommandType.Text; cmd.Parameters.AddWithValue("@Job", objEmployee.Job); cmd.Parameters.AddWithValue("@Experience", objEmployee.Experience); cmd.Parameters.AddWithValue("@LastDate", objEmployee.LastDate); cmd.Parameters.AddWithValue("@ApplicationReceived", objEmployee.ApplicationReceived); cmd.Parameters.AddWithValue("@Quantity", objEmployee.Quantity); cmd.Parameters.AddWithValue("@IJPStatus", objEmployee.IJPStatus); cmd.Connection = con; con.Open(); cmd.ExecuteNonQuery(); con.Close(); } } }